1. Perform the following tasks.

(a) Use range B4:E7 of the NationalSolutions worksheet. For all 4 Subject components, compute the mean, standard deviation, skewness, and kurtosis.

(b)Use range B12:C14 of the NationalSolutions worksheet. Compute the mean Social Sciences component score separately for

students born in area code 26

students born in area code 27

Next, compute the mean Mathematics component score separately for

students with access to a computer at home

students without access to a computer at home

Next, compute the percentage difference in mean scores. Finally, interpret the percentage difference in mean scores.

(C) Are there any issues associated with the difference measure under (b)? Can we draw conclusions from this measure? Why (not)?

SHOW ALL WORKING OUT!!

This is one whole question each part relates to question 1.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	StudentID	ResidenceCode	Age	Gender	BirthplaceCode	FamilyNbrMembers	FamilyNbrCars	FamilyComputer	FamilyInternet	FamilyIncome	ScoreNatS	ScoreSocS	ScoreLang	ScoreMath
2	150003972579	29	31	F	29	4	1	Yes	Yes	Between 1000 and 2000	450	563	447	384
3	150005629246	28	53	F	27	3	1	Yes	Yes	Above 2000	397	574	509	399
4	150004422234	26	27	F	26	2	0	Yes	Yes	Below 1000	533	517	458	376
5	150001916174	26	35	F	26	5	0	Yes	No	Below 1000	453	520	365	360
6	150004630087	28	22	M	28	4	0	Yes	Yes	Below 1000	401	421	391	378
7	150003317793	29	18	F	29	4	0	Yes	Yes	Between 1000 and 2000	444	555	513	463
8	150000504540	29	19	F	29	4	0	Yes	Yes	Between 1000 and 2000	499	518	475	484
9	150007694442	29	42	F	29	3	0	No	No	Below 1000	467	483	459	459
10	150004182238	29	19	F	29	3	0	Yes	No	Below 1000	548	609	493	405
11	150006606021	26	30	F	26	4	0	Yes	Yes	Below 1000	420	512	448	538
12	150001530498	29	16	F	29	4	0	No	No	Below 1000	417	567	526	446
13	150006420641	26	18	F	26	3	0	No	No	Between 1000 and 2000	433	395	414	439
14	150001977477	29	24	M	29	3	0	Yes	No	Below 1000	383	564	471	440
15	150003109917	26	17	M	26	5	3	Yes	Yes	Above 2000	610	607	627	732
16	150002570107	26	19	F	26	5	0	Yes	No	Below 1000	360	559	455	434
17	150007547156	26	20	F	26	2	0	No	No	Below 1000	476	532	517	493
18	150004576455	29	19	M	29	2	0	Yes	No	Below 1000	401	538	513	452