Question

US Airways conducted a number of studies that indicated a substantial savings could be obtained by encouraging Dividend Miles frequent flyer customers to redeem miles and schedule award flights online (US Airways Attache, February 2003 ). One study collected data on the amount of time required to redeem miles and schedule an award flight over the telephone. A sample showing the time in minutes required for each of 150 award flights scheduled by telephone is contained in the data set Flights. Use Excel to help answer the following questions. $$ \begin{array}{l}{\text { a. What is the sample mean number of minutes required to schedule an award flight by }} \\ {\text { telephone? }} \\ {\text { b. What is the } 95 \% \text { confidence interval for the population mean time to schedule an }} \\ {\text { award flight by telephone? }}\end{array} $$ $$ \begin{array}{l}{\text { c. Assume a telephone ticket agent works } 7.5 \text { hours per day. How many award flights can }} \\ {\text { one ticket agent be expected to handle a day? }}\end{array} $$ $$ \begin{array}{l}{\text { d. Discuss why this information supported US Airways' plans to use an online system to }} \\ {\text { reduce costs. }}\end{array} $$

          US Airways conducted a number of studies that indicated a substantial savings could be
obtained by encouraging Dividend Miles frequent flyer customers to redeem miles and schedule award flights online (US Airways Attache, February 2003 ). One study collected
data on the amount of time required to redeem miles and schedule an award flight over the telephone. A sample showing the time in minutes required for each of 150 award flights
scheduled by telephone is contained in the data set Flights. Use Excel to help answer the
following questions.
$$
\begin{array}{l}{\text { a. What is the sample mean number of minutes required to schedule an award flight by }} \\ {\text { telephone? }} \\ {\text { b. What is the } 95 \% \text { confidence interval for the population mean time to schedule an }} \\ {\text { award flight by telephone? }}\end{array}
$$
$$
\begin{array}{l}{\text { c. Assume a telephone ticket agent works } 7.5 \text { hours per day. How many award flights can }} \\ {\text { one ticket agent be expected to handle a day? }}\end{array}
$$
$$
\begin{array}{l}{\text { d. Discuss why this information supported US Airways' plans to use an online system to }} \\ {\text { reduce costs. }}\end{array}
$$

Added by Daryl H.

Question

Please give Ace some feedback