ANOVA_FACTOR2.xlsx

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q
1	Score	Sex	Age Group	Squared Within Deviation	Squared Total Deviation		Home
2	4	1	10	4	25
3	6	1	10	0	9
4	8	1	10	4	1			Factor (Age): Mean					Degree of Freedom
5	6	1	11	1	9		Category	10	11	12	Marginal Mean	Sex	1	Number of Catogories - 1
6	6	1	11	1	9	Factor (Sex): Mean	Boy	6	7	10	7.67	Age Group	2	(2-1)
7	9	1	11	4	0	Factor (Sex): Mean	Girl	7	10	14	10.3	Sex * Age Group	2
8	8	1	12	4	1		Marginal Mean	6.5	8.5	12.0	9.0	Error	12
9	9	1	12	1	0							Total	17
10	13	1	12	9	16
11	4	0	10	9	25
12	8	0	10	1	1	Squared Between Deviation
13	9	0	10	4	0	Sex	Boy	Girl	Total
14	7	0	11	9	4	Squared Deviation	16	16	32			Source of Variation	Squared Variation	Mean Squared	F value	p Value
15	10	0	11	0	1	Age	10	11	12	Total		Sex	32	32.0	5.647	0.03499
16	13	0	11	9	16	Squared Deviation	37.50	1.50	54.00	93.00		Age Group	93	46.5	8.206	0.00568
17	12	0	12	4	9							Sex * Age Group	7	3.5	0.618	0.55550
18	14	0	12	0	25							Error (Within Deviation)	68	5.7
19	16	0	12	4	49							Total	200	11.8
20				68	200
21
22
23
24
25
26
27
28
29
30
31		ANOVA
32		Source of Variation	SS	df	MS	F	P-value	F crit
33		Age Group	93	2	46.5	8.205882353	0.005676729758	3.885293835
34		Sex	32	1	32	5.647058824	0.03499435062	4.747225347
35		Sex * Age	7	2	3.5	0.6176470588	0.5555023441	3.885293835
36		Within	68	12	5.666666667
37
38		Total	200	17
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100