Question

Data from a randomized block design are shown in the following table. Treatment Levels 2 3 4 10 7 9 5 Block 1 8 Block 2 6 6 Block 3 7 The Error Sum of Squares (SSE) is_ ○ 4.67 012 ○ 2.33 ○ 28.67 O 11

Answer 1

By using excel we can solve this question easily.

First, enter all data into excel.

Click on Data -------> Data Analysis--------> Anova: Two-Factor Without Replication-----> Input Data -------> Select all data -------> Output Range : Select any empty cell --------> ok

We get

Anova: Two-Factor Without Replication
SUMMARY	Count	Sum	Average	Variance
Row 1	4	30	7.5	4.333333
Row 2	4	26	6.5	3
Row 3	4	32	8	0.666667
Column 1	3	21	7	1
Column 2	3	19	6.333333	2.333333
Column 3	3	27	9	1
Column 4	3	21	7	4
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Rows	4.666667	2	2.333333	1.166667	0.373248	5.143253
Columns	12	3	4	2	0.215553	4.757063
Error	12	6	2
Total	28.66667	11

4) SSE = 12 ( Using above table)

5) SST = 28.67 ( Using above table)

6) Critical F value for treatments = 5.14 ( Using above table)