|
|
| | 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 |
| | 11 | 6 |
| | 12 | 24 |
| | 13 | 9 |
| | 14 | 26 |
| | 15 | 35 |
| | 16 | 25 |
| | 17 | 5 |
| | 18 | 18 |
| | 19 | 14 |
| | 20 | 29 |
| | 21 | 20 |
| | 22 | 25 |
| | 23 | 21 |
| | 24 | 24 |
| | 25 | 22 |
| | 26 | 13 |
| | 27 | 14 |
| | 28 | 28 |
| | 29 | 26 |
| | 30 | 34 |
| | 31 | 18 |
| | 32 | 40 |
| | 33 | 15 |
| | 34 | 18 |
| | 35 | 29 |
| | 36 | 26 |
| | 37 | 23 | | Task 2: Descriptive Statistics |
| | 38 | 36 | | Step 1: Select DATA from the tool bar above and then the DATA ANAYSIS TOOL icon on the far right. |
| | 39 | 42 | | Step 2: Select DESCRIPTIVE STATISTICS, and in the Input Range, highlight the column of DURATION (Calendar Days), Grouped by Columns. |
| | 40 | 33 | | Step 3: In "New Worksheet Ply" type Descriptive Statistics and Excel creates a new Worksheet containing the calculations. |
| | 41 | 15 | | Step 4: Check the box SUMMARY STATISTICS. Open the new worksheet and observe: Mean, Median, and Standard Deviation. |
| | 42 | 22 |
| | 43 | 39 | | MEAN = |
| | 44 | 22 |
| | 45 | 21 | | MEDIAN = |
| | 46 | 14 |
| | 47 | 16 | | STD DEV = |
| | 48 | 44 |
| | 49 | 18 |
| | 50 | 22 |
lailahcat
MBA.xls
