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"

p value: < 0.001 (1.359e-5)  1

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.

C:\Users\Satelite L75\sofastats\reports\default_report_images\000.png
 
C:\Users\Satelite L75\sofastats\reports\default_report_images\001.png
 

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.

C:\Users\Satelite L75\sofastats\reports\default_report_images\002.png
 
C:\Users\Satelite L75\sofastats\reports\default_report_images\003.png
 

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.