Can you answer the following in Excel?

A problem with a phone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. The file Phone contains samples of 20 problems reported to two different offices of telecommunications company and the time to clear these problems (in minutes) form the customers' lines:

Central Office I Time to Clear Problems (minutes)

1.481.750.782.850.521.604.153.971.483.10

1.020.530.931.600.801.056.323.935.450.97

Central Office II Time to Clear Problems (minutes)

7.553.750.101.100.600.523.302.100.584.02

3.750.651.920.601.534.230.081.48.1650.72

a. Assuming that the population variances from both offices are equal, is there evidence of difference in the mean waiting time between the two offices? (Use alpha = 0.05)

b. Find the p-value in (a) and interpret its meaning.

c. What other assumptions is necessary in (a)?

d. Assuming that the population variances form both offices are equal, construct and interpret a 95% confidence interval estimate of the difference between the population means in the two offices.