Question

Conduct a TWO WAY ANOVA using the following data in Excel.

State Schools and Private Schools

Campus 1 : 47, 52, 37, 50, 25, 33, 31, 50

Campus 2: 77, 61, 55, 48, 52, 68, 60, 60

Answer 1

Result:

Conduct a TWO WAY ANOVA using the following data in Excel.

State Schools and Private Schools

Campus 1 : 47, 52, 37, 50, 25, 33, 31, 50

Campus 2: 77, 61, 55, 48, 52, 68, 60, 60

Excel Addin Data Analysis used.

Randomized Block Design (ANOVA: Two-Factor Without Replication)
SUMMARY	Count	Sum	Average	Variance
B1	2	124	62.0000	450.0000
B2	2	113	56.5000	40.5000
B3	2	92	46.0000	162.0000
B4	2	98	49.0000	2.0000
B5	2	77	38.5000	364.5000
B6	2	101	50.5000	612.5000
B7	2	91	45.5000	420.5000
B8	2	110	55.0000	50.0000
Campus1	8	325	40.6250	107.6964
Campus2	8	481	60.1250	83.8393
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Rows	759.7500	7	108.5357	1.3077	0.3662	3.7870
Columns	1521.0000	1	1521.0000	18.3253	0.0037	5.5914
Error	581.0000	7	83.0000
Total	2861.7500	15
				Level of significance	0.05

To test the significance of campus effect, calculated F=18.33 is > the critical F(1,7) value 5.59. Ho is rejected. There is significant campus effect.

To test the significance of block effect, calculated F=1.31 is < the critical F(7,7) value 3.79. Ho is not rejected. There is no significant block effect.