Question

. A problem with a cell phone that prevents a customer from receiving calls is upsetting both customers and the telecommunications company. The file Phone contains samples of 20 problems reported to two different offices of the telecommunication company and the time to clear these problems (in minutes) from the customers’ phones. Is there evidence that addressing this phone issue results in different mean waiting times at the two offices? (Use a 0.05 level of significance)

Please show me how to do this step by step in excel using the data analysis tab.

Time	Location
1.48	1
1.75	1
0.78	1
2.85	1
0.52	1
1.60	1
4.15	1
3.97	1
1.48	1
3.10	1
1.02	1
0.53	1
0.93	1
1.60	1
0.80	1
1.05	1
6.32	1
3.93	1
5.45	1
0.97	1
7.55	2
3.75	2
0.10	2
1.10	2
0.60	2
0.52	2
3.30	2
2.10	2
0.58	2
4.02	2
3.75	2
0.65	2
1.92	2
0.60	2
1.53	2
4.23	2
0.08	2
1.48	2
1.65	2
0.72	2

Answer 1