\fCase Study 9.2 (Wings Of Fire) Hints: Pick-up time and Drive time must be combined so you will analyze \"Total Time\" For task 1, use Excel's Data Analysis Tool > Descriptive Statistics to calculate performance measures For task 2, when you conduct your hypothesis test, your alternative hypothesis is that the total time for a customer to receive an order is less than 30 minutes: Ha: U < 30 minutes. For task 3, you need to decide the appropriate hypothesis test to compare the sample mean total delivery time in your data with the 30 minute standard. Note that we do not know the population standard deviation, only the sample standard deviation. For background, a good example to follow is Example 9-8 beginning on page 353 of your text. For task 4, estimating the probability of an order taking longer than 30 minutes, you can either of two approaches: o Use the sample data to arrive at a relative frequency (see p. 33 in your text for a definition), and then calculate a 95% confidence interval around that relative frequency (proportion) using formula 8.10 on page 322......OR..... o Calculate the probability of an order taking more than 30 minutes from the distribution, using your sample mean delivery time and standard deviation you calculated in task 1 from the data, and 30 minutes as your \"x\" value, using the formula 6.2 on p. 227. The Fruit Production example on pages 227-231 show you how to calculate your z-score and then determine the probability of getting that z-score using the standard normal table. If you don't want to use the table to determine your probability, then you can use Excel's function NORM.DIST (see p.234), where you can plug in your x value (30), and the mean and standard deviation of delivery time from your data, make sure the \"Cumulative\" box says \"TRUE\Pick-up Time 4.94 0 4.98 5.03 4.15 4.67 5.01 3.88 2.8 2.71 2.79 4.73 5.2 4.18 5.57 2.73 4.4 0 3.41 4.16 3.6 5.45 0 3.96 4.54 0 4.21 3.22 0 5.55 6.35 5.14 6.11 3.95 4.54 2.23 4.99 4.83 5.03 3.56 5.15 5.69 3.59 3.39 2.77 0 4.25 3.97 Drive Time 26.96 21.73 19.74 20.08 19.04 16.17 14.93 23.92 17.15 20.97 25.83 15.41 15.53 17.02 23.2 18.19 20.94 17.46 16.33 22.54 23.52 3.3 22.87 18.31 24.82 13.22 19.64 14.11 23.69 15.04 21.59 10.81 20.46 15.56 22.54 25.29 22.81 23.45 21.01 21.94 24.63 24.13 15.52 28.15 22 15.34 20.36 13.7 3.1 4.13 3.81 0 3.95 5.97 4.1 4.21 3.83 3.93 4.74 0 5.61 3.8 4.46 3.7 6.06 4.83 3.16 2.5 5.63 4.41 5.26 0 3.26 5.12 5.07 0 4.14 4.75 3.67 3.02 3.47 3.3 2.77 3.2 0 0 6.27 6.4 4.67 3.41 0 4.25 4.61 4.41 5.31 2.76 4.64 21.92 22.73 16.73 21.96 16.91 22.25 18.49 14.76 24.01 8.64 20.57 17.59 20.93 17 23.17 13.58 14 17.44 21.92 20.87 7.43 13.93 20.01 19.71 19.72 17.72 19.5 16.47 18.78 15.99 24.15 24.52 18.5 18.96 17.92 11.21 22.32 15.2 17.14 16.06 24.99 12.83 20.75 19.33 17.87 18.95 23.54 15.15 23.23 4.31 4.39 0 4.93 5.14 0 6.36 2.99 3.11 3.52 2.97 2.62 5.59 5.08 4.02 0 4.93 0 0 6.44 5.01 4.41 7.63 0 5.53 4.87 0 0 3.83 5.63 0 0 4.7 0 3.68 5.36 0 0 5.59 5.93 2.86 3.6 6.19 2.51 0 3.72 6.15 3.45 4.43 21.95 22.47 11.58 20.03 13.06 17.48 19.89 17.26 14.13 21.42 24.67 26.47 21.36 21.29 17.99 25.58 14.15 16.34 12.29 21.97 24.75 13.92 19.18 17.15 11.83 21.49 10.82 18.62 8.91 23.38 17.37 8.9 12.29 27.79 18.96 21.22 19.49 19.52 21.25 16.09 19.37 17.12 19.02 15.97 21.74 22.34 21.16 22.01 22.36 0 4.27 5.34 3.31 4.49 3.02 2.64 0 0 2.5 3.66 4.11 5.03 4.57 4.76 3.95 4.04 5.4 2.91 0 2.4 3.09 6.13 4.64 7.14 5.57 2.82 5.9 4.77 6.44 3.37 3.82 4.69 0 3.02 4.64 0 4.45 4.42 4.46 4.37 3.91 5.76 0 0 2.82 5.92 4.94 5.87 22.97 15 24.78 9.4 15.24 21.07 20.98 19.67 22.96 18.82 15.54 18.02 17.2 26.12 12.22 23.28 25.02 16.38 16.71 9.75 21.67 16.68 25.22 17.55 15.86 17.02 25.08 17.57 18.85 17.13 21.08 19.51 26.74 18.48 20.32 26.25 19.1 21.83 22.12 22.43 21.01 12.04 13.02 11.39 19.78 17.14 19.84 19.92 19.49 4.07 7.22 5.24 0 3.71 22.32 16.59 15.48 10.6 18.4 Column B, Pick-up Time, is the amount of time (in minutes) a packaged order had to wait to be picked up by a delivery driver. Column C, Drive Time, is the amount of time (in minutes) required to deliver the packaged order to the customer after it has been picked up by the driver. File: Wings of Fire.xlsx \f\f