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 |