A problem with a telephone line that prevents a customer from receiving or makin
ID: 3208194 • Letter: A
Question
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. Complete parts (a) through (d) below.
Compute the FSTAT test statistic.
Determine the critical value
Find the P-value
Time Location 1.32 1 1.93 1 0.74 1 2.71 1 0.58 1 1.81 1 4.06 1 3.75 1 1.71 1 2.75 1 1.21 1 0.62 1 1.08 1 1.44 1 0.73 1 0.87 1 6.43 1 3.18 1 6.44 1 0.78 1 7.53 2 3.42 2 0.12 2 0.98 2 0.53 2 0.51 2 3.65 2 1.75 2 0.63 2 4.63 2 4.31 2 0.67 2 1.99 2 0.67 2 1.29 2 4.39 2 0.09 2 1.26 2 1.63 2 0.85 2Explanation / Answer
First we filter the data and make two columns for two locations.
Location 1
Location 2
1.32
7.53
1.93
3.42
0.74
0.12
2.71
0.98
0.58
0.53
1.81
0.51
4.06
3.65
3.75
1.75
1.71
0.63
2.75
4.63
1.21
4.31
0.62
0.67
1.08
1.99
1.44
0.67
0.73
1.29
0.87
4.39
6.43
0.09
3.18
1.26
6.44
1.63
0.78
0.85
Now we go to excel Data option. There we select Data Analysis. We select Single Factor Anova. We take the data range and we get the output as below:
Anova: Single Factor
SUMMARY
Groups
Count
Sum
Average
Variance
Column 1
20
44.14
2.207
3.184464
Column 2
20
40.9
2.045
3.886142
ANOVA
Source of Variation
SS
df
MS
F
P-value
F crit
Between Groups
0.26244
1
0.26244
0.074
0.7867
4.098
Within Groups
134.3415
38
3.535303
Total
134.604
39
Answers:
F = 0.074
Critical value = 4.098
p-value = 0.7867
Location 1
Location 2
1.32
7.53
1.93
3.42
0.74
0.12
2.71
0.98
0.58
0.53
1.81
0.51
4.06
3.65
3.75
1.75
1.71
0.63
2.75
4.63
1.21
4.31
0.62
0.67
1.08
1.99
1.44
0.67
0.73
1.29
0.87
4.39
6.43
0.09
3.18
1.26
6.44
1.63
0.78
0.85
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.