Repeat step 1 above for the variable wagefor the private sector employees.

First use Excel Data Analysis Tool Pack (the descriptive statistics option) to calculate summary statistics.

Second use Excel to stepwise calculate summary statistics. Here you would estimate a whole range of statistics to measure central tendency, variation, and the shape of the data - based on what you learned under Topic 1.

These calculations should be carefully laid out in Excel and should NOT use any hard-wired Excel statistical functions e.g. Average, Median, Mode, STDEV, VAR, QUARTILE, etc.

gender	age	wage	degree	married
Male	36	3.009027	Yes	Yes
Male	61	6.521739	No	No
Female	25	9.2	No	No
Female	22	10	No	No
Male	23	10.56	No	No
Female	27	13.5	Yes	No
Female	27	14.58333	No	Yes
Male	21	16.26667	No	No
Male	21	16.42857	No	No
Female	31	17.5	No	No
Male	27	18	No	No
Female	41	18.2	Yes	Yes
Female	26	18.34211	No	Yes
Female	31	19.18	No	No
Female	23	19.18182	No	No
Female	28	19.67442	No	Yes
Female	63	19.90625	No	No
Male	24	19.98333	No	No
Male	52	20	No	No
Female	27	20.18421	Yes	No
Female	27	20.83333	No	Yes
Female	49	21	No	Yes
Male	47	21.4	No	No
Female	43	21.4186	Yes	No
Female	31	21.48889	Yes	No
Female	27	21.5	Yes	Yes
Male	27	21.81818	No	No
Female	60	21.90476	No	No
Male	52	22	No	No
Male	22	22.275	No	No
Male	22	22.5	No	No
Male	60	22.63158	No	No
Female	41	22.64151	No	Yes
Male	39	23.08	No	No
Female	39	24.56	No	Yes
Female	48	24.57143	No	Yes
Male	30	24.95	No	Yes
Male	22	25	No	No
Male	26	25.56667	Yes	No
Male	22	25.66667	No	No
Male	32	26	No	No
Female	46	26.24	No	Yes
Female	47	26.31579	No	No
Male	31	26.90476	No	Yes
Male	60	27.16667	No	Yes
Female	53	27.16667	No	Yes
Female	25	27.34043	Yes	No
Female	35	27.625	No	No
Male	63	28	No	Yes
Male	28	28	Yes	No
Female	42	28.33333	Yes	No
Male	44	28.33333	No	No
Female	28	28.62	Yes	No
Male	24	28.775	No	No
Male	27	28.85	No	No
Female	26	28.92105	Yes	No
Female	59	29.08333	No	Yes
Male	23	29.30909	No	No
Male	40	29.69767	Yes	Yes
Male	22	31	Yes	No
Female	50	31.11111	No	Yes
Female	65	31.125	Yes	No
Male	28	31.2093	Yes	No
Male	30	31.42857	Yes	No
Female	37	31.66667	No	Yes
Male	32	32.34375	No	No
Female	25	32.42105	No	No
Male	32	32.5	No	Yes
Female	51	33.18605	No	Yes
Male	35	33.33333	No	Yes
Male	27	33.4	Yes	Yes
Male	38	34.375	No	No
Female	64	34.87273	No	No
Male	26	34.92	Yes	No
Female	34	37.09302	No	Yes
Male	27	37.44737	No	Yes
Male	37	37.5	No	No
Female	33	37.6	Yes	Yes
Male	23	38.15789	No	No
Female	30	38.35	No	No
Male	37	38.35	No	No
Female	41	38.46154	No	Yes
Female	27	38.8	No	No
Male	26	38.85185	No	No
Male	35	39	Yes	Yes
Female	29	39.5	No	No
Female	55	39.85	Yes	No
Male	42	39.95	No	Yes
Female	22	40	No	No
Male	30	40.04546	No	No
Female	61	41.66667	Yes	No
Female	41	41.83636	Yes	No
Male	29	42.44186	No	No
Female	59	42.51351	No	Yes
Male	37	43.02222	No	No
Male	29	43.15	No	No
Male	46	43.16	Yes	No
Female	32	43.34286	Yes	No
Male	50	43.85965	No	Yes
Male	30	44.6	No	Yes
Male	33	44.75555	No	No
Female	33	44.86666	Yes	No
Male	40	46.02	No	No
Male	44	46.02	Yes	Yes
Male	26	46.42105	Yes	No
Female	58	47.95	Yes	Yes
Female	31	48.075	No	No
Female	36	48.2	Yes	No
Female	46	48.9	Yes	No
Male	32	49.02222	Yes	No
Male	55	50.92857	Yes	No
Male	46	52.94	Yes	No
Male	37	56.25	Yes	No
Female	43	56.4	No	Yes
Male	64	57.525	No	Yes
Male	36	61.38	Yes	Yes
Male	36	61.5	No	No
Male	49	61.72093	No	Yes
Male	31	68.94736	Yes	Yes
Female	60	70	No	Yes
Male	42	70.21277	Yes	No
Male	35	70.83334	Yes	No
Male	31	73.1	No	Yes
Male	38	73.64	Yes	Yes
Male	38	78.26	Yes	No
Female	43	79.68571	No	Yes
Male	38	79.88889	Yes	No
Male	63	80	Yes	No
Male	56	87.5	No	Yes
Male	64	91.17647	No	Yes
Male	31	100	No	No
Male	53	100	Yes	Yes
Male	44	100.5814	No	No