Order 1082549: Read Instructions

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.

  

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%