Microsoft Excel Output

2

Microsoft Excel graphics

Descriptive statistics can be useful for two purposes: 1) to provide basic information about variables in a dataset and to highlight potential relationships between variables. The basic statistics in tis assignment are correlaton,kurtosis skewness, mean , median and mode.

ID	STUDENT ID	AGE	SEX	HEIGHT	YEAR
1	P101	24	male	61	freshman
2	P102	20	female	59	freshman
3	P103	19	female	58	freshman
4	P104	19	male	64	freshman
5	P105	22	male	62	freshman
6	P106	20	female	61	freshman
7	P107	23	female	60	freshman
8	P108	22	male	60	freshman
9	P109	19	female	58	freshman
10	P110	22	male	62	freshman
11	P201	21	female	63	junior
12	P202	19	female	59	junior
13	P203	19	female	50	junior
14	P204	21	female	55	junior
15	P205	19	female	65	junior
16	P206	22	male	57	junior
17	P207	24	male	57	junior
18	P208	20	male	59	junior
19	P209	19	male	57	junior
20	P210	20	male	62	junior
21	P301	22	female	62	sophomore
22	P302	21	female	61	sophomore
23	P303	20	female	60	sophomore
24	P304	19	female	55	sophomore
25	P305	22	male	57	sophomore
26	P306	24	male	58	sophomore
27	P307	21	male	64	sophomore
28	P308	20	female	64	sophomore
29	P309	22	male	61	sophomore
30	P310	23	male	59	sophomore
31	P401	22	female	63	senior
32	P402	24	male	62	senior
33	P403	24	male	61	senior
34	P404	25	male	60	senior
35	P405	22	female	69	senior
36	P406	22	female	61	senior
37	P407	24	female	59	senior
38	P408	27	male	64	senior
39	P409	23	female	65	senior
40	P410	25	male	62	senior
mean		21.65		60.4
mode		22		61
median		22		61
correlation	0.224942		0.224942
skewness	0.424747		-0.40944
kurtosis		-0.40166		1.750176

There is a positive correlation between age and height. The skewness of age is positive while that of height is negative. The kurtosis of age is negative while that of height is positive.

References

Andrews, I., Gentzkow, M., & Shapiro, J. M. (2020). On the informativeness of descriptive statistics for structural estimates. Econometrica, 88(6), 2231-2258.

STUDENT ID P101 P102 P103 P104 P105 P106 P107 P108 P109 P110 P201 P202 P203 P204 P205 P206 P207 P208 P209 P210 P301 P302 P303 P304 P305 P306 P307 P308 P309 P310 P401 P402 P403 P404 P405 P406 P407 P408 P409 P410 mean mode median correlation skewness kurtosis AGE 24 20 19 19 22 20 23 22 19 22 21 19 19 21 19 22 24 20 19 20 22 21 20 19 22 24 21 20 22 23 22 24 24 25 22 22 24 27 23 25 mean mode median correlation skewness kurtosis 21.65 22 22 0.22494184122100927 0.42474717700901932 -0.40166474030289123 SEX male female female male male female female male female male female female female female female male male male male male female female female female male male male female male male female male male male female female female male female male mean mode median correlation skewness kurtosis HEIGHT 61 59 58 64 62 61 60 60 58 62 63 59 50 55 65 57 57 59 57 62 62 61 60 55 57 58 64 64 61 59 63 62 61 60 69 61 59 64 65 62 mean mode median correlation skewness kurtosis 60.4 61 61 0.22494184122100927 -0.40944407380873177 1.7501763691599757 YEAR freshman freshman freshman freshman freshman freshman freshman freshman freshman freshman junior junior junior junior junior junior junior junior junior junior sophomore sophomore sophomore sophomore sophomore sophomore sophomore sophomore sophomore sophomore senior senior senior senior senior senior senior senior senior senior mean mode median correlation skewness kurtosis