A problem with a cell phone that prevents a customer fromreceiving calls is upsetting both customers and thetelecommunications company. The file Phone contains samples of 20problems reported to two different offices of the telecommunicationcompany and the time to clear these problems (in minutes) from thecustomers’ phones. Is there evidence that addressing this phoneissue 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 DATAANALYSIS....DO NOT PROVIDE A HAND WRITTENANSWER...I'm trying to understand the functions inexcel
| 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 |
