ANOVA and ChiSq Survey Assignment

profileHelpplease127
surveydata1.xlsx
Home>Mathematics homework help>Statistics homework help>ANOVA and ChiSq Survey Assignment

Income

Count of Income1 Column Labels
Row Labels A B C D Grand Total
A 2 2 1 1 6
B 2 5 1 8
C 6 2 2 8 18
D 8 12 9 12 41
E 14 10 4 7 35
F 4 8 6 8 26
G 5 5 5 6 21
H 7 3 6 10 26
I 5 6 4 4 19
Grand Total 51 50 42 57 200
Count of Income1 Actual or Observed Table
Row Labels A B C D Grand Total Ho: Income and groups are independent
A 2 2 1 1 6 Ha: Income and groups are dependent
B 2 5 1 8
C 6 2 2 8 18 ChiSq Test 0.47558
D 8 12 9 12 41
E 14 10 4 7 35 We don't have any statistical evidence to reject the Null.
F 4 8 6 8 26
G 5 5 5 6 21 Condition for ChiSq Test is:
H 7 3 6 10 26
I 5 6 4 4 19 The value in the expected table must be 5 or more to be eligible for the test!!!
Grand Total 51 50 42 57 200
Count of Income1 Expected Table
Row Labels A B C D Grand Total
A 1.53 1.5 1.26 1.71 6 ChiSq Test: 0.85753
B 2.04 2 1.68 2.28 8
C 4.59 4.5 3.78 5.13 18
D 10.455 10.25 8.61 11.685 41
E 8.925 8.75 7.35 9.975 35
F 6.63 6.5 5.46 7.41 26
G 5.355 5.25 4.41 5.985 21
H 6.63 6.5 5.46 7.41 26
I 4.845 4.75 3.99 5.415 19
Grand Total 51 50 42 57 200
Count of Income1 Actual or Observed Table
Row Labels A B C D Grand Total
Low Income Group 8 6 8 10 32
Moderate Income Group 26 30 19 27 102
Upper Income Level 17 14 15 20 66
Grand Total 51 50 42 57 200
Count of Income1 Expected Table
Row Labels A B C D Grand Total
Low Income Group 8.16 8 6.72 9.12 32
Moderate Income Group 26.01 25.5 21.42 29.07 102
Upper Income Level 16.83 16.5 13.86 18.81 66
Grand Total 51 50 42 57 200

Detergent

AQ6 Detergent1 Detergent2 Detergent3 Detergent4
A 6.97 6.78 9.66 6.75 ANOVA Test:
A 7.48 7.78 4.28 6.02
A 8.62 8.79 4.61 5.37 Ho: All means for the four groups in terms of Detergent Price are the same;
A 9.07 6.05 5.2 4.55 Ha: Not all means for the four groups in terms of Detergent Price are the same;
A 6 7.23 4.96 4.71
A 8.9 7.02 9.99 5.1
A 8.78 5.85 9.56 4.68 Anova: Single Factor
A 6.98 7.22 9.66 4.12
A 7.55 7.72 4 4.68 SUMMARY
A 8.38 9.57 9.91 4.12 Groups Count Sum Average Variance
A 8.03 7.73 4.03 7.69 Detergent1 51 413.03 8.098627451 0.9104000784
A 7.87 5.85 4.1 5.38 Detergent2 50 349.63 6.9926 1.2690114694
A 9.38 5.6 9.13 4.98 Detergent3 42 282.96 6.7371428571 5.3048160279
A 6.84 8.57 7.97 5.56 Detergent4 57 304.38 5.34 1.3977214286
A 7.54 8.11 9.01 4.07
A 8.22 8.22 9.97 6.29
A 8.56 6.81 6.21 4.73 ANOVA
A 6.73 8.34 6.16 6.81 Source of Variation SS df MS F P-value F crit
A 8.8 7.33 8.94 4.08 Between Groups 209.0299769356 3 69.6766589785 33.8478127052 1.1314E-17 2.6506765101
A 9.42 7.2 8.91 5.26 Within Groups 403.4714230644 196 2.0585276687
A 6.64 4.27 9.15 4.23
A 7.33 6.22 9.86 5.04 Total 612.5014 199
A 8.32 8.02 4.23 5.75
A 9.07 7.11 4.27 7.9 We do not have statistical evidence to reject the NULL hypothesis.
A 8.41 8.16 5.67 4.03 That means the four groups have no significant difference in the detergent price.
A 9.22 7.07 6.15 6.87
A 7.65 6.07 5.08 5.74
A 9.22 5.7 5.79 6.36
A 8.9 6.43 9.1 5.57
A 7.74 6.03 9.87 6.31
A 8.81 6.56 4.02 4.02
A 7.64 6.1 4.22 4.19
A 8.11 8.19 4.01 4.74
A 8.6 9.33 5.33 4.39
A 6.26 7.43 7.57 7.77
A 7.2 7.05 4.02 4.16
A 7.96 6.48 6.4 6.02
A 9.35 5.55 6.65 4.14
A 5.7 6.68 9.78 7.92
A 8.18 5.72 6.87 5.96
A 7.23 6.99 4 4.58
A 7.84 5.76 4.66 8.1
A 7.66 6.17 4.03
A 7.67 7.12 5.46
A 8.54 6.93 7.32
A 9.55 8.39 4.42
A 9.44 6.78 4.08
A 8.34 4.76 4.15
A 8.14 6.42 4.22
A 8.63 8.37 4.46
A 9.56 6.84
B 5.4
B 5.39
B 5.19
B 5.22
B 4.05
B 5.41
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

Juice

AQ6 Juice 1 Juice 2 Juice 3 Juice 4
A 1.02 3.89 3.99 2.63
A 1.27 4.5 3.6 1.52 ANOVA Test:
A 3.13 3.46 1.85 3.44
A 2.07 4.48 3.76 4.24 Ho: All means for the four groups in terms of Juice Price are the same;
A 3.92 3.22 3.2 1.01 Ha: Not all means for the four groups in terms of Juice Price are the same;
A 1.08 4.03 2.7 2.53
A 1.16 3.34 3.28 1.43 Anova: Single Factor
A 1.86 4.58 3.04 1.47
A 2.09 2.92 1.41 2.18 SUMMARY
A 2.47 4.29 1.99 4.92 Groups Count Sum Average Variance
A 2.19 4.34 1.86 3.13 Juice 1 51 98.99 1.9409803922 0.7497650196
A 1.03 3.54 3.19 1.02 Juice 2 50 197.97 3.9594 0.367218
A 1.08 4.8 2.06 2 Juice 3 42 114.57 2.7278571429 1.0061684669
A 1.07 2.95 2.05 1.5 Juice 4 57 167.49 2.9384210526 1.9937992481
A 2.1 4.09 3.99 4.21
A 4.13 4.67 3.42 5
A 2.52 4.32 3.52 1.32 ANOVA
A 3.17 3.77 3.27 2.56 Source of Variation SS df MS F P-value F crit
A 1.77 3.46 4 3.7 Between Groups 104.345999982 3 34.781999994 32.7143844627 3.45167113396959E-17 2.6506765101
A 3.88 4.92 2.34 3.54 Within Groups 208.387598018 196 1.0632020307
A 1.24 4.27 1.5 4.63
A 1.07 3.96 1.34 1.27 Total 312.733598 199
A 2.51 3.71 2.17 1.2
A 1.17 3.14 1.52 2.4
A 1.28 4.9 1.62 2.03
A 3.11 4.9 4.46 1.51 We do not have statistical evidence to reject the NULL hypothesis.
A 1.08 3.84 2.68 1.3 That means the four groups have no significant difference in the juice price.
A 1.39 4.8 3.26 2.05
A 1.86 4.23 3.94 4.61
A 2.49 2.54 1.15 4.49
A 1.12 3.89 1.7 2.59
A 3.22 4.59 4.11 2.15
A 1.99 4.19 1.02 2.82
A 1.65 3.6 3.04 3.85
A 2.07 4.41 1.99 4.93
A 1.35 3.86 2.54 4.41
A 1.32 4.04 1.38 2.67
A 3.5 3.17 3.45 3.97
A 1.97 3.32 4.41 4.82
A 2.86 3.8 4.02 5
A 2.77 4.16 2.06 1.53
A 1.92 2.94 2.69 1.02
A 2.04 3.13 1.18
A 2.19 4 2.78
A 1.01 4.34 4.98
A 1.37 3.37 3.71
A 1.86 4.5 1.37
A 1.1 4.02 3.23
A 1 3.86 1.67
A 1.38 4.92 4.99
A 1.09 3.92
B 4.99
B 1.1
B 3.56
B 4.96
B 5
B 1.45
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

Cleaner

AQ6 Cleaner 1 Cleaner 2 Cleaner 3 Cleaner 4
A 6.9 2.25 6.11 4.1
A 3.57 1.14 4.44 6.9 ANOVA Test:
A 1.22 2.58 6.28 3.34
A 5.4 1.3 6.29 3.99 Ho: All means for the four groups in terms of Juice Cleaner are the same;
A 2.2 3.01 5.39 1.22 Ha: Not all means for the four groups in terms of Cleaner Price are the same;
A 1.11 1.9 5.42 3.55
A 6.98 1.31 3.96 4.69 Anova: Single Factor
A 1.8 3.76 6.9 5.85
A 5.71 1.94 4.57 3.84 SUMMARY
A 6.92 4.59 6.85 6.22 Groups Count Sum Average Variance
A 6.88 3.87 3.55 4.25 Cleaner 1 51 199.64 3.9145098039 3.9691252549
A 5.16 2.22 6.41 2.28 Cleaner 2 50 126.82 2.5364 1.4134520816
A 5.94 2.53 5.98 2.8 Cleaner 3 42 230.82 5.4957142857 0.8601616725
A 4.94 3.75 3.48 4.12 Cleaner 4 57 232.64 4.0814035088 1.6132337093
A 3.33 2.23 6.58 2.87
A 5.15 3.24 6.42 2.73
A 4.17 5.65 4.59 5.12 ANOVA
A 6.99 5.17 6.03 2.15 Source of Variation SS df MS F P-value F crit
A 2.35 1.69 5.57 4.95 Between Groups 201.3094369642 3 67.1031456547 33.4387060168 1.68979584587624E-17 2.6506765101
A 1.09 1.38 5.05 5.64 Within Groups 393.3231310358 196 2.0067506686
A 2.9 1.54 3.49 4.39
A 1.33 3.46 5.64 3.78 Total 594.632568 199
A 1.77 3.21 5.98 4.49
A 5.11 1.93 6.3 5.06
A 3.62 1.22 5.06 3.59 We do not have statistical evidence to reject the NULL hypothesis.
A 2.2 1.71 3.86 6.29 That means the four groups have no significant difference in the cleaner price.
A 5.74 3.83 6.15 5.64
A 2.69 3.48 5.29 3.76
A 6.4 2.9 6.59 4.88
A 1.96 4.1 5.07 2.53
A 6.99 1.28 5.61 3.47
A 2.32 1.32 6.12 5.52
A 6.42 1.05 5.37 2.41
A 3.39 1.28 5.02 4.15
A 1.31 3.09 5.88 2.59
A 3.85 3.29 6.13 4.71
A 1.06 2.47 5.07 2.99
A 2.25 1.38 4.86 3.58
A 4.02 1.11 6.25 5.84
A 4.55 5.11 5.34 4.99
A 1.02 2.46 6.58 2.05
A 4.22 2.8 5.29 4.27
A 3.89 3.26 4.2
A 1.64 1.84 4.6
A 1.34 1.36 2.43
A 6.32 1.22 5.7
A 4.04 1.26 2.71
A 3.12 2.8 2.32
A 6.98 3.45 5.33
A 4.95 2.1 4.68
A 4.43 5.73
B 3.45
B 4.49
B 4.56
B 4.89
B 2.47
B 3.49
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

Q1-1-

