### Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

# Question 1: Using the data given below, complete Task 1 and provide a very brief, general description of whether or not you believe NEWS is effectively satisfying their customer's desired shipment date. ANSWER: Question 2: Using the data given below, complete Task 2 and provide a brief statistical description of how the results relate to the customer's requirements. NOTE: A statistically significant answer to the question requires a hypothesis test using inferential statistics, which is not required.

 NEWS customers require a delivery time of 30 days at their door from the date that the order was received. NEWS has provided data of their last 50 shipments:  Duration = Delivery Date at the Door – Date Order was Received Question 1:  Using the data given below, complete Task 1 and provide a very brief, general description of whether or not you believe NEWS is effectively satisfying their customer’s desired shipment date. ANSWER: Question 2:  Using the data given below, complete Task 2 and provide a brief statistical description of how the results relate to the customer’s requirements. NOTE:  A statistically significant answer to the question requires a hypothesis test using inferential statistics, which is not required. ANSWER: Order Duration (Calendar Days) 1 11 2 30 Task 1:  Create a Histogram 3 19 Step 1: Select DATA from the tool bar above and then the DATA ANAYSIS TOOL icon on the far right. 4 35 Step 2: Select HISTOGRAM, and in the Input Range, highlight the column of DURATION (Calendar Days). 5 13 Step 3: Leave the Bin Blank (Excel will determine this for you). In “New Worksheet Ply” type “Histogram Bins” 6 39 Step 4: Excel creates a new Worksheet named Histogram Bins with a count of each data point per Bin. 7 4 Step 5: In the Histogram Bin worksheet, highlight the data and then select the Quick Analysis icon. 8 23 Step 6: Select Charts. Select Clustered Vertical Bars and then repeat and select Lines. 9 34 Step 7: The first provides a Histogram; the second provides a Frequency Plot. 10 37 Place the Histogram and Frequency Plot side by side below this row