Question

Read the statistical data and discuss your thoughts on the comparison.

Employment By Gender	Early Childhood Educators and Assistants (Unit 4214)	All Occupations
Males	3.5%	51.9%
Females	96.5%	43.1%

Employment By Age	Early Childhood Educators and Assistants (Unit 4214)	All Occupations
15-24 years	8.5%	13.3%
25-44 years	57.3%	42.7%
45-64 years	33.1%	41.1%
65 years and over	1.1%	2.8%

Employment By Status	Early Childhood Educators and Assistants (Unit 4214)	All Occupations
Full-Time	81.9%	81.2%
Part-Time	18.1%	18.6%

Employment By Annual Income	Early Childhood Educators and Assistants (Unit 4214)	All Occupations
Annual Average Income	$25,800	$50,300
$0 - $19,000	35.8%	13.3%
$20,000 - $49,000	60.4%	48.0%
$50,000 and over	3.7%	38.8%

Employment By Highest Level of Education	Early Childhood Educators and Assistants (Unit 4214)	All Occupations
Less than High-School	9.0%	12.1%
High-School	17.2%	20.3%
Post-Secondary	60.1%	44.2%
Bachelors	13.7%	23.4%

Other Employment Distribution	Early Childhood Educators and Assistants (Unit 4214)	All Occupations
Self-Employment	22.5%	10.7%
Immigrants	18.9%	13.7%

Labour Market Indicators	Early Childhood Educators and Assistants (Unit 4214)	All Occupations
Average Employment, 2010-2012	81.750	3,951,050
Employment Insurance Claimants in 2012	600	87,600
Average Annual Growth Rate, 2013-2017	1.5%	0.8%
Yearly Variation in Employment, 2013-2017	1,300	33,400
Annual Attrition, 2013-2017	1,000	73,500
Total Annual Needs, 2013-2017	2,300	106,900

Answer 1

Comparisons can be done using various functions present in excel.

1. data analysis option can be used in excel.

2. use various graphs present in insert tab

image-1.

Row1		Row2
Mean	0.277	Mean	0.698
Standard Error	0.242	Standard Error	0.267
Median	0.277	Median	0.698
Mode	#N/A	Mode	#N/A
Standard Deviation	0.34224	Standard Deviation	0.377595
Sample Variance	0.117128	Sample Variance	0.142578
Kurtosis	#DIV/0!	Kurtosis	#DIV/0!
Skewness	#DIV/0!	Skewness	#DIV/0!
Range	0.484	Range	0.534
Minimum	0.035	Minimum	0.431
Maximum	0.519	Maximum	0.965
Sum	0.554	Sum	1.396
Count	2	Count	2

IMAGE-2

IMAGE-3

Row1		Row2
Confidence Level(95.0%)	0.044471717	Confidence Level(95.0%)	0.031766

Row1		Row2
Mean	0.8155	Mean	0.1835
Standard Error	0.0035	Standard Error	0.0025
Median	0.8155	Median	0.1835
Mode	#N/A	Mode	#N/A
Standard Deviation	0.004949747	Standard Deviation	0.003535534
Sample Variance	2.45E-05	Sample Variance	0.0000125
Kurtosis	#DIV/0!	Kurtosis	#DIV/0!
Skewness	#DIV/0!	Skewness	#DIV/0!
Range	0.007	Range	0.005
Minimum	0.812	Minimum	0.181
Maximum	0.819	Maximum	0.186
Sum	1.631	Sum	0.367
Count	2	Count	2
Confidence Level(95.0%)	0.044471717	Confidence Level(95.0%)	0.031765512

IMAGE-4