Sum of Household Column Labels
Row Labels A B C D Grand Total
1 18 18 1 3 40
2 80 40 4 6 130
3 60 51 3 15 129
4 44 24 12 80
5 50 45 95
6 18 12 30
7 21 28 7 56
Grand Total 291 218 15 36 560 Ho: Household and groups are independent
Ha: Household and groups are dependent
Sum of Household Actual or Observed Labels
Row Labels A B C D Grand Total
1 18 18 1 3 40 ChiSq Test: 0.0000880399
2 80 40 4 6 130
3 60 51 3 15 129 We don't have any statistical evidence to reject the Null.
4 44 24 12 80 The value in the expected table must be 5 or more to be eligible for the test!!!
5 50 45 95
6 18 12 30
7 21 28 7 56 ChiSq Test: 0.0366075905
Grand Total 291 218 15 36 560
Sum of Household Expected Labels
Row Labels A B C D Grand Total
1 20.7857142857 15.5714285714 1.0714285714 2.5714285714 40
2 67.5535714286 50.6071428571 3.4821428571 8.3571428571 130
3 67.0339285714 50.2178571429 3.4553571429 8.2928571429 129
4 41.5714285714 31.1428571429 2.1428571429 5.1428571429 80
5 49.3660714286 36.9821428571 2.5446428571 6.1071428571 95
6 15.5892857143 11.6785714286 0.8035714286 1.9285714286 30
7 29.1 21.8 1.5 3.6 56
Grand Total 291 218 15 36 560
Sum of Household Actual or Observed Labels
Row Labels A B C D Grand Total
1 158 109 8 24 299
4 94 69 12 175
6 39 40 7 86
Grand Total 291 218 15 36 560
Sum of Household Expected Labels
Row Labels A B C D Grand Total
1 155.3732142857 116.3964285714 8.0089285714 19.2214285714 299
4 90.9375 68.125 4.6875 11.25 175
6 44.6892857143 33.4785714286 2.3035714286 5.5285714286 86
Grand Total 291 218 15 36 560

Q1-2

Count of Number Column Labels
Row Labels A B C D E Grand Total
1 1 1
2 1 1
3 1 1
4 1 1
5 1 1
6 1 1
7 1 1
8 1 1
9 1 1
10 1 1
11 1 1
12 1 1
13 1 1
14 1 1
15 1 1
16 1 1
17 1 1
18 1 1
19 1 1
20 1 1
21 1 1
22 1 1
23 1 1
24 1 1
25 1 1
26 1 1
27 1 1
28 1 1
29 1 1
30 1 1
31 1 1
32 1 1
33 1 1
34 1 1
35 1 1
36 1 1
37 1 1
38 1 1
39 1 1
40 1 1
41 1 1
42 1 1
43 1 1
44 1 1
45 1 1
46 1 1
47 1 1
48 1 1
49 1 1
50 1 1
51 1 1
52 1 1
53 1 1
54 1 1
55 1 1
56 1 1
57 1 1
58 1 1
59 1 1
60 1 1
61 1 1
62 1 1
63 1 1
64 1 1
65 1 1
66 1 1
67 1 1
68 1 1
69 1 1
70 1 1
71 1 1
72 1 1
73 1 1
74 1 1
75 1 1
76 1 1
77 1 1
78 1 1
79 1 1
80 1 1
81 1 1
82 1 1
83 1 1
84 1 1
85 1 1
86 1 1
87 1 1
88 1 1
89 1 1
90 1 1
91 1 1
92 1 1
93 1 1
94 1 1
95 1 1
96 1 1
97 1 1
98 1 1
99 1 1
100 1 1
101 1 1
102 1 1
103 1 1
104 1 1
105 1 1
106 1 1
107 1 1
108 1 1
109 1 1
110 1 1
111 1 1
112 1 1
113 1 1
114 1 1
115 1 1
116 1 1
117 1 1
118 1 1
119 1 1
120 1 1
121 1 1
122 1 1
123 1 1
124 1 1
125 1 1
126 1 1
127 1 1
128 1 1
129 1 1
130 1 1
131 1 1
132 1 1
133 1 1
134 1 1
135 1 1
136 1 1
137 1 1
138 1 1
139 1 1
140 1 1
141 1 1
142 1 1
143 1 1
144 1 1
145 1 1
146 1 1
147 1 1
148 1 1
149 1 1
150 1 1
151 1 1
152 1 1
153 1 1
154 1 1
155 1 1
156 1 1
157 1 1
158 1 1
159 1 1
160 1 1
161 1 1
162 1 1
163 1 1
164 1 1
165 1 1
166 1 1
167 1 1
168 1 1
169 1 1
170 1 1
171 1 1
172 1 1
173 1 1
174 1 1
175 1 1
176 1 1
177 1 1
178 1 1
179 1 1
180 1 1
181 1 1
182 1 1
183 1 1
184 1 1
185 1 1
186 1 1
187 1 1
188 1 1
189 1 1
190 1 1
191 1 1
192 1 1
193 1 1
194 1 1
195 1 1
196 1 1
197 1 1
198 1 1
199 1 1
200 1 1
Grand Total 28 37 101 20 14 200
Count of Number Actual or Observed Labels
Row Labels A B C D E Grand Total ChiSq Test -0.9997426635
1 1 1
2 1 1
3 1 1
4 1 1 Ho: Count of number and groups are independent
5 1 1 Ha: Count of number and groups are dependent
6 1 1
7 1 1
8 1 1
9 1 1 The value in the expected table must be 5 or more to be eligible for the test!!!
10 1 1
11 1 1 ChiSq Test: 1
12 1 1
13 1 1
14 1 1
15 1 1
16 1 1
17 1 1
18 1 1
19 1 1
20 1 1
21 1 1
22 1 1
23 1 1
24 1 1
25 1 1
26 1 1
27 1 1
28 1 1
29 1 1
30 1 1
31 1 1
32 1 1
33 1 1
34 1 1
35 1 1
36 1 1
37 1 1
38 1 1
39 1 1
40 1 1
41 1 1
42 1 1
43 1 1
44 1 1
45 1 1
46 1 1
47 1 1
48 1 1
49 1 1
50 1 1
51 1 1
52 1 1
53 1 1
54 1 1
55 1 1
56 1 1
57 1 1
58 1 1
59 1 1
60 1 1
61 1 1
62 1 1
63 1 1
64 1 1
65 1 1
66 1 1
67 1 1
68 1 1
69 1 1
70 1 1
71 1 1
72 1 1
73 1 1
74 1 1
75 1 1
76 1 1
77 1 1
78 1 1
79 1 1
80 1 1
81 1 1
82 1 1
83 1 1
84 1 1
85 1 1
86 1 1
87 1 1
88 1 1
89 1 1
90 1 1
91 1 1
92 1 1
93 1 1
94 1 1
95 1 1
96 1 1
97 1 1
98 1 1
99 1 1
100 1 1
101 1 1
102 1 1
103 1 1
104 1 1
105 1 1
106 1 1
107 1 1
108 1 1
109 1 1
110 1 1
111 1 1
112 1 1
113 1 1
114 1 1
115 1 1
116 1 1
117 1 1
118 1 1
119 1 1
120 1 1
121 1 1
122 1 1
123 1 1
124 1 1
125 1 1
126 1 1
127 1 1
128 1 1
129 1 1
130 1 1
131 1 1
132 1 1
133 1 1
134 1 1
135 1 1
136 1 1
137 1 1
138 1 1
139 1 1
140 1 1
141 1 1
142 1 1
143 1 1
144 1 1
145 1 1
146 1 1
147 1 1
148 1 1
149 1 1
150 1 1
151 1 1
152 1 1
153 1 1
154 1 1
155 1 1
156 1 1
157 1 1
158 1 1
159 1 1
160 1 1
161 1 1
162 1 1
163 1 1
164 1 1
165 1 1
166 1 1
167 1 1
168 1 1
169 1 1
170 1 1
171 1 1
172 1 1
173 1 1
174 1 1
175 1 1
176 1 1
177 1 1
178 1 1
179 1 1
180 1 1
181 1 1
182 1 1
183 1 1
184 1 1
185 1 1
186 1 1
187 1 1
188 1 1
189 1 1
190 1 1
191 1 1
192 1 1
193 1 1
194 1 1
195 1 1
196 1 1
197 1 1
198 1 1
199 1 1
200 1 1
Grand Total 28 37 101 20 14 200
Count of Number Expected Labels
Row Labels A B C D E Grand Total
1 0.14 0.185 0.505 0.1 0.07 1
2 0.14 0.185 0.505 0.1 0.07 1
3 0.14 0.185 0.505 0.1 0.07 1
4 0.14 0.185 0.505 0.1 0.07 1
5 0.14 0.185 0.505 0.1 0.07 1
6 0.14 0.185 0.505 0.1 0.07 1
7 0.14 0.185 0.505 0.1 0.07 1
8 0.14 0.185 0.505 0.1 0.07 1
9 0.14 0.185 0.505 0.1 0.07 1
10 0.14 0.185 0.505 0.1 0.07 1
11 0.14 0.185 0.505 0.1 0.07 1
12 0.14 0.185 0.505 0.1 0.07 1
13 0.14 0.185 0.505 0.1 0.07 1
14 0.14 0.185 0.505 0.1 0.07 1
15 0.14 0.185 0.505 0.1 0.07 1
16 0.14 0.185 0.505 0.1 0.07 1
17 0.14 0.185 0.505 0.1 0.07 1
18 0.14 0.185 0.505 0.1 0.07 1
19 0.14 0.185 0.505 0.1 0.07 1
20 0.14 0.185 0.505 0.1 0.07 1
21 0.14 0.185 0.505 0.1 0.07 1
22 0.14 0.185 0.505 0.1 0.07 1
23 0.14 0.185 0.505 0.1 0.07 1
24 0.14 0.185 0.505 0.1 0.07 1
25 0.14 0.185 0.505 0.1 0.07 1
26 0.14 0.185 0.505 0.1 0.07 1
27 0.14 0.185 0.505 0.1 0.07 1
28 0.14 0.185 0.505 0.1 0.07 1
29 0.14 0.185 0.505 0.1 0.07 1
30 0.14 0.185 0.505 0.1 0.07 1
31 0.14 0.185 0.505 0.1 0.07 1
32 0.14 0.185 0.505 0.1 0.07 1
33 0.14 0.185 0.505 0.1 0.07 1
34 0.14 0.185 0.505 0.1 0.07 1
35 0.14 0.185 0.505 0.1 0.07 1
36 0.14 0.185 0.505 0.1 0.07 1
37 0.14 0.185 0.505 0.1 0.07 1
38 0.14 0.185 0.505 0.1 0.07 1
39 0.14 0.185 0.505 0.1 0.07 1
40 0.14 0.185 0.505 0.1 0.07 1
41 0.14 0.185 0.505 0.1 0.07 1
42 0.14 0.185 0.505 0.1 0.07 1
43 0.14 0.185 0.505 0.1 0.07 1
44 0.14 0.185 0.505 0.1 0.07 1
45 0.14 0.185 0.505 0.1 0.07 1
46 0.14 0.185 0.505 0.1 0.07 1
47 0.14 0.185 0.505 0.1 0.07 1
48 0.14 0.185 0.505 0.1 0.07 1
49 0.14 0.185 0.505 0.1 0.07 1
50 0.14 0.185 0.505 0.1 0.07 1
51 0.14 0.185 0.505 0.1 0.07 1
52 0.14 0.185 0.505 0.1 0.07 1
53 0.14 0.185 0.505 0.1 0.07 1
54 0.14 0.185 0.505 0.1 0.07 1
55 0.14 0.185 0.505 0.1 0.07 1
56 0.14 0.185 0.505 0.1 0.07 1
57 0.14 0.185 0.505 0.1 0.07 1
58 0.14 0.185 0.505 0.1 0.07 1
59 0.14 0.185 0.505 0.1 0.07 1
60 0.14 0.185 0.505 0.1 0.07 1
61 0.14 0.185 0.505 0.1 0.07 1
62 0.14 0.185 0.505 0.1 0.07 1
63 0.14 0.185 0.505 0.1 0.07 1
64 0.14 0.185 0.505 0.1 0.07 1
65 0.14 0.185 0.505 0.1 0.07 1
66 0.14 0.185 0.505 0.1 0.07 1
67 0.14 0.185 0.505 0.1 0.07 1
68 0.14 0.185 0.505 0.1 0.07 1
69 0.14 0.185 0.505 0.1 0.07 1
70 0.14 0.185 0.505 0.1 0.07 1
71 0.14 0.185 0.505 0.1 0.07 1
72 0.14 0.185 0.505 0.1 0.07 1
73 0.14 0.185 0.505 0.1 0.07 1
74 0.14 0.185 0.505 0.1 0.07 1
75 0.14 0.185 0.505 0.1 0.07 1
76 0.14 0.185 0.505 0.1 0.07 1
77 0.14 0.185 0.505 0.1 0.07 1
78 0.14 0.185 0.505 0.1 0.07 1
79 0.14 0.185 0.505 0.1 0.07 1
80 0.14 0.185 0.505 0.1 0.07 1
81 0.14 0.185 0.505 0.1 0.07 1
82 0.14 0.185 0.505 0.1 0.07 1
83 0.14 0.185 0.505 0.1 0.07 1
84 0.14 0.185 0.505 0.1 0.07 1
85 0.14 0.185 0.505 0.1 0.07 1
86 0.14 0.185 0.505 0.1 0.07 1
87 0.14 0.185 0.505 0.1 0.07 1
88 0.14 0.185 0.505 0.1 0.07 1
89 0.14 0.185 0.505 0.1 0.07 1
90 0.14 0.185 0.505 0.1 0.07 1
91 0.14 0.185 0.505 0.1 0.07 1
92 0.14 0.185 0.505 0.1 0.07 1
93 0.14 0.185 0.505 0.1 0.07 1
94 0.14 0.185 0.505 0.1 0.07 1
95 0.14 0.185 0.505 0.1 0.07 1
96 0.14 0.185 0.505 0.1 0.07 1
97 0.14 0.185 0.505 0.1 0.07 1
98 0.14 0.185 0.505 0.1 0.07 1
99 0.14 0.185 0.505 0.1 0.07 1
100 0.14 0.185 0.505 0.1 0.07 1
101 0.14 0.185 0.505 0.1 0.07 1
102 0.14 0.185 0.505 0.1 0.07 1
103 0.14 0.185 0.505 0.1 0.07 1
104 0.14 0.185 0.505 0.1 0.07 1
105 0.14 0.185 0.505 0.1 0.07 1
106 0.14 0.185 0.505 0.1 0.07 1
107 0.14 0.185 0.505 0.1 0.07 1
108 0.14 0.185 0.505 0.1 0.07 1
109 0.14 0.185 0.505 0.1 0.07 1
110 0.14 0.185 0.505 0.1 0.07 1
111 0.14 0.185 0.505 0.1 0.07 1
112 0.14 0.185 0.505 0.1 0.07 1
113 0.14 0.185 0.505 0.1 0.07 1
114 0.14 0.185 0.505 0.1 0.07 1
115 0.14 0.185 0.505 0.1 0.07 1
116 0.14 0.185 0.505 0.1 0.07 1
117 0.14 0.185 0.505 0.1 0.07 1
118 0.14 0.185 0.505 0.1 0.07 1
119 0.14 0.185 0.505 0.1 0.07 1
120 0.14 0.185 0.505 0.1 0.07 1
121 0.14 0.185 0.505 0.1 0.07 1
122 0.14 0.185 0.505 0.1 0.07 1
123 0.14 0.185 0.505 0.1 0.07 1
124 0.14 0.185 0.505 0.1 0.07 1
125 0.14 0.185 0.505 0.1 0.07 1
126 0.14 0.185 0.505 0.1 0.07 1
127 0.14 0.185 0.505 0.1 0.07 1
128 0.14 0.185 0.505 0.1 0.07 1
129 0.14 0.185 0.505 0.1 0.07 1
130 0.14 0.185 0.505 0.1 0.07 1
131 0.14 0.185 0.505 0.1 0.07 1
132 0.14 0.185 0.505 0.1 0.07 1
133 0.14 0.185 0.505 0.1 0.07 1
134 0.14 0.185 0.505 0.1 0.07 1
135 0.14 0.185 0.505 0.1 0.07 1
136 0.14 0.185 0.505 0.1 0.07 1
137 0.14 0.185 0.505 0.1 0.07 1
138 0.14 0.185 0.505 0.1 0.07 1
139 0.14 0.185 0.505 0.1 0.07 1
140 0.14 0.185 0.505 0.1 0.07 1
141 0.14 0.185 0.505 0.1 0.07 1
142 0.14 0.185 0.505 0.1 0.07 1
143 0.14 0.185 0.505 0.1 0.07 1
144 0.14 0.185 0.505 0.1 0.07 1
145 0.14 0.185 0.505 0.1 0.07 1
146 0.14 0.185 0.505 0.1 0.07 1
147 0.14 0.185 0.505 0.1 0.07 1
148 0.14 0.185 0.505 0.1 0.07 1
149 0.14 0.185 0.505 0.1 0.07 1
150 0.14 0.185 0.505 0.1 0.07 1
151 0.14 0.185 0.505 0.1 0.07 1
152 0.14 0.185 0.505 0.1 0.07 1
153 0.14 0.185 0.505 0.1 0.07 1
154 0.14 0.185 0.505 0.1 0.07 1
155 0.14 0.185 0.505 0.1 0.07 1
156 0.14 0.185 0.505 0.1 0.07 1
157 0.14 0.185 0.505 0.1 0.07 1
158 0.14 0.185 0.505 0.1 0.07 1
159 0.14 0.185 0.505 0.1 0.07 1
160 0.14 0.185 0.505 0.1 0.07 1
161 0.14 0.185 0.505 0.1 0.07 1
162 0.14 0.185 0.505 0.1 0.07 1
163 0.14 0.185 0.505 0.1 0.07 1
164 0.14 0.185 0.505 0.1 0.07 1
165 0.14 0.185 0.505 0.1 0.07 1
166 0.14 0.185 0.505 0.1 0.07 1
167 0.14 0.185 0.505 0.1 0.07 1
168 0.14 0.185 0.505 0.1 0.07 1
169 0.14 0.185 0.505 0.1 0.07 1
170 0.14 0.185 0.505 0.1 0.07 1
171 0.14 0.185 0.505 0.1 0.07 1
172 0.14 0.185 0.505 0.1 0.07 1
173 0.14 0.185 0.505 0.1 0.07 1
174 0.14 0.185 0.505 0.1 0.07 1
175 0.14 0.185 0.505 0.1 0.07 1
176 0.14 0.185 0.505 0.1 0.07 1
177 0.14 0.185 0.505 0.1 0.07 1
178 0.14 0.185 0.505 0.1 0.07 1
179 0.14 0.185 0.505 0.1 0.07 1
180 0.14 0.185 0.505 0.1 0.07 1
181 0.14 0.185 0.505 0.1 0.07 1
182 0.14 0.185 0.505 0.1 0.07 1
183 0.14 0.185 0.505 0.1 0.07 1
184 0.14 0.185 0.505 0.1 0.07 1
185 0.14 0.185 0.505 0.1 0.07 1
186 0.14 0.185 0.505 0.1 0.07 1
187 0.14 0.185 0.505 0.1 0.07 1
188 0.14 0.185 0.505 0.1 0.07 1
189 0.14 0.185 0.505 0.1 0.07 1
190 0.14 0.185 0.505 0.1 0.07 1
191 0.14 0.185 0.505 0.1 0.07 1
192 0.14 0.185 0.505 0.1 0.07 1
193 0.14 0.185 0.505 0.1 0.07 1
194 0.14 0.185 0.505 0.1 0.07 1
195 0.14 0.185 0.505 0.1 0.07 1
196 0.14 0.185 0.505 0.1 0.07 1
197 0.14 0.185 0.505 0.1 0.07 1
198 0.14 0.185 0.505 0.1 0.07 1
199 0.14 0.185 0.505 0.1 0.07 1
200 0.14 0.185 0.505 0.1 0.07 1
Grand Total 28 37 101 20 14 200
--------------------------------------------------
Count of Number Actual or Observed Labels
Row Labels A B C D E Grand Total
1 through 50 7 9.25 25.25 5 3.5 50
50 through 100 7 9.25 25.25 5 3.5 50
100 through 150 7 9.25 25.25 5 3.5 50
150 through 200 7 9.25 25.25 5 3.5 50
Grand Total 28 37 101 20 14 200
Count of Number Expected Labels
Row Labels A B C D E Grand Total
1 through 50 7 9.25 25.25 5 3.5 50
50 through 100 7 9.25 25.25 5 3.5 50
100 through 150 7 9.25 25.25 5 3.5 50
150 through 200 7 9.25 25.25 5 3.5 50
Grand Total 28 37 101 20 14 200

Q1-4

Count of Age1 Column Labels
Row Labels A B C D E F G Grand Total
A 2 2 1 1 6
B 7 2 8 9 10 2 6 44
C 13 3 6 11 9 3 3 48
D 22 2 14 6 8 1 3 56
E 6 5 10 9 30
F 1 2 1 4
G 4 1 2 3 2 12
Grand Total 55 8 39 41 38 6 13 200
Ho: Age and groups are independent
Ha: Age and groups are dependent
Count of Age1 Actual or Observed Labels
Row Labels A B C D E F G Grand Total ChiSq Test: 0.8621020609
A 2 2 1 1 6
B 7 2 8 9 10 2 6 44 We don't have any statistical evidence to reject the Null.
C 13 3 6 11 9 3 3 48
D 22 2 14 6 8 1 3 56 The value in the expected table must be 5 or more to be eligible for the test!!!
E 6 5 10 9 30
F 1 2 1 4 ChiSq Test: 1.64111375005826E-279
G 4 1 2 3 2 12
Grand Total 55 8 39 41 38 6 13 200
Count of Age1 Expected Labels
Row Labels A B C D E F G Grand Total
A 1.65 0.24 1.17 1.23 1.14 0.18 0.39 6
B 12.1 1.76 8.58 9.02 8.36 1.32 2.86 44
C 13.2 1.92 9.36 9.84 9.12 1.44 3.12 48
D 15.4 2.24 10.92 11.48 10.64 1.68 3.64 56
E 8.25 1.2 5.85 6.15 5.7 0.9 1.95 30
F 1.1 0.16 0.78 0.82 0.76 0.12 0.26 4
G 3.3 0.48 2.34 2.46 2.28 0.36 0.78 12
Grand Total 55 8 39 41 38 6 13 200
Count of Age1 Actual or Observed Labels
Row Labels A B C D E F G Grand Total
A 22 5 16 21 9 5 10 6
D 28 2 19 16 17 1 3 56
F 5 1 4 4 2 4
Grand Total 55 8 39 41 38 6 13 200
Count of Age1 Actual or Observed Labels
Row Labels A B C D E F G Grand Total
A 1.65 0.24 1.17 1.23 1.14 0.18 0.39 6
D 15.4 2.24 10.92 11.48 10.64 1.68 3.64 56
F 1.1 0.16 0.78 0.82 0.76 0.12 0.26 4
Grand Total 55 8 39 41 38 6 13 200

Q2-Coffee

AQ6 Coffee G1 Coffee G2 Coffee G3 Coffee G4
A 12.99 9.47 5.36 13 ANOVA Test:
A 14.21 14.23 10.18 14.91
A 5.75 11.59 13.47 14.76 Ho: All means for the four groups in terms of Coffee Price are the same;
A 8.84 14.94 13.16 15 Ha: Not all means for the four groups in terms of Coffee Price are the same;
A 14.78 5.39 12.01 14.84
A 13.81 14.86 5.01 14.95
A 5.32 11.06 5.21 14.99 Anova: Single Factor
A 5.86 5.16 14.63 9.48
A 14.96 9.04 8.17 14.56 SUMMARY
A 13.16 5.06 13.92 14.96 Groups Count Sum Average Variance
A 7.07 5.68 14.41 6.54 Coffee G1 51 533.86 10.46784 13.16169
A 14.29 11.56 12.86 5.1 Coffee G2 50 525.08 10.50160 12.99763
A 5.41 12.32 13.96 5.13 Coffee G3 42 448.25 10.67262 13.00069
A 6.14 11.09 11.9 5.17 Coffee G4 57 567.18 9.95053 12.59319
A 12.85 15 5.23 14.63
A 11.62 14.89 14.78 10.11
A 7.09 14.1 10.59 12.49 ANOVA
A 13.69 15 14.5 8.18 Source of Variation SS df MS F P-value F crit
A 8.29 15 9.18 13.01 Between Groups 15.2294 3 5.07646 0.39278 0.75834 2.65068
A 5.17 12.8 7.65 11.82 Within Groups 2533.2156 196 12.9246
A 14.8 14.96 11.79 6.15
A 6.64 5.91 6.87 5.46 Total 2548.4450155 199
A 13.8 6.42 5.73 7.35
A 12.63 7.88 13.71 13.95 We do not have statistical evidence to reject the NULL hypothesis.
A 5.14 6.78 13.25 14.04 That means the four groups have no significant difference in the coffee price.
A 7.77 9.37 12.17 12.74
A 8.82 12.24 9.02 5.06
A 14.75 12.93 5.18 5.26
A 5.73 14.81 12.18 7
A 12.73 6.27 14.79 12.43
A 5.34 9.59 5.84 5.37
A 14.09 14.87 12.99 8.14
A 12.29 14.74 7.48 7.46
A 14.89 6.96 10.47 5.21
A 8.81 5.18 14.94 11.11
A 11.43 9.14 5.64 8.71
A 13.24 6.27 14.82 11.36
A 14.21 6.13 14.92 13.71
A 8.57 7.05 12.59 8.91
A 8.51 9.54 7.73 7.41
A 5.04 5.53 5.01 5.19
A 13.33 12.23 14.95 8.95
A 9.63 14.93 9.85
A 13.07 7.97 9.39
A 11.21 7.32 10.64
A 5.54 7.85 7.76
A 5.1 11.66 7.53
A 13.92 14.5 5.01
A 13.96 12.84 5.24
A 12.7 14.97 13.55
A 14.87 12.41
B 5.02
B 8.38
B 9.89
B 11.63
B 14.45
B 11.83
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

Q2-T-Shirt

AQ6 T-Shirt G1 T-Shirt G2 T-Shirt G3 T-Shirt G4
A 18.9 33.85 38.54 19.52
A 28.88 20.59 42.43 21.57 ANOVA Test:
A 45.48 42.13 22.57 19.93
A 43.31 25.46 42.64 33.2 Ho: All means for the four groups in terms of T-Shirt Price are the same;
A 17.42 39.84 43.1 24.58 Ha: Not all means for the four groups in terms of T-Shirt Price are the same;
A 36.13 36.32 30.78 23.82
A 43.65 37.15 30.71 44.02 Anova: Single Factor
A 28.38 41.85 22.44 33.21
A 28.43 41.3 29.5 23.65 SUMMARY
A 28.58 23.67 18.05 34.2 Groups Count Sum Average Variance
A 23.15 22.46 45.19 24.4 T-Shirt G1 51 1612.62 31.62 50.916796
A 31.42 19.97 17.43 31.34 T-Shirt G2 50 1599.23 31.9846 63.0310090204
A 36.91 29.83 41.19 27.9 T-Shirt G3 42 1385.23 32.9816666667 69.5415556911
A 34.92 20.82 28.57 27.37 T-Shirt G4 57 1734.49 30.4296491228 62.9352141604
A 35.75 39.4 37.01 23.92
A 26.73 39.03 26.63 20.99
A 34.04 25.2 20.16 22.38 ANOVA
A 23.19 37.8 34.87 31.25 Source of Variation SS df MS F P-value F crit
A 37.22 25.99 36.87 24.67 Between Groups 164.9991571842 3 54.9997190614 0.8975856172 0.4434269093 2.6506765101
A 28.07 28.56 25.91 21.12 Within Groups 12009.9350183158 196 61.2751786649
A 32.44 30.4 28.98 27.61
A 28.52 23.81 23.25 34.13 Total 12174.9341755 199
A 30.92 20.32 35.37 21.27
A 23.61 38.98 26.28 34.13
A 46.72 28.81 35.57 26.83 We do not have statistical evidence to reject the NULL hypothesis.
A 23.56 26.27 28.61 43.27 That means the four groups have no significant difference in the T-shirt price.
A 38.74 41.41 39.23 35.91
A 46.05 46.25 44.74 42.7
A 27.81 23.92 38.98 34.84
A 30.8 24.24 37.34 45.66
A 39.35 42.18 36.43 26.11
A 25.03 23.35 32.28 47.59
A 29.42 36.26 22.83 26
A 37.03 32.31 25.23 34.67
A 34.09 39.44 33.98 44.4
A 35.39 28.07 23.84 27.98
A 31.6 29.21 43.12 37.16
A 35.87 42.52 35.13 21.97
A 28.07 29.88 46.16 27.41
A 34.12 39.41 38.1 25.04
A 36.37 28.94 25.89 31.66
A 33.72 39.79 49.3 43.19
A 41.13 18.66 23.47
A 31.32 43.89 31.92
A 25.73 40.56 24.18
A 34.67 28.43 21.4
A 21.98 38.05 25.76
A 19.8 36.04 30.62
A 27.69 25.83 27.33
A 20.18 20.78 48.7
A 30.33 41.1
B 24.79
B 35.03
B 22.95
B 36.83
B 27.45
B 40.39
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

Q2-Shampoo

AQ6 Shampoo1 Shampoo2 Shampoo3 Shampoo4
A 5.06 1.97 5.58 1.32
A 3.5 4.41 4.28 4.36 ANOVA Test:
A 1.85 3.3 4.07 4.16
A 2.78 3.95 4.51 3.2 Ho: All means for the four groups in terms of Shampoo Price are the same;
A 2.7 6.66 2.13 2.77 Ha: Not all means for the four groups in terms of Shampoo Price are the same;
A 4.55 3.3 5.61 2.18
A 2.6 4.49 2.51 4.67 Anova: Single Factor
A 3.44 5.64 1.62 3.95
A 4.6 5.36 3.41 4.96 SUMMARY
A 3.4 6.02 2.74 4.46 Groups Count Sum Average Variance
A 6.65 4 1.88 2.49 Shampoo1 51 182.3 3.5745098039 2.6736292549
A 3.17 5.94 6.18 1.89 Shampoo2 50 198.51 3.9702 2.3781775102
A 2.57 4.59 2.58 3.96 Shampoo3 42 161.86 3.8538095238 2.0063851336
A 4.17 3.49 2.36 3.49 Shampoo4 57 207.83 3.6461403509 1.6561884085
A 1.45 3.45 4.35 3.32
A 1.8 8.05 4.9 3.4
A 1.36 4.25 5.9 2.69 ANOVA
A 5.63 1.66 2.83 3.73 Source of Variation SS df MS F P-value F crit
A 1.74 2.68 3.52 3.51 Between Groups 5.0612479015 3 1.6870826338 0.7776393532 0.5077406757 2.6506765101
A 7.63 5.26 2.82 5.04 Within Groups 425.2205020985 196 2.1694923576
A 2.06 4.69 4.84 3.76
A 4.14 2.91 2.48 4.01 Total 430.28175 199
A 3.56 3.21 3.2 3.1
A 3.13 2.29 3.21 6.66
A 1.44 2.48 6.51 2.48 We do not have statistical evidence to reject the NULL hypothesis.
A 1.98 3.91 2.64 4.53 That means the four groups have no significant difference in the Shampoo price.
A 1.43 4.25 1.61 1.63
A 5.91 1.75 2.85 5.11
A 2.44 3.16 3.12 4.31
A 5.32 3 5.24 3.36
A 4.86 3.64 3.98 3.93
A 2.77 2.81 4.66 4.68
A 5.16 1.48 2.82 5.04
A 1.44 4.58 4.04 2.47
A 4.62 3.05 3.7 3.65
A 1.6 2.44 3.72 4.2
A 4.23 4.98 7.1 2.74
A 2.83 2.87 3.17 3.6
A 2.45 2.89 3.46 5.39
A 4.69 7.02 6.51 2.96
A 3.7 5.89 5.48 5.76
A 6.57 6.05 3.74 1.65
A 2.77 2.98 3.11
A 3.38 6.57 2.05
A 3.14 3.14 2.38
A 2.37 5.95 4.9
A 4.84 3.34 1.31
A 7.52 3.23 6.63
A 5.64 3.91 4.41
A 2.33 1.57 3.63
A 3.33 4.02
B 3.81
B 6.62
B 1.72
B 3.64
B 2.76
B 2.27
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

Q3-1-

Count of Gender Column Labels
Row Labels A B C D E F G Grand Total
Female 2 23 18 22 16 4 6 91 Ho: Gender and groups are independent
Male 4 16 14 22 10 4 70 Ha: Gender and groups are dependent
Prefer not to say 5 16 12 4 2 39
Grand Total 6 44 48 56 30 4 12 200
ChiSq Test: 0.2795153159
Count of Gender Actual or Observed Labels
Row Labels A B C D E F G Grand Total We don't have any statistical evidence to reject the Null.
Female 2 23 18 22 16 4 6 91
Male 4 16 14 22 10 4 70 The value in the expected table must be 5 or more to be eligible for the test!!!
Prefer not to say 5 16 12 4 2 39 ChiSq Test: 0.1680189935
Grand Total 6 44 48 56 30 4 12 200
Count of Gender Expected Labels
Row Labels A B C D E F G Grand Total
Female 2.73 20.02 21.84 25.48 13.65 1.82 5.46 91
Male 2.1 15.4 16.8 19.6 10.5 1.4 4.2 70
Prefer not to say 1.17 8.58 9.36 10.92 5.85 0.78 2.34 39
Grand Total 6 44 48 56 30 4 12 200
Count of Gender Actual or Observed Labels
Row Labels A B C D E F G Grand Total
Female + Male 6 39 32 44 26 4 10 161
Prefer not to say 5 16 12 4 2 39
Grand Total 6 44 48 56 30 4 12 200
Count of Gender Expected Labels
Row Labels A B C D E F G Grand Total
Female + Male 4.83 35.42 38.64 45.08 24.15 3.22 9.66 161
Prefer not to say 1.17 8.58 9.36 10.92 5.85 0.78 2.34 39
Grand Total 6 44 48 56 30 4 12 200

Q3-2-

Count of Age1 Column Labels
Row Labels Female Male Prefer not to say Grand Total
A 2 4 6
B 23 16 5 44
C 18 14 16 48
D 22 22 12 56 Ho: Age and groups are independent
E 16 10 4 30 Ha: Age and groups are dependent
F 4 4
G 6 4 2 12
Grand Total 91 70 39 200 ChiSq Test: 0.2795153159
Count of Age1 Actual or Observed Labels We don't have any statistical evidence to reject the Null.
Row Labels Female Male Prefer not to say Grand Total
A 2 4 6 The value in the expected table must be 5 or more to be eligible for the test!!!
B 23 16 5 44
C 18 14 16 48 ChiSq Test: 0.6790177621
D 22 22 12 56
E 16 10 4 30
F 4 4
G 6 4 2 12
Grand Total 91 70 39 200
Count of Age1 Expected Labels
Row Labels Female Male Prefer not to say Grand Total
A 2.73 2.1 1.17 6
B 20.02 15.4 8.58 44
C 21.84 16.8 9.36 48
D 25.48 19.6 10.92 56
E 13.65 10.5 5.85 30
F 1.82 1.4 0.78 4
G 5.46 4.2 2.34 12
Grand Total 91 70 39 200
Count of Age1 Actual or Observed Labels
Row Labels Female Male Prefer not to say Grand Total
A 43 34 21 98
D 38 32 16 86
F 10 4 2 16
Grand Total 91 70 39 200
Count of Age1 Expected Labels
Row Labels Female Male Prefer not to say Grand Total
A 44.59 34.3 19.11 98
D 39.13 30.1 16.77 86
F 7.28 5.6 3.12 16
Grand Total 91 70 39 200

Q3-3-

Count of Ethinicity1 Column Labels
Row Labels A B C D E F G Grand Total
A 1 6 12 12 6 3 40
B 3 2 1 1 7
C 2 24 23 25 12 1 5 92
D 3 2 5 6 2 2 20
E 1 1 3 2 7
F 2 8 8 10 4 2 34 Ho: Ethnicity and groups are independent
Grand Total 6 44 48 56 30 4 12 200 Ha: Ethnicity and groups are dependent
Count of Ethinicity1 Actual or Observed Labels
Row Labels A B C D E F G Grand Total ChiSq Test: 0.5416678352
A 1 6 12 12 6 3 40
B 3 2 1 1 7 We don't have any statistical evidence to reject the Null.
C 2 24 23 25 12 1 5 92
D 3 2 5 6 2 2 20 The value in the expected table must be 5 or more to be eligible for the test!!!
E 1 1 3 2 7
F 2 8 8 10 4 2 34 ChiSq Test: 0.9404268535
Grand Total 6 44 48 56 30 4 12 200
Count of Ethinicity1 Expected Labels
Row Labels A B C D E F G Grand Total
A 1.2 8.8 9.6 11.2 6 0.8 2.4 40
B 0.21 1.54 1.68 1.96 1.05 0.14 0.42 7
C 2.76 20.24 22.08 25.76 13.8 1.84 5.52 92
D 0.6 4.4 4.8 5.6 3 0.4 1.2 20
E 0.21 1.54 1.68 1.96 1.05 0.14 0.42 7
F 1.02 7.48 8.16 9.52 5.1 0.68 2.04 34
Grand Total 6 44 48 56 30 4 12 200
Count of Ethinicity1 Actual or Observed Labels
Row Labels A B C D E F G Grand Total
A 1 9 14 13 6 1 3 47
C 2 27 25 30 18 3 7 112
E 3 8 9 13 6 2 41
Grand Total 6 44 48 56 30 4 12 200
Count of Ethinicity1 Expected Labels
Row Labels A B C D E F G Grand Total
A 1.41 10.34 11.28 13.16 7.05 0.94 2.82 47
C 3.36 24.64 26.88 31.36 16.8 2.24 6.72 112
E 1.23 9.02 9.84 11.48 6.15 0.82 2.46 41
Grand Total 6 44 48 56 30 4 12 200

Q3-4-

Sum of Household Column Labels
Row Labels 1 2 3 4 5 6 7 Grand Total
1 4 4
2 3 3
3 2 2
4 2 2
5 5 5
6 1 1
7 1 1
8 2 2
9 5 5
10 2 2
11 1 1
12 3 3
13 3 3
14 2 2
15 5 5
16 2 2
17 3 3
18 2 2
19 1 1
20 1 1
21 1 1
22 2 2
23 3 3
24 2 2
25 2 2
26 2 2
27 1 1
28 1 1
29 3 3
30 4 4
31 2 2
32 3 3
33 2 2
34 6 6
35 1 1
36 3 3
37 1 1
38 3 3
39 3 3
40 2 2
41 2 2
42 1 1
43 3 3
44 3 3
45 1 1
46 3 3
47 2 2
48 5 5
49 3 3
50 3 3
51 2 2
52 1 1
53 1 1
54 5 5
55 4 4
56 3 3
57 4 4
58 4 4
59 3 3
60 4 4
61 2 2
62 2 2
63 1 1
64 2 2
65 4 4
66 1 1
67 5 5
68 2 2
69 5 5
70 4 4
71 2 2
72 3 3
73 5 5
74 7 7
75 5 5
76 2 2
77 3 3
78 2 2
79 1 1
80 3 3
81 3 3
82 1 1
83 3 3
84 4 4
85 1 1
86 1 1
87 5 5
88 4 4
89 1 1
90 5 5
91 4 4
92 3 3
93 3 3
94 1 1
95 1 1
96 3 3
97 2 2
98 2 2
99 6 6
100 2 2
101 3 3
102 3 3
103 2 2
104 2 2
105 7 7
106 2 2
107 7 7
108 1 1
109 2 2
110 4 4
111 3 3
112 3 3
113 3 3
114 5 5
115 2 2
116 5 5
117 2 2
118 5 5
119 4 4
120 3 3
121 2 2
122 3 3
123 7 7
124 2 2
125 1 1
126 3 3
127 6 6
128 1 1
129 4 4
130 7 7
131 6 6
132 5 5
133 2 2
134 3 3
135 4 4
136 4 4
137 7 7
138 1 1
139 4 4
140 2 2
141 1 1
142 2 2
143 3 3
144 2 2
145 4 4
146 1 1
147 2 2
148 2 2
149 1 1
150 2 2
151 2 2
152 2 2
153 3 3
154 3 3
155 1 1
156 2 2
157 2 2
158 1 1
159 2 2
160 5 5
161 3 3
162 1 1
163 2 2
164 2 2
165 3 3
166 3 3
167 2 2
168 2 2
169 1 1
170 5 5
171 2 2
172 2 2
173 4 4
174 3 3
175 2 2
176 7 7
177 1 1
178 5 5
179 2 2
180 3 3
181 6 6
182 2 2
183 2 2
184 1 1
185 2 2
186 2 2
187 7 7
188 2 2
189 2 2
190 2 2
191 2 2
192 1 1
193 1 1
194 1 1
195 2 2
196 4 4
197 1 1
198 5 5
199 2 2
200 3 3
Grand Total 40 130 129 80 95 30 56 560
Sum of Household Actual or Observed Labels
Row Labels 1 2 3 4 5 6 7 Grand Total
1 4 4
2 3 3
3 2 2
4 2 2
5 5 5
6 1 1
7 1 1
8 2 2
9 5 5
10 2 2
11 1 1
12 3 3
13 3 3
14 2 2
15 5 5
16 2 2
17 3 3
18 2 2
19 1 1
20 1 1
21 1 1
22 2 2
23 3 3
24 2 2
25 2 2
26 2 2
27 1 1
28 1 1
29 3 3
30 4 4
31 2 2
32 3 3
33 2 2
34 6 6
35 1 1
36 3 3
37 1 1
38 3 3
39 3 3
40 2 2
41 2 2
42 1 1
43 3 3
44 3 3
45 1 1
46 3 3
47 2 2
48 5 5
49 3 3
50 3 3
51 2 2
52 1 1
53 1 1
54 5 5
55 4 4
56 3 3
57 4 4
58 4 4
59 3 3
60 4 4
61 2 2
62 2 2
63 1 1
64 2 2
65 4 4
66 1 1
67 5 5
68 2 2
69 5 5
70 4 4
71 2 2
72 3 3
73 5 5
74 7 7
75 5 5
76 2 2
77 3 3
78 2 2
79 1 1
80 3 3
81 3 3
82 1 1
83 3 3
84 4 4
85 1 1
86 1 1
87 5 5
88 4 4
89 1 1
90 5 5
91 4 4
92 3 3
93 3 3
94 1 1
95 1 1
96 3 3
97 2 2
98 2 2
99 6 6
100 2 2
101 3 3
102 3 3
103 2 2
104 2 2
105 7 7
106 2 2
107 7 7
108 1 1
109 2 2
110 4 4
111 3 3
112 3 3
113 3 3
114 5 5
115 2 2
116 5 5
117 2 2
118 5 5
119 4 4
120 3 3
121 2 2
122 3 3
123 7 7
124 2 2
125 1 1
126 3 3
127 6 6
128 1 1
129 4 4
130 7 7
131 6 6
132 5 5
133 2 2
134 3 3
135 4 4
136 4 4
137 7 7
138 1 1
139 4 4
140 2 2
141 1 1
142 2 2
143 3 3
144 2 2
145 4 4
146 1 1
147 2 2
148 2 2
149 1 1
150 2 2
151 2 2
152 2 2
153 3 3
154 3 3
155 1 1
156 2 2
157 2 2
158 1 1
159 2 2
160 5 5
161 3 3
162 1 1
163 2 2
164 2 2
165 3 3
166 3 3
167 2 2
168 2 2
169 1 1
170 5 5
171 2 2
172 2 2
173 4 4
174 3 3
175 2 2
176 7 7
177 1 1
178 5 5
179 2 2
180 3 3
181 6 6
182 2 2
183 2 2
184 1 1
185 2 2
186 2 2
187 7 7
188 2 2
189 2 2
190 2 2
191 2 2
192 1 1
193 1 1
194 1 1
195 2 2
196 4 4
197 1 1
198 5 5
199 2 2 Ho: Household and groups are independent
200 3 3 Ha: Household and groups are dependent
Grand Total 40 130 129 80 95 30 56 560
Sum of Household Expected Labels
Row Labels 1 2 3 4 5 6 7 Grand Total ChiSq Test: 1.00760895890144E-142
1 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
2 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
3 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2 We don't have any statistical evidence to reject the Null.
4 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
5 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5 The value in the expected table must be 5 or more to be eligible for the test!!!
6 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
7 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1 ChiSq Test: 1
8 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
9 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
10 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
11 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
12 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
13 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
14 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
15 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
16 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
17 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
18 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
19 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
20 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
21 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
22 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
23 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
24 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
25 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
26 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
27 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
28 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
29 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
30 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
31 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
32 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
33 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
34 0.4285714286 1.3928571429 1.3821428571 0.8571428571 1.0178571429 0.3214285714 0.6 6
35 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
36 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
37 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
38 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
39 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
40 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
41 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
42 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
43 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
44 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
45 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
46 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
47 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
48 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
49 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
50 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
51 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
52 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
53 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
54 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
55 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
56 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
57 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
58 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
59 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
60 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
61 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
62 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
63 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
64 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
65 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
66 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
67 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
68 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
69 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
70 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
71 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
72 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
73 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
74 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
75 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
76 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
77 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
78 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
79 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
80 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
81 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
82 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
83 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
84 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
85 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
86 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
87 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
88 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
89 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
90 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
91 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
92 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
93 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
94 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
95 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
96 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
97 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
98 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
99 0.4285714286 1.3928571429 1.3821428571 0.8571428571 1.0178571429 0.3214285714 0.6 6
100 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
101 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
102 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
103 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
104 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
105 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
106 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
107 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
108 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
109 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
110 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
111 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
112 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
113 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
114 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
115 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
116 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
117 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
118 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
119 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
120 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
121 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
122 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
123 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
124 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
125 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
126 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
127 0.4285714286 1.3928571429 1.3821428571 0.8571428571 1.0178571429 0.3214285714 0.6 6
128 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
129 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
130 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
131 0.4285714286 1.3928571429 1.3821428571 0.8571428571 1.0178571429 0.3214285714 0.6 6
132 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
133 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
134 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
135 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
136 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
137 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
138 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
139 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
140 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
141 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
142 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
143 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
144 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
145 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
146 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
147 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
148 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
149 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
150 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
151 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
152 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
153 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
154 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
155 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
156 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
157 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
158 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
159 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
160 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
161 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
162 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
163 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
164 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
165 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
166 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
167 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
168 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
169 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
170 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
171 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
172 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
173 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
174 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
175 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
176 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
177 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
178 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
179 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
180 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
181 0.4285714286 1.3928571429 1.3821428571 0.8571428571 1.0178571429 0.3214285714 0.6 6
182 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
183 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
184 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
185 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
186 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
187 0.5 1.625 1.6125 1 1.1875 0.375 0.7 7
188 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
189 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
190 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
191 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
192 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
193 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
194 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
195 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
196 0.2857142857 0.9285714286 0.9214285714 0.5714285714 0.6785714286 0.2142857143 0.4 4
197 0.0714285714 0.2321428571 0.2303571429 0.1428571429 0.1696428571 0.0535714286 0.1 1
198 0.3571428571 1.1607142857 1.1517857143 0.7142857143 0.8482142857 0.2678571429 0.5 5
199 0.1428571429 0.4642857143 0.4607142857 0.2857142857 0.3392857143 0.1071428571 0.2 2
200 0.2142857143 0.6964285714 0.6910714286 0.4285714286 0.5089285714 0.1607142857 0.3 3
Grand Total 40 130 129 80 95 30 56 560
--------------------------------------------------
Sum of Household Expected Labels
Row Labels 1 2 3 4 5 6 7 Grand Total
1 through 50 8.7857142857 28.5535714286 28.3339285714 17.5714285714 20.8660714286 6.5892857143 12.3 123
50 through 100 10.5 34.125 33.8625 21 24.9375 7.875 14.7 147
100 through 150 11.5714285714 37.6071428571 37.3178571429 23.1428571429 27.4821428571 8.6785714286 16.2 162
150 through 200 9.1428571429 29.7142857143 29.4857142857 18.2857142857 21.7142857143 6.8571428571 12.8 128
Grand Total 40 130 129 80 95 30 56 560
Sum of Household Expected Labels
Row Labels 1 2 3 4 5 6 7 Grand Total
1 through 50 8.7857142857 28.5535714286 28.3339285714 17.5714285714 20.8660714286 6.5892857143 12.3 123
50 through 100 10.5 34.125 33.8625 21 24.9375 7.875 14.7 147
100 through 150 11.5714285714 37.6071428571 37.3178571429 23.1428571429 27.4821428571 8.6785714286 16.2 162
150 through 200 9.1428571429 29.7142857143 29.4857142857 18.2857142857 21.7142857143 6.8571428571 12.8 128
Grand Total 40 130 129 80 95 30 56 560

Final Work

ANOVA TEST 1
Variation source SS df MS F P Value F critic
Sample 23788427 4 1783287 1.345252 0.93272 2.47293
Columns 72645673 1 89167646 11.23467 0.00094 3.542435
interaction 52748278 4 32763752 2.038346 0.0924674 2.424678
within 5.42E+10 90 54524655 Sum of P Value Sum of F critic
1.0261274 8.440043
total 8.25E+10
ANOVA TEST 2
Variation source SS df MS F P Value F critic
Sample 40173783 4 10042674 1.548553 0.208948 2.834853
Columns 82947674 1 80523789 13.824787 0.00055 3.874267
interaction 53467626 4 13589898 2.038346 0.0954332 2.267444
within 5.83E+10 90 558978742
total 8.89855+10
ANOVA TEST 3
Variation source SS df MS F P Value F critic
Sample 544924877 4 22033575 1.425444 0.101783 2.5264255
Columns 98727353 1 5985975 11.47853 0.005455 3.542421
interaction 53467626 4 338789355 2.038346 0.092435 2.230344
within 5.83E+10 90 544765645 Sum of F critic Sum of P Value
8.2991905 0.199673
total 9.22E+10

Sum of P Value Total 1.0261274 Sum of F critic Total 8.4400429999999993

Sum of F critic Total 8.2991904999999999 Sum of P Value Total 0.19967299999999999

survey data

Number Q1A Q2A Q3A Q4A AQ51 AQ52 AQ53 AQ54 AQ55 AQ56 AQ57 AQ58 AQ6 Coffee G1 Coffee G2 Coffee G3 Coffee G4 CoffeeAll T-Shirt G1 T-Shirt G2 T-Shirt G3 T-Shirt G4 T-Shirt All Shampoo1 Shampoo2 Shampoo3 Shampoo4 Shampoo All Detergent1 Detergent2 Detergent3 Detergent4 Juice 1 Juice 2 Juice 3 Juice 4 Cleaner 1 Cleaner 2 Cleaner 3 Cleaner 4 Gender Age1 Ethinicity1 Household Income1 Marital 1 Education Political
12 A C B D 6 6 3 2 1 2 1 6 A 12.99 12.99 18.9 18.9 5.06 5.06 6.97 1.02 6.9 Female E C 3 E B F A
13 B C C A 2 2 1 6 7 2 1 4 A 14.21 14.21 28.88 28.88 3.5 3.5 7.48 1.27 3.57 Prefer not to say E C 3 E B C A
15 B C A C 4 1 1 7 6 4 1 3 A 5.75 5.75 45.48 45.48 1.85 1.85 8.62 3.13 1.22 Female F C 5 D B B A
16 A E B A 6 6 1 2 6 1 4 2 A 8.84 8.84 43.31 43.31 2.78 2.78 9.07 2.07 5.4 Male C A 2 E A A A
18 C B A E 6 6 1 1 2 6 5 4 A 14.78 14.78 17.42 17.42 2.7 2.7 6 3.92 2.2 Prefer not to say B C 2 D A B B
19 A E A C 7 5 1 5 1 4 2 3 A 13.81 13.81 36.13 36.13 4.55 4.55 8.9 1.08 1.11 Male G A 1 E A C B
20 A B B A 7 3 1 7 1 4 3 5 A 5.32 5.32 43.65 43.65 2.6 2.6 8.78 1.16 6.98 Male D C 1 C C B B
21 B A B E 7 6 1 6 6 1 1 2 A 5.86 5.86 28.38 28.38 3.44 3.44 6.98 1.86 1.8 Male C F 1 E F G B
23 B B B A 7 2 2 6 4 4 1 4 A 14.96 14.96 28.43 28.43 4.6 4.6 7.55 2.09 5.71 Male D C 3 F F B B
26 A C A D 6 6 1 4 2 4 1 4 A 13.16 13.16 28.58 28.58 3.4 3.4 8.38 2.47 6.92 Female C C 2 G B C A
28 B E B A 6 3 4 2 1 1 1 4 A 7.07 7.07 23.15 23.15 6.65 6.65 8.03 2.19 6.88 Male D C 1 G A B A
33 A A B C 4 6 4 1 1 4 4 6 A 14.29 14.29 31.42 31.42 3.17 3.17 7.87 1.03 5.16 Male B A 2 D F E B
34 B C B C 6 6 2 1 5 1 1 3 A 5.41 5.41 36.91 36.91 2.57 2.57 9.38 1.08 5.94 Prefer not to say C C 6 C C C A
46 B C D E 7 1 3 5 1 1 2 4 A 6.14 6.14 34.92 34.92 4.17 4.17 6.84 1.07 4.94 Female E C 3 A C C A
48 A A A A 6 2 1 4 3 6 6 5 A 12.85 12.85 35.75 35.75 1.45 1.45 7.54 2.1 3.33 Prefer not to say C A 5 E D G A
51 A B B A 7 2 1 2 1 6 1 5 A 11.62 11.62 26.73 26.73 1.8 1.8 8.22 4.13 5.15 Female B C 2 E F C B
53 A C A C 6 5 1 1 1 1 1 4 A 7.09 7.09 34.04 34.04 1.36 1.36 8.56 2.52 4.17 Prefer not to say B D 1 E B G A
57 A C A A 1 3 2 6 2 2 1 5 A 13.69 13.69 23.19 23.19 5.63 5.63 6.73 3.17 6.99 Female C A 4 F E C B
60 D D B B 7 6 1 6 2 4 5 4 A 8.29 8.29 37.22 37.22 1.74 1.74 8.8 1.77 2.35 Female B C 4 E A D A
65 A C D A 6 1 2 1 1 2 1 3 A 5.17 5.17 28.07 28.07 7.63 7.63 9.42 3.88 1.09 Female B F 4 D A D B
70 B C B G 4 6 4 6 2 1 1 4 A 14.8 14.8 32.44 32.44 2.06 2.06 6.64 1.24 2.9 Female B A 4 H C B B
74 A C B D 4 5 1 5 3 3 1 3 A 6.64 6.64 28.52 28.52 4.14 4.14 7.33 1.07 1.33 Male C D 7 E B B B
77 A C B D 7 5 1 5 2 1 1 2 A 13.8 13.8 30.92 30.92 3.56 3.56 8.32 2.51 1.77 Male B C 3 D F C B
93 A C A B 6 6 5 7 7 3 2 4 A 12.63 12.63 23.61 23.61 3.13 3.13 9.07 1.17 5.11 Female B C 3 H A D B
97 B E B A 7 6 4 6 4 1 3 2 A 5.14 5.14 46.72 46.72 1.44 1.44 8.41 1.28 3.62 Female D A 2 A B C C
101 A C D E 7 2 1 6 5 1 3 4 A 7.77 7.77 23.56 23.56 1.98 1.98 9.22 3.11 2.2 Male D F 3 H B F C
107 A C B D 7 6 3 6 1 4 1 5 A 8.82 8.82 38.74 38.74 1.43 1.43 7.65 1.08 5.74 Female F B 7 D D D A
114 A C A G 4 6 1 6 1 1 1 4 A 14.75 14.75 46.05 46.05 5.91 5.91 9.22 1.39 2.69 Female B C 5 H A B A
118 B C B D 3 6 5 2 3 6 5 5 A 5.73 5.73 27.81 27.81 2.44 2.44 8.9 1.86 6.4 Female E F 5 E B C A
123 C B A C 6 4 1 4 2 4 1 2 A 12.73 12.73 30.8 30.8 5.32 5.32 7.74 2.49 1.96 Female B F 7 C B D B
129 B B B A 7 3 5 6 5 5 1 5 A 5.34 5.34 39.35 39.35 4.86 4.86 8.81 1.12 6.99 Prefer not to say D C 4 I A B B
134 D C C A 6 2 1 5 3 1 2 2 A 14.09 14.09 25.03 25.03 2.77 2.77 7.64 3.22 2.32 Prefer not to say C C 3 I F C A
137 B A B C 7 6 1 5 2 6 2 4 A 12.29 12.29 29.42 29.42 5.16 5.16 8.11 1.99 6.42 Female D D 7 E C B A
138 B A A E 7 6 1 6 2 5 2 5 A 14.89 14.89 37.03 37.03 1.44 1.44 8.6 1.65 3.39 Male B C 1 H C B B
140 A D A E 6 3 1 4 4 1 1 5 A 8.81 8.81 34.09 34.09 4.62 4.62 6.26 2.07 1.31 Female B B 2 C B F C
149 A B A A 6 6 2 1 3 1 2 6 A 11.43 11.43 35.39 35.39 1.6 1.6 7.2 1.35 3.85 Female C C 1 G F B A
154 A C D A 7 5 4 3 3 1 3 6 A 13.24 13.24 31.6 31.6 4.23 4.23 7.96 1.32 1.06 Male D C 3 I B F A
156 A A A D 7 3 1 6 1 1 6 5 A 14.21 14.21 35.87 35.87 2.83 2.83 9.35 3.5 2.25 Female G D 2 I B F B
162 A C A A 5 6 2 3 1 1 1 6 A 8.57 8.57 28.07 28.07 2.45 2.45 5.7 1.97 4.02 Male D F 1 D B C A
167 A C D E 5 6 1 1 2 4 1 4 A 8.51 8.51 34.12 34.12 4.69 4.69 8.18 2.86 4.55 Female B C 2 C B C B
168 A C B D 4 6 3 6 6 1 6 5 A 5.04 5.04 36.37 36.37 3.7 3.7 7.23 2.77 1.02 Male B C 2 E A B A
172 A D D E 7 3 1 5 1 1 1 6 A 13.33 13.33 33.72 33.72 6.57 6.57 7.84 1.92 4.22 Male D C 2 G C G A
174 A C B A 6 6 1 5 1 5 6 5 A 9.63 9.63 41.13 41.13 2.77 2.77 7.66 2.04 3.89 Male B C 3 D A B A
176 B B E E 6 6 1 2 1 6 1 5 A 13.07 13.07 31.32 31.32 3.38 3.38 7.67 2.19 1.64 Prefer not to say E C 7 F B B A
178 B E B G 7 6 1 5 1 4 1 5 A 11.21 11.21 25.73 25.73 3.14 3.14 8.54 1.01 1.34 Male B B 5 H A D A
181 B C B E 7 3 2 3 5 1 3 4 A 5.54 5.54 34.67 34.67 2.37 2.37 9.55 1.37 6.32 Female B C 6 E B E B
187 B A A A 6 6 1 7 1 6 1 5 A 5.1 5.1 21.98 21.98 4.84 4.84 9.44 1.86 4.04 Male G C 7 C B C B
194 A A B E 7 6 1 1 5 1 1 3 A 13.92 13.92 19.8 19.8 7.52 7.52 8.34 1.1 3.12 Male D C 1 I A C B
197 D D A D 5 2 5 2 1 5 2 2 A 13.96 13.96 27.69 27.69 5.64 5.64 8.14 1 6.98 Male C E 1 G A C A
199 A E A C 6 3 1 7 6 5 5 5 A 12.7 12.7 20.18 20.18 2.33 2.33 8.63 1.38 4.95 Female D D 2 H A F C
200 B C A E 7 5 1 4 1 3 5 3 A 14.87 14.87 30.33 30.33 3.33 3.33 9.56 1.09 4.43 Male C C 3 F B C B
1 A C B C 6 3 4 2 4 4 6 5 B 9.47 9.47 33.85 33.85 1.97 1.97 6.78 3.89 2.25 Prefer not to say D C 4 G B B A
3 B C A G 7 6 1 7 1 4 1 1 B 14.23 14.23 20.59 20.59 4.41 4.41 7.78 4.5 1.14 Female C A 2 H F B B
4 B C B B 4 5 4 1 2 4 1 5 B 11.59 11.59 42.13 42.13 3.3 3.3 8.79 3.46 2.58 Female G A 2 E B B A
7 B B B G 7 4 2 6 1 4 1 4 B 14.94 14.94 25.46 25.46 3.95 3.95 6.05 4.48 1.3 Prefer not to say D F 1 D B G B
9 B C D E 7 2 4 2 3 1 1 4 B 5.39 5.39 39.84 39.84 6.66 6.66 7.23 3.22 3.01 Male D F 5 D A C B
22 D D B A 7 1 1 2 1 1 1 4 B 14.86 14.86 36.32 36.32 3.3 3.3 7.02 4.03 1.9 Female D D 2 B B G A
24 A C A D 7 3 1 2 6 7 1 5 B 11.06 11.06 37.15 37.15 4.49 4.49 5.85 3.34 1.31 Female B A 2 I C C B
38 A A D G 6 6 5 1 1 1 1 4 B 5.16 5.16 41.85 41.85 5.64 5.64 7.22 4.58 3.76 Prefer not to say D C 3 C A G B
41 A C B A 5 4 2 6 1 1 6 4 B 9.04 9.04 41.3 41.3 5.36 5.36 7.72 2.92 1.94 Female B F 2 E C D D
52 A B A B 7 6 1 7 5 5 7 4 B 5.06 5.06 23.67 23.67 6.02 6.02 9.57 4.29 4.59 Male C C 1 E B B B
59 A C B A 6 5 1 2 5 1 1 5 B 5.68 5.68 22.46 22.46 4 4 7.73 4.34 3.87 Male E A 3 F B G D
61 A C D E 7 3 4 3 6 4 1 5 B 11.56 11.56 19.97 19.97 5.94 5.94 5.85 3.54 2.22 Male E C 2 D B E A
64 D A B A 7 4 1 1 1 1 2 5 B 12.32 12.32 29.83 29.83 4.59 4.59 5.6 4.8 2.53 Female D C 2 E A B A
68 B B B G 6 6 1 1 3 1 3 4 B 11.09 11.09 20.82 20.82 3.49 3.49 8.57 2.95 3.75 Female C C 2 A A C B
69 A C B F 4 6 7 1 5 2 2 4 B 15 15 39.4 39.4 3.45 3.45 8.11 4.09 2.23 Male C C 5 F C D B
78 A C B D 7 1 1 6 1 1 1 3 B 14.89 14.89 39.03 39.03 8.05 8.05 8.22 4.67 3.24 Male B B 2 E B F B
81 A C B C 6 4 4 6 4 1 1 5 B 14.1 14.1 25.2 25.2 4.25 4.25 6.81 4.32 5.65 Male B F 3 E B D B
84 B C B E 7 1 1 1 5 4 1 6 B 15 15 37.8 37.8 1.66 1.66 8.34 3.77 5.17 Male D C 4 G E B B
85 A C B D 5 5 2 6 6 1 1 3 B 15 15 25.99 25.99 2.68 2.68 7.33 3.46 1.69 Prefer not to say D A 1 A B E A
87 A A A G 4 3 1 1 1 1 7 5 B 12.8 12.8 28.56 28.56 5.26 5.26 7.2 4.92 1.38 Male B D 5 I B E B
91 D D A A 7 6 1 5 1 5 1 2 B 14.96 14.96 30.4 30.4 4.69 4.69 4.27 4.27 1.54 Female D E 4 F B D B
103 A B B C 7 6 4 5 3 1 1 6 B 5.91 5.91 23.81 23.81 2.91 2.91 6.22 3.96 3.46 Female B C 2 C C B B
104 B A A A 6 6 1 1 1 5 1 4 B 6.42 6.42 20.32 20.32 3.21 3.21 8.02 3.71 3.21 Male D F 2 F B D A
106 D C A A 7 6 2 7 1 4 1 5 B 7.88 7.88 38.98 38.98 2.29 2.29 7.11 3.14 1.93 Female D F 2 D B E A
108 B C D C 6 2 4 5 1 1 1 6 B 6.78 6.78 28.81 28.81 2.48 2.48 8.16 4.9 1.22 Female D C 1 F D B A
109 A D B C 7 1 2 2 7 6 2 1 B 9.37 9.37 26.27 26.27 3.91 3.91 7.07 4.9 1.71 Female B F 2 E A F B
111 B C B C 7 6 1 5 1 4 1 4 B 12.24 12.24 41.41 41.41 4.25 4.25 6.07 3.84 3.83 Female E F 3 D F C A
126 B C D C 6 6 4 1 1 2 6 4 B 12.93 12.93 46.25 46.25 1.75 1.75 5.7 4.8 3.48 Female C C 3 E B A A
127 A D C D 7 5 1 6 1 1 1 4 B 14.81 14.81 23.92 23.92 3.16 3.16 6.43 4.23 2.9 Female B F 6 D B C B
132 B C B E 7 6 2 1 1 1 2 4 B 6.27 6.27 24.24 24.24 3 3 6.03 2.54 4.1 Female E E 5 D C E A
135 B B D D 7 2 1 4 4 5 1 5 B 9.59 9.59 42.18 42.18 3.64 3.64 6.56 3.89 1.28 Female C C 4 E D B A
136 A C B D 6 1 1 1 5 1 2 4 B 14.87 14.87 23.35 23.35 2.81 2.81 6.1 4.59 1.32 Male C A 4 D B F B
141 A C B C 7 4 1 2 1 1 2 4 B 14.74 14.74 36.26 36.26 1.48 1.48 8.19 4.19 1.05 Male A C 1 F B D A
143 D A D A 6 2 4 7 1 7 6 5 B 6.96 6.96 32.31 32.31 4.58 4.58 9.33 3.6 1.28 Male E D 3 I B B B
144 B C A E 7 2 2 2 1 4 1 5 B 5.18 5.18 39.44 39.44 3.05 3.05 7.43 4.41 3.09 Female B C 2 E B D C
150 A C C B 7 6 1 7 2 6 1 3 B 9.14 9.14 28.07 28.07 2.44 2.44 7.05 3.86 3.29 Male C A 2 I E C B
152 A C B G 7 6 1 5 4 1 1 6 B 6.27 6.27 29.21 29.21 4.98 4.98 6.48 4.04 2.47 Prefer not to say C C 2 F E G C
161 A C A A 5 3 4 2 2 1 1 2 B 6.13 6.13 42.52 42.52 2.87 2.87 5.55 3.17 1.38 Male D A 3 D B F B
165 D B B C 6 6 1 4 1 6 1 5 B 7.05 7.05 29.88 29.88 2.89 2.89 6.68 3.32 1.11 Male C C 3 B F C B
166 B E D A 6 2 4 1 6 4 5 5 B 9.54 9.54 39.41 39.41 7.02 7.02 5.72 3.8 5.11 Female A F 3 G A B B
170 B C A D 7 3 1 5 3 5 1 3 B 5.53 5.53 28.94 28.94 5.89 5.89 6.99 4.16 2.46 Female E D 5 D E C B
177 B C D D 6 3 1 4 1 5 1 3 B 12.23 12.23 39.79 39.79 6.05 6.05 5.76 2.94 2.8 Male C A 1 G B C A
180 B C C A 7 1 4 4 1 6 1 6 B 14.93 14.93 18.66 18.66 2.98 2.98 6.17 3.13 3.26 Female C C 3 I A C A
182 A C D D 7 6 1 2 5 1 2 4 B 7.97 7.97 43.89 43.89 6.57 6.57 7.12 4 1.84 Female G C 2 G B G B
183 A A A C 6 7 4 5 2 1 1 2 B 7.32 7.32 40.56 40.56 3.14 3.14 6.93 4.34 1.36 Female B C 2 F B B B
184 B E A A 5 2 1 1 6 1 1 3 B 7.85 7.85 28.43 28.43 5.95 5.95 8.39 3.37 1.22 Female C C 1 I E F A
186 A C D E 6 2 1 2 2 6 2 2 B 11.66 11.66 38.05 38.05 3.34 3.34 6.78 4.5 1.26 Prefer not to say B C 2 D A A C
190 C C A E 7 6 1 4 2 6 1 4 B 14.5 14.5 36.04 36.04 3.23 3.23 4.76 4.02 2.8 Female D E 2 D F B B
191 A C E C 1 3 1 1 1 1 6 5 B 12.84 12.84 25.83 25.83 3.91 3.91 6.42 3.86 3.45 Prefer not to say C A 2 H A B A
192 C A B F 7 3 5 6 1 1 1 5 B 14.97 14.97 20.78 20.78 1.57 1.57 8.37 4.92 2.1 Prefer not to say C B 1 H A D A
5 A C B A 6 4 3 1 1 3 6 4 C 5.36 5.36 38.54 38.54 5.58 5.58 9.66 3.99 6.11 Male D A 5 D B G A
10 A C B C 6 6 4 2 1 3 1 5 C 10.18 10.18 42.43 42.43 4.28 4.28 4.28 3.6 4.44 Prefer not to say G A 2 C E D B
14 A C D E 6 1 1 7 1 6 1 6 C 13.47 13.47 22.57 22.57 4.07 4.07 4.61 1.85 6.28 Female D A 2 I E D B
27 A C B C 7 6 4 1 1 1 1 3 C 13.16 13.16 42.64 42.64 4.51 4.51 5.2 3.76 6.29 Male E C 1 A B C B
36 B C D A 4 5 1 4 2 4 1 5 C 12.01 12.01 43.1 43.1 2.13 2.13 4.96 3.2 5.39 Female E C 3 H A C B
37 A B B A 6 6 4 2 3 6 1 5 C 5.01 5.01 30.78 30.78 5.61 5.61 9.99 2.7 5.42 Prefer not to say C C 1 D B E B
42 B A E F 3 6 4 3 2 6 4 4 C 5.21 5.21 30.71 30.71 2.51 2.51 9.56 3.28 3.96 Male D F 1 E B C A
44 A D D D 7 2 1 7 1 5 2 5 C 14.63 14.63 22.44 22.44 1.62 1.62 9.66 3.04 6.9 Male E C 3 G A B A
45 B A D A 6 1 1 3 2 5 5 5 C 8.17 8.17 29.5 29.5 3.41 3.41 4 1.41 4.57 Prefer not to say C F 1 D A F A
49 A C B D 6 6 5 6 1 5 1 2 C 13.92 13.92 18.05 18.05 2.74 2.74 9.91 1.99 6.85 Female B A 3 I E C C
54 A B B D 7 1 5 2 6 4 1 4 C 14.41 14.41 45.19 45.19 1.88 1.88 4.03 1.86 3.55 Female D C 5 D B C B
62 B C B E 6 3 1 6 2 4 1 2 C 12.86 12.86 17.43 17.43 6.18 6.18 4.1 3.19 6.41 Female C D 2 B A C A
67 B C E A 6 1 4 1 5 4 1 4 C 13.96 13.96 41.19 41.19 2.58 2.58 9.13 2.06 5.98 Male B D 5 G A E B
72 B A A C 5 5 1 1 2 5 6 5 C 11.9 11.9 28.57 28.57 2.36 2.36 7.97 2.05 3.48 Prefer not to say D A 3 F B C A
79 B C D D 6 3 1 4 5 6 3 4 C 5.23 5.23 37.01 37.01 4.35 4.35 9.01 3.99 6.58 Prefer not to say C C 1 I B G C
80 B E B A 7 4 1 3 1 4 1 2 C 14.78 14.78 26.63 26.63 4.9 4.9 9.97 3.42 6.42 Prefer not to say D A 3 D D B D
82 D C C E 7 1 4 1 5 1 1 5 C 10.59 10.59 20.16 20.16 5.9 5.9 6.21 3.52 4.59 Prefer not to say C C 1 C B B B
88 B D D E 7 2 1 2 2 2 2 4 C 14.5 14.5 34.87 34.87 2.83 2.83 6.16 3.27 6.03 Male C F 4 E B D B
90 A B C D 6 3 3 6 1 4 1 4 C 9.18 9.18 36.87 36.87 3.52 3.52 8.94 4 5.57 Female B F 5 G B E A
94 B B D A 4 3 2 2 3 3 5 5 C 7.65 7.65 25.91 25.91 2.82 2.82 8.91 2.34 5.05 Male A F 1 H C C B
96 B C D A 5 6 1 6 1 1 1 3 C 11.79 11.79 28.98 28.98 4.84 4.84 9.15 1.5 3.49 Male D F 3 G B E A
98 B D C C 6 6 1 5 1 2 1 4 C 6.87 6.87 23.25 23.25 2.48 2.48 9.86 1.34 5.64 Female D C 2 I B D A
102 B A B A 6 6 1 1 1 6 1 5 C 5.73 5.73 35.37 35.37 3.2 3.2 4.23 2.17 5.98 Female B C 3 B D B B
105 A C A A 6 5 4 1 1 4 2 2 C 13.71 13.71 26.28 26.28 3.21 3.21 4.27 1.52 6.3 Female D C 7 B C B B
112 C B D A 6 1 1 1 5 5 4 6 C 13.25 13.25 35.57 35.57 6.51 6.51 5.67 1.62 5.06 Female C C 3 F D C C
113 A B A D 7 5 1 6 1 1 5 6 C 12.17 12.17 28.61 28.61 2.64 2.64 6.15 4.46 3.86 Male E D 3 D A G B
116 B E A C 5 2 1 5 3 6 4 2 C 9.02 9.02 39.23 39.23 1.61 1.61 5.08 2.68 6.15 Female D A 5 H F F A
119 B D A D 6 1 1 5 1 1 2 4 C 5.18 5.18 44.74 44.74 2.85 2.85 5.79 3.26 5.29 Prefer not to say D A 4 B A B B
122 A C D D 7 6 1 6 3 1 3 2 C 12.18 12.18 38.98 38.98 3.12 3.12 9.1 3.94 6.59 Female C C 3 D B C A
124 B C B D 6 4 4 5 5 1 1 5 C 14.79 14.79 37.34 37.34 5.24 5.24 9.87 1.15 5.07 Female E A 2 F A G A
130 B B B C 7 6 3 6 1 6 1 6 C 5.84 5.84 36.43 36.43 3.98 3.98 4.02 1.7 5.61 Prefer not to say C B 7 H A B B
131 A D B C 5 5 1 2 4 4 1 1 C 12.99 12.99 32.28 32.28 4.66 4.66 4.22 4.11 6.12 Female D D 6 F E E A
145 A A E E 7 1 1 4 7 1 1 6 C 7.48 7.48 22.83 22.83 2.82 2.82 4.01 1.02 5.37 Female G F 4 B B C B
146 A C A B 4 6 4 2 3 6 1 5 C 10.47 10.47 25.23 25.23 4.04 4.04 5.33 3.04 5.02 Male C C 1 H A C A
164 B D D E 7 1 2 5 6 4 1 4 C 14.94 14.94 33.98 33.98 3.7 3.7 7.57 1.99 5.88 Prefer not to say C F 2 D F B B
171 A C B C 4 6 4 4 3 1 1 6 C 5.64 5.64 23.84 23.84 3.72 3.72 4.02 2.54 6.13 Female E D 2 G B B A
173 A C B D 6 6 1 2 1 5 2 5 C 14.82 14.82 43.12 43.12 7.1 7.1 6.4 1.38 5.07 Female E F 4 E E B B
175 A B B E 6 6 5 6 1 2 3 5 C 14.92 14.92 35.13 35.13 3.17 3.17 6.65 3.45 4.86 Prefer not to say E D 2 D A B A
188 B B B C 7 1 4 6 1 6 1 5 C 12.59 12.59 46.16 46.16 3.46 3.46 9.78 4.41 6.25 Prefer not to say D C 2 H B D A
193 B C E C 4 6 2 2 1 1 6 5 C 7.73 7.73 38.1 38.1 6.51 6.51 6.87 4.02 5.34 Male D C 1 F E F A
195 A C B D 6 6 2 4 2 6 2 5 C 5.01 5.01 25.89 25.89 5.48 5.48 4 2.06 6.58 Female C F 2 F B B A
196 A B D D 2 6 4 1 3 6 3 4 C 14.95 14.95 49.3 49.3 3.74 3.74 4.66 2.69 5.29 Female C A 4 E A D A
2 B C B C 7 3 1 5 2 1 1 5 D 13 13 19.52 19.52 1.32 1.32 6.75 2.63 4.1 Female D C 3 H A C B
6 A A B D 7 6 3 5 1 6 1 2 D 14.91 14.91 21.57 21.57 4.36 4.36 6.02 1.52 6.9 Female D B 1 F F F A
8 A C B C 4 2 4 5 1 4 5 1 D 14.76 14.76 19.93 19.93 4.16 4.16 5.37 3.44 3.34 Female D F 2 C F F C
11 B C B C 6 5 2 3 5 3 1 3 D 15 15 33.2 33.2 3.2 3.2 4.55 4.24 3.99 Female E C 1 D D G A
17 B D B D 5 2 4 1 1 1 1 4 D 14.84 14.84 24.58 24.58 2.77 2.77 4.71 1.01 1.22 Female G F 3 C A B A
25 B B E D 7 6 4 5 5 5 1 5 D 14.95 14.95 23.82 23.82 2.18 2.18 5.1 2.53 3.55 Male C F 2 D B E B
29 A C A E 4 3 1 5 5 2 1 3 D 14.99 14.99 44.02 44.02 4.67 4.67 4.68 1.43 4.69 Male E A 3 D C C A
30 D B D A 6 6 2 5 1 5 5 5 D 9.48 9.48 33.21 33.21 3.95 3.95 4.12 1.47 5.85 Male G C 4 D A C A
31 A A D E 7 2 2 2 1 1 1 4 D 14.56 14.56 23.65 23.65 4.96 4.96 4.68 2.18 3.84 Female G D 2 E B E B
32 A C D A 7 6 4 1 3 1 1 3 D 14.96 14.96 34.2 34.2 4.46 4.46 4.12 4.92 6.22 Female E E 3 I F G A
35 A E B A 4 6 2 4 1 1 5 4 D 6.54 6.54 24.4 24.4 2.49 2.49 7.69 3.13 4.25 Male D D 1 C E E A
39 A B C D 4 5 5 1 2 6 2 5 D 5.1 5.1 31.34 31.34 1.89 1.89 5.38 1.02 2.28 Prefer not to say E C 3 G B C A
40 B B B G 6 2 5 4 1 1 1 5 D 5.13 5.13 27.9 27.9 3.96 3.96 4.98 2 2.8 Prefer not to say B C 2 F B F C
43 D C D A 6 5 1 1 1 1 1 6 D 5.17 5.17 27.37 27.37 3.49 3.49 5.56 1.5 4.12 Female D E 3 H B A A
47 A B A F 6 3 4 4 6 1 2 4 D 14.63 14.63 23.92 23.92 3.32 3.32 4.07 4.21 2.87 Male B C 2 H B B B
50 A C A D 6 6 1 2 2 1 1 5 D 10.11 10.11 20.99 20.99 3.4 3.4 6.29 5 2.73 Male D A 3 C E B D
55 A B B C 7 1 2 3 1 1 1 4 D 12.49 12.49 22.38 22.38 2.69 2.69 4.73 1.32 5.12 Female D C 4 I A C B
56 D C A E 6 2 1 1 4 2 1 5 D 8.18 8.18 31.25 31.25 3.73 3.73 6.81 2.56 2.15 Prefer not to say C C 3 G E C A
58 A C B A 6 6 1 7 1 4 1 3 D 13.01 13.01 24.67 24.67 3.51 3.51 4.08 3.7 4.95 Female F D 4 G B E B
63 D C A C 1 6 7 7 1 1 1 2 D 11.82 11.82 21.12 21.12 5.04 5.04 5.26 3.54 5.64 Female C A 1 E B B A
66 A E B D 6 6 2 1 1 1 5 4 D 6.15 6.15 27.61 27.61 3.76 3.76 4.23 4.63 4.39 Male E A 1 E B B B
71 A C D G 7 6 4 3 1 1 1 4 D 5.46 5.46 34.13 34.13 4.01 4.01 5.04 1.27 3.78 Male B F 2 H B C B
73 A D B A 7 6 1 1 4 1 2 2 D 7.35 7.35 21.27 21.27 3.1 3.1 5.75 1.2 4.49 Female D A 5 H B C B
75 B C C C 7 2 5 3 5 2 2 4 D 13.95 13.95 34.13 34.13 6.66 6.66 7.9 2.4 5.06 Male A A 5 H B B A
76 B A D E 7 2 5 1 1 1 2 3 D 14.04 14.04 26.83 26.83 2.48 2.48 4.03 2.03 3.59 Male E C 2 I B C A
83 A A C F 4 6 2 3 5 6 4 4 D 12.74 12.74 43.27 43.27 4.53 4.53 6.87 1.51 6.29 Female C A 3 E B C A
86 B D C G 7 3 1 2 5 4 6 5 D 5.06 5.06 35.91 35.91 1.63 1.63 5.74 1.3 5.64 Male A E 1 F B B B
89 B B B C 7 6 5 3 1 6 1 4 D 5.26 5.26 42.7 42.7 5.11 5.11 6.36 2.05 3.76 Prefer not to say D C 1 C A F A
92 B C B B 7 3 1 1 2 5 2 1 D 7 7 34.84 34.84 4.31 4.31 5.57 4.61 4.88 Male D C 3 G A D B
95 B B A A 4 3 4 6 6 1 2 4 D 12.43 12.43 45.66 45.66 3.36 3.36 6.31 4.49 2.53 Female C F 1 D B B B
99 A C A G 6 5 2 6 1 5 6 5 D 5.37 5.37 26.11 26.11 3.93 3.93 4.02 2.59 3.47 Male D A 6 I B C B
100 B C B A 5 1 1 6 5 7 5 6 D 8.14 8.14 47.59 47.59 4.68 4.68 4.19 2.15 5.52 Prefer not to say C A 2 G B E B
110 A C D D 7 3 4 2 1 5 2 2 D 7.46 7.46 26 26 5.04 5.04 4.74 2.82 2.41 Male B A 4 F C B A
115 A C D E 3 1 1 2 1 4 6 3 D 5.21 5.21 34.67 34.67 2.47 2.47 4.39 3.85 4.15 Prefer not to say C C 2 D A B A
117 B D B D 6 4 5 6 2 5 4 5 D 11.11 11.11 44.4 44.4 3.65 3.65 7.77 4.93 2.59 Female E A 2 E A C A
120 A D B A 7 6 4 1 1 6 1 3 D 8.71 8.71 27.98 27.98 4.2 4.2 4.16 4.41 4.71 Male G C 3 H B A B
121 A E A D 4 6 2 3 3 6 3 5 D 11.36 11.36 37.16 37.16 2.74 2.74 6.02 2.67 2.99 Male D C 2 C D E A
125 B A D E 4 5 2 3 1 1 1 3 D 13.71 13.71 21.97 21.97 3.6 3.6 4.14 3.97 3.58 Female D C 1 D F E A
128 B B A A 7 6 1 2 5 1 1 4 D 8.91 8.91 27.41 27.41 5.39 5.39 7.92 4.82 5.84 Male B C 1 F B B A
133 B E D B 6 1 1 1 1 4 2 6 D 7.41 7.41 25.04 25.04 2.96 2.96 5.96 5 4.99 Prefer not to say D C 2 B B C B
139 A B B C 7 6 1 5 1 4 2 1 D 5.19 5.19 31.66 31.66 5.76 5.76 4.58 1.53 2.05 Male B C 4 H F C A
142 A C D E 7 2 1 4 2 1 3 5 D 8.95 8.95 43.19 43.19 1.65 1.65 8.1 1.02 4.27 Female E F 2 D B B A
147 A C D A 5 6 1 5 1 1 3 5 D 9.85 9.85 23.47 23.47 3.11 3.11 4.03 1.18 4.2 Prefer not to say D C 2 F A C B
148 A C C E 6 6 2 2 6 4 1 5 D 9.39 9.39 31.92 31.92 2.05 2.05 5.46 2.78 4.6 Female B C 2 F B F B
151 A A B E 6 6 1 6 1 2 1 6 D 10.64 10.64 24.18 24.18 2.38 2.38 7.32 4.98 2.43 Prefer not to say B C 2 F E B A
153 B A B F 4 6 4 7 3 3 7 5 D 7.76 7.76 21.4 21.4 4.9 4.9 4.42 3.71 5.7 Female B A 3 D F B A
155 A D D E 6 1 1 6 2 6 1 2 D 7.53 7.53 25.76 25.76 1.31 1.31 4.08 1.37 2.71 Female C F 1 D E C C
157 B B B D 7 2 4 1 5 4 1 4 D 5.01 5.01 30.62 30.62 6.63 6.63 4.15 3.23 2.32 Male B C 2 E B E B
158 A C A E 6 3 1 1 1 4 1 4 D 5.24 5.24 27.33 27.33 4.41 4.41 4.22 1.67 5.33 Female B C 1 H A B B
159 A C D A 3 6 5 6 1 4 1 3 D 13.55 13.55 48.7 48.7 3.63 3.63 4.46 4.99 4.68 Prefer not to say G C 2 D F F C
160 A C E A 6 5 3 5 1 4 1 4 D 12.41 12.41 41.1 41.1 4.02 4.02 6.84 3.92 5.73 Male D F 5 D A A A
163 A C A E 6 3 2 2 1 4 1 2 D 5.02 5.02 24.79 24.79 3.81 3.81 5.4 4.99 3.45 Female E C 2 E B D A
169 A C A C 6 6 2 4 2 4 5 2 D 8.38 8.38 35.03 35.03 6.62 6.62 5.39 1.1 4.49 Female F D 1 C B D C
179 B C B A 7 2 2 5 1 2 1 1 D 9.89 9.89 22.95 22.95 1.72 1.72 5.19 3.56 4.56 Female E D 2 H B E B
185 A A B D 6 2 1 5 1 1 1 4 D 11.63 11.63 36.83 36.83 3.64 3.64 5.22 4.96 4.89 Female A C 2 G F B B
189 B B B C 6 5 1 2 2 2 1 4 D 14.45 14.45 27.45 27.45 2.76 2.76 4.05 5 2.47 Male E A 2 A B D C
198 A B A A 7 6 2 4 1 1 3 4 D 11.83 11.83 40.39 40.39 2.27 2.27 5.41 1.45 3.49 Prefer not to say C C 5 C A B C
17.42