small telemarketing form is trying to the force, the firm assigns all shows the
ID: 2926207 • Letter: S
Question
small telemarketing form is trying to the force, the firm assigns all shows the number of units sold by the representatives in each f analyse the effectiveness of its soles force. The fiems sales force consists of 4 representatives and S districts. To test the effectiveness of the sales S districts to each representative in random order. The table below district. Rep1 Rep2 Rep 3 Rep 4 Dist 1 Dist 2 Dist 3 Dist 4 Dist 5 12 14 25 23 32 10 16 17 17 20 12 21 10 21 17 37 To test whether there is a difference between the mean sales of representatives, the firm uses the randomized block ANOVA procedure. The output is shown in the next page. (2 pts) Test statistic value for testing the difference in mean sales between representatives is (2 pts) Critical value for testing the difference i b) mean sales between representatives is c) (2 pts) Test statistic for testing the difference in the mean sales between districts d) (2 pts) Critical value for testing the difference in the mean sales between dist ricts isExplanation / Answer
Enter the data in Excel.
Go to Data tab -> Click on Data Analysis tool pack -> Choose two-way anova without replication -> Click ok.
Select the data in the input range -> Tick labels -> Click ok.
Output is as follows :
Anova: Two-Factor Without Replication
SUMMARY
Count
Sum
Average
Variance
Dist1
4
26
6.5
28.3333
Dist2
4
59
14.75
4.91667
Dist3
4
85
21.25
10.9167
Dist4
4
70
17.5
31
Dist5
4
112
28
60.6667
Rep1
5
77
15.4
69.3
Rep2
5
67
13.4
59.3
Rep3
5
102
20.4
104.3
Rep4
5
106
21.2
67.7
ANOVA
Source of Variation
SS
df
MS
F
P-value
F crit
Rows
1011.3
4
252.825
15.876
9.74E-05
3.25917
Columns
216.4
3
72.1333
4.52957
0.02409
3.49029
Error
191.1
12
15.925
Total
1418.8
19
a)Test statistic is the F-statistic for the columns = 4.52957
b)Critical value is the F critical for the columns = 3.49029
c) Test statistic is the F-statistic for the rows = 15.876
d)Critical value is the F critical for the rows = 3.25917
Anova: Two-Factor Without Replication
SUMMARY
Count
Sum
Average
Variance
Dist1
4
26
6.5
28.3333
Dist2
4
59
14.75
4.91667
Dist3
4
85
21.25
10.9167
Dist4
4
70
17.5
31
Dist5
4
112
28
60.6667
Rep1
5
77
15.4
69.3
Rep2
5
67
13.4
59.3
Rep3
5
102
20.4
104.3
Rep4
5
106
21.2
67.7
ANOVA
Source of Variation
SS
df
MS
F
P-value
F crit
Rows
1011.3
4
252.825
15.876
9.74E-05
3.25917
Columns
216.4
3
72.1333
4.52957
0.02409
3.49029
Error
191.1
12
15.925
Total
1418.8
19
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.