Question

1. Group A has three scores, 12, 39, 42. Group B has three scores, 49, 46, 14. Group C has three scores, 49, 39, 32. Calculate the grand mean (round to two digits).  

QUESTION 2

1. Group A has three scores, 36, 50, 47. Group B has three scores, 17, 40, 18. Group C has three scores, 40, 29, 18. Calculate MS error (Mean squared error for the error term). Round to one digit.

QUESTION 3

1. Group A has three scores, 17, 31, 39. Group B has three scores, 23, 36, 29. Group C has three scores, 48, 16, 13. Calculate SS total (the total sums of squares). Round to two digits.

Answer 1

QUESTION 1 :

QUESTION 2

for the given data using Anova single factor in Excel we get output as

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Group A	3	133	44.33333	54.33333
Group B	3	75	25	169
Group C	3	87	29	121
ANOVA
Source of Variation	SS	df	MS	F	P-value
Between Groups	624.8889	2	312.4444	2.722168	0.144106
Within Groups	688.6667	6	114.7778
Total	1313.556	8

So from the above output

MS error = 114.7778

                  = 114 .8

Answer :MS error = 114 .8

QUESTION 3

for the given data using Anova single factor in Excel we get output as

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Group A	3	87	29	124
Group B	3	88	29.33333	42.33333
Group C	3	77	25.66667	376.3333
ANOVA
Source of Variation	SS	df	MS	F	P-value
Between Groups	24.66667	2	12.33333	0.068182	0.934804
Within Groups	1085.333	6	180.8889
Total	1110	8

SS total = 1110

Answer : SS total = 1110