In: Math
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)
I WANT THE ANSWER IN EXCEL USING THE DATA ANALYSIS....DO NOT PROVIDE A HAND WRITTEN ANSWER...I'm trying to understand the functions in excel
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 |