Question

In: Math

A problem with a cell phone that prevents a customer from receiving calls is upsetting both...

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

Solutions

Expert Solution



Related Solutions

A Problem with a phone line that prevents a customer from receiving or making calls is...
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. Samples of 20 problems reported to two different offices of a telecommunications company and the time to clear those problems (in minutes) from the customers’ lines. Data summary table: Problem 1 data Mean 1 2.21 Mean 2 2.01 Std. Dev. 1 1.72 Std. Dev. 2 1.89 Using the output below answer the answer the flowing...
A problem with a phone line that prevents a customer from receiving or making calls is...
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 a telecommunications company and the time to clear these problems (in minutes) from the customers’ lines: Central Office I Time to Clear Problems (minutes) 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80 1.05 6.32...
A problem with a phone line that prevents a customer from receiving or making calls is...
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 a telecommunications company and the time to clear these problems (in minutes) from the customers' lines: Central Office I Time to Clear Problems (minutes) 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80 1.05 6.32...
A problem with a phone line that prevents a customer from receiving or making calls is...
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. Table 4 contains samples of 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers’ lines:   Central Office I Time to Clear Problems (minutes): 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80 1.05 6.32 3.93...
A problem with a phone line that prevents a customer from receiving or making calls is...
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 following data sets contain samples I have 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers lines: Central Office 1 time to clear problems (minutes): 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80...
A problem with a phone line that prevents a customer from receiving or making calls is...
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 following data sets contain samples I have 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers lines: Central Office 1 time to clear problems (minutes): 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80...
problem with a phone line that prevents a customer from receiving or making calls is upsetting...
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 a telecommunications company and the time to clear these problems (in minutes) from the customers’ lines: Central Office I Time to Clear Problems (minutes) 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80 1.05 6.32 3.93...
A problem with a telephone line that prevents a customer from receiving or making calls is...
A problem with a telephone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telephone company. Samples of 20 problems reported to two different offices of a telephone company and the time to clear these problems​ (in minutes) from the​ customers' lines are provided. Complete​(a) through​ (d) below. a. Assuming that the population variances from both offices are​ equal, is there evidence of a difference in the mean waiting times between...
A problem with a telephone line that prevents a customer from receiving or making calls is...
A problem with a telephone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. The accompanying table contains samples of 20 problems reported to two different offices of a telecommunications company and the time to clear these problems​ (in minutes) from the​ customers' lines. At the 0.05 level of​ significance, is there evidence of a difference in the variability of the time to clear problems between the two central​...
A problem with a telephone line that prevents a customer from receiving or making calls is...
A problem with a telephone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telephone company. Samples of 20 problems reported to two different offices of a telephone company and the time to clear these problems​ (in minutes) from the​ customers' lines are provided in the Excel sheet labeled 'Phone Lines'. Use alpha as 0.05 What test will you use? What is the critical value? Reject Ho? Is there evidence of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT