Order 1082549: Read Instructions
tutorthammy
Milestone111.docx
From sofa_db.demo_tbl on 03/06/2018 at 03:33 PM
All data in table included - no filtering
|
|
|
|
|||
|
|
Freq |
Col % |
|
|
Age Group |
< 20 |
309 |
20.6% |
|
|
20-29 |
189 |
12.6% |
|
|
30-39 |
176 |
11.7% |
|
|
40-64 |
390 |
26.0% |
|
|
65+ |
436 |
29.1% |
|
Gender |
Male |
769 |
51.3% |
|
|
Female |
731 |
48.7% |
From sofa_db.demo_tbl on 03/06/2018 at 03:33 PM
All data in table included - no filtering
|
|
|
|
|||
|
|
Freq |
Col % |
|
|
Age Group |
< 20 |
309 |
20.6% |
|
|
20-29 |
189 |
12.6% |
|
|
30-39 |
176 |
11.7% |
|
|
40-64 |
390 |
26.0% |
|
|
65+ |
436 |
29.1% |
|
Gender |
Male |
769 |
51.3% |
|
|
Female |
731 |
48.7% |
From sofa_db.demo_tbl on 03/06/2018 at 03:33 PM
All data in table included - no filtering
|
|
|
|
|||
|
|
Freq |
Col % |
|
|
Age Group |
< 20 |
309 |
20.6% |
|
|
20-29 |
189 |
12.6% |
|
|
30-39 |
176 |
11.7% |
|
|
40-64 |
390 |
26.0% |
|
|
65+ |
436 |
29.1% |
|
Gender |
Male |
769 |
51.3% |
|
|
Female |
731 |
48.7% |
From sofa_db.demo_tbl on 03/06/2018 at 03:41 PM
All data in table included - no filtering
|
|
|
|
|||||||||
|
|
Country |
||||||||
|
|
Japan |
Italy |
Germany |
TOTAL |
|||||
|
|
Freq |
Col % |
Freq |
Col % |
Freq |
Col % |
Freq |
Col % |
|
|
Age Group |
< 20 |
63 |
13.5% |
141 |
27.8% |
105 |
19.9% |
309 |
20.6% |
|
|
20-29 |
66 |
14.2% |
54 |
10.7% |
69 |
13.1% |
189 |
12.6% |
|
|
30-39 |
63 |
13.5% |
53 |
10.5% |
60 |
11.4% |
176 |
11.7% |
|
|
40-64 |
116 |
24.9% |
135 |
26.6% |
139 |
26.4% |
390 |
26.0% |
|
|
65+ |
158 |
33.9% |
124 |
24.5% |
154 |
29.2% |
436 |
29.1% |
From sofa_db.demo_tbl on 03/06/2018 at 03:44 PM
All data in table included - no filtering
Results of Pearson's Chi Square Test of Association Between "Age Group" and "Country"
Pearson's Chi Square statistic: 36.606
Degrees of Freedom (df): 8
|
|
Country |
||||||||
|
|
Japan |
Italy |
Germany |
TOTAL |
|||||
|
|
Obs |
Exp |
Obs |
Exp |
Obs |
Exp |
Obs |
Exp |
|
|
Age Group |
< 20 |
63 |
96.0 |
141 |
104.4 |
105 |
108.6 |
309 |
309.0 |
|
|
20-29 |
66 |
58.7 |
54 |
63.9 |
69 |
66.4 |
189 |
189.0 |
|
|
30-39 |
63 |
54.7 |
53 |
59.5 |
60 |
61.8 |
176 |
176.0 |
|
|
40-64 |
116 |
121.2 |
135 |
131.8 |
139 |
137.0 |
390 |
390.0 |
|
|
65+ |
158 |
135.5 |
124 |
147.4 |
154 |
153.2 |
436 |
436.0 |
|
|
TOTAL |
466 |
466.0 |
507 |
507.0 |
527 |
527.0 |
1500 |
1500.0 |
Minimum expected cell count: 54.677
% cells with expected count < 5: 0.0
1 If p is small, e.g. less than 0.01, or 0.001, you can assume the result is statistically significant i.e. there is a relationship. Note: a statistically significant difference may not necessarily be of any practical significance.
Interpreting the Proportions chart - look at the "All combined" category - the more different the other Age Group categories look from this the more likely the Chi Square test will detect a difference. Within each Age Group category the Country values add up to 1 i.e. 100%. This is not the same way of displaying data as a clustered bar chart although the similarity can be confusing.
From sofa_db.Copy_of_sawcompgrp on 03/06/2018 at 04:18 PM
All data in table included - no filtering
|
|
|
|
|||
|
|
Freq |
Col % |
|
|
Age |
21.0 |
20 |
20.0% |
|
|
22.0 |
18 |
18.0% |
|
|
23.0 |
18 |
18.0% |
|
|
24.0 |
14 |
14.0% |
|
|
25.0 |
14 |
14.0% |
|
|
26.0 |
6 |
6.0% |
|
|
27.0 |
2 |
2.0% |
|
|
28.0 |
2 |
2.0% |
|
|
29.0 |
2 |
2.0% |
|
|
30.0 |
4 |
4.0% |
From sofa_db.Copy_of_sawcompgrp on 03/06/2018 at 04:19 PM
All data in table included - no filtering
|
|
|
|
|||
|
|
Freq |
Col % |
|
|
Age |
21.0 |
20 |
20.0% |
|
|
22.0 |
18 |
18.0% |
|
|
23.0 |
18 |
18.0% |
|
|
24.0 |
14 |
14.0% |
|
|
25.0 |
14 |
14.0% |
|
|
26.0 |
6 |
6.0% |
|
|
27.0 |
2 |
2.0% |
|
|
28.0 |
2 |
2.0% |
|
|
29.0 |
2 |
2.0% |
|
|
30.0 |
4 |
4.0% |
From sofa_db.Copy_of_sawcompgrp on 03/06/2018 at 04:19 PM
All data in table included - no filtering
|
|
|
|
|||
|
|
Freq |
Col % |
|
|
Age |
21.0 |
20 |
20.0% |
|
|
22.0 |
18 |
18.0% |
|
|
23.0 |
18 |
18.0% |
|
|
24.0 |
14 |
14.0% |
|
|
25.0 |
14 |
14.0% |
|
|
26.0 |
6 |
6.0% |
|
|
27.0 |
2 |
2.0% |
|
|
28.0 |
2 |
2.0% |
|
|
29.0 |
2 |
2.0% |
|
|
30.0 |
4 |
4.0% |
From sofa_db.Copy_of_sawcompgrp on 03/06/2018 at 04:24 PM
All data in table included - no filtering
|
|
|
|
|||||||
|
|
Racethn |
||||||
|
|
1.0 |
2.0 |
3.0 |
||||
|
|
Freq |
Col % |
Freq |
Col % |
Freq |
Col % |
|
|
Age |
21.0 |
6 |
30.0% |
10 |
21.7% |
4 |
11.8% |
|
|
22.0 |
2 |
10.0% |
8 |
17.4% |
8 |
23.5% |
|
|
23.0 |
4 |
20.0% |
6 |
13.0% |
8 |
23.5% |
|
|
24.0 |
0 |
0.0% |
10 |
21.7% |
4 |
11.8% |
|
|
25.0 |
2 |
10.0% |
4 |
8.7% |
8 |
23.5% |
|
|
26.0 |
2 |
10.0% |
4 |
8.7% |
0 |
0.0% |
|
|
27.0 |
0 |
0.0% |
2 |
4.3% |
0 |
0.0% |
|
|
28.0 |
2 |
10.0% |
0 |
0.0% |
0 |
0.0% |
|
|
29.0 |
0 |
0.0% |
2 |
4.3% |
0 |
0.0% |
|
|
30.0 |
2 |
10.0% |
0 |
0.0% |
2 |
5.9% |
From sofa_db.Copy_of_sawcompgrp on 03/06/2018 at 04:30 PM
All data in table included - no filtering
Results of Pearson's Chi Square Test of Association Between "Age" and "Racethn"
p value: 0.01772 1
Pearson's Chi Square statistic: 32.785
Degrees of Freedom (df): 18
|
|
Racethn |
||||||||
|
|
1.0 |
2.0 |
3.0 |
TOTAL |
|||||
|
|
Obs |
Exp |
Obs |
Exp |
Obs |
Exp |
Obs |
Exp |
|
|
Age |
21.0 |
6 |
4.0 |
10 |
9.2 |
4 |
6.8 |
20 |
20.0 |
|
|
22.0 |
2 |
3.6 |
8 |
8.3 |
8 |
6.1 |
18 |
18.0 |
|
|
23.0 |
4 |
3.6 |
6 |
8.3 |
8 |
6.1 |
18 |
18.0 |
|
|
24.0 |
0 |
2.8 |
10 |
6.4 |
4 |
4.8 |
14 |
14.0 |
|
|
25.0 |
2 |
2.8 |
4 |
6.4 |
8 |
4.8 |
14 |
14.0 |
|
|
26.0 |
2 |
1.2 |
4 |
2.8 |
0 |
2.0 |
6 |
6.0 |
|
|
27.0 |
0 |
0.4 |
2 |
0.9 |
0 |
0.7 |
2 |
2.0 |
|
|
28.0 |
2 |
0.4 |
0 |
0.9 |
0 |
0.7 |
2 |
2.0 |
|
|
29.0 |
0 |
0.4 |
2 |
0.9 |
0 |
0.7 |
2 |
2.0 |
|
|
30.0 |
2 |
0.8 |
0 |
1.8 |
2 |
1.4 |
4 |
4.0 |
|
|
TOTAL |
20 |
20.0 |
46 |
46.0 |
34 |
34.0 |
100 |
100.0 |
Minimum expected cell count: 0.4
% cells with expected count < 5: 73.3
1 If p is small, e.g. less than 0.01, or 0.001, you can assume the result is statistically significant i.e. there is a relationship. Note: a statistically significant difference may not necessarily be of any practical significance.
Interpreting the Proportions chart - look at the "All combined" category - the more different the other Age categories look from this the more likely the Chi Square test will detect a difference. Within each Age category the Racethn values add up to 1 i.e. 100%. This is not the same way of displaying data as a clustered bar chart although the similarity can be confusing.
From sofa_db.Copy_of_sawcompgrp on 03/06/2018 at 04:38 PM
All data in table included - no filtering
Results of Pearson's Chi Square Test of Association Between "Uscreen" and "Group"
p value: < 0.001 (1.984e-8) 1
Pearson's Chi Square statistic: 41.538
Degrees of Freedom (df): 4
|
|
Group |
||||||
|
|
1.0 |
2.0 |
TOTAL |
||||
|
|
Obs |
Exp |
Obs |
Exp |
Obs |
Exp |
|
|
Uscreen |
0.0 |
20 |
12.5 |
5 |
12.5 |
25 |
25.0 |
|
|
1.0 |
24 |
16.0 |
8 |
16.0 |
32 |
32.0 |
|
|
2.0 |
6 |
13.0 |
20 |
13.0 |
26 |
26.0 |
|
|
3.0 |
0 |
7.0 |
14 |
7.0 |
14 |
14.0 |
|
|
4.0 |
0 |
1.5 |
3 |
1.5 |
3 |
3.0 |
|
|
TOTAL |
50 |
50.0 |
50 |
50.0 |
100 |
100.0 |
Minimum expected cell count: 1.5
% cells with expected count < 5: 20.0
1 If p is small, e.g. less than 0.01, or 0.001, you can assume the result is statistically significant i.e. there is a relationship. Note: a statistically significant difference may not necessarily be of any practical significance.
