Question

Human Development Data Set: Questions are posted in next post.

C1-T	INTERNET	GDP	CO2	CELLULAR	FERTILITY	LITERACY
Algeria	0.65	6.09	3	0.3	2.8	58.3
Argentina	10.08	11.32	3.8	19.3	2.4	96.9
Australia	37.14	25.37	18.2	57.4	1.7	100
Austria	38.7	26.73	7.6	81.7	1.3	100
Belgium	31.04	25.52	10.2	74.7	1.7	100
Brazil	4.66	7.36	1.8	16.7	2.2	87.2
Canada	46.66	27.13	14.4	36.2	1.5	100
Chile	20.14	9.19	4.2	34.2	2.4	95.7
China	2.57	4.02	2.3	11	1.8	78.7
Denmark	42.95	29	10.4	74	1.8	100
Egypt	0.93	3.52	2	4.3	3.3	44.8
Finland	43.03	25.64	11.3	80.4	1.7	100
France	26.38	23.99	6.1	60.5	1.9	100
Germany	37.36	25.35	9.7	68.2	1.4	100
Greece	13.21	17.44	8.2	75.1	1.3	96.1
India	0.68	2.84	1.1	0.6	3	46.4
Iran	1.56	6	4.8	3.2	2.3	70.2
Ireland	23.31	32.41	12.3	77.4	1.9	100
Israel	27.66	19.79	10	90.7	2.7	93.1
Japan	38.42	25.13	9.1	58.8	1.3	100
Malaysia	27.31	8.95	5.6	31.4	2.9	84
Mexico	3.62	8.43	1.4	21.7	2.5	89.5
Netherlands	49.05	27.19	8.5	76.7	1.7	100
New Zealand	46.12	23.45	8.1	59.9	2	100
Nigeria	0.1	0.85	0.3	0.3	5.4	57.7
Norway	46.38	29.62	8.7	81.5	1.8	100
Pakistan	0.34	1.89	0.7	0.6	5.1	28.8
Philippines	2.56	3.84	0.5	15	3.2	95
Russia	2.93	7.1	10.6	5.3	1.1	99.4
Saudi Arabia	1.34	13.33	11.7	11.3	4.5	68.2
South Africa	6.49	11.29	7.9	24.2	2.6	85
Spain	18.27	20.15	6.8	73.4	1.2	96.9
Sweden	51.63	24.18	5.3	79	1.6	100
Switzerland	30.7	28.1	5.7	72.8	1.4	100
Turkey	6.04	5.89	4.3	29.5	2.4	77.2
United Kingdom	32.96	24.16	9.2	77	1.6	100
United States	50.15	42.45	19.7	45.1	2.1	100
Vietnam	1.24	2.07	0.6	1.5	2.3	90.9
Yemen	0.09	0.79	1.1	0.8	7	26.9

You are provided with data for several nations from the Human Development Report, 2017.

1. Compute summary statistics (mean, median, mode, standard deviation etc.) for the variables of GDP (GDP per capita in thousands of dollars) and Internet use.

Provide descriptions of the distributions based on the summary statistics. Address skewness in your description.

2. Generate a scatterplot with clearly labeled axes CO2 and GDP. CO2 will be on the Y axis. Comment on what you see.
3. Compute the correlation between CO2 and GDP and interpret it. Refer to both the strength and direction of the correlation in your interpretation.
4. Using the variable Internet Use, construct the 1^st, 2^nd, and 3^rd standard deviation from the mean intervals and calculate the percentages for each. Then make a short interpretation on whether they match the percentages in the Empirical Rule.

Answer 1

Problem a: -

problem a:- calculation path: Data->Data Analysis-->Descriptive Statistics-> Select the input range Summary Statistics for Internet Summary Statistics for GDP 16.34794872 Mean 1.779162382 Standard Error 17.44 Median #N/A 11.11086552 Standard Deviation Mean 21.13974 Standard Error 2.957104 20.14 Median Mode Mode Standard Deviation Sample Variance Kurtosis #N/A 18.46711 341.0341 123.4513325 Sample Variance 1.105301865 Kurtosis -1.55535 0.180126281 Skewness 41.66 Range 0.79 Minimum 42.45 Maximum 637.57 Sum Skewness 0.235083 Range Minimum Maximum 51.54 0,09 51.63 Sum 824.45 39 Count Count 39 Note: Here Skewness is positive so the data are positively skewed or skewed right, meaning that the right tail of the distribution is longer than the left.

Problem b: -

problem b: - Scatter Plot 75 8 D.6526 10 C 21 10 15 70 35 45 GDP Here we can clearly observe that Both the variables have positive relation.

Problem c: -

problem c: - Correlation 0.80782985 #used CORREL function the correlation value is very nearer to one, so we can conclude there would be positive correlation between them.

Problem d: -

problem d: - mean of internet 21.1397 Sd of internet 18.4671 1st Standarad deviation Plmean-sd X = mean+sd P2.6726X< =39.606 2nd Standarad deviation Plmean-2sdk X< = mean+ 2 P-15.7945X - 58.07 3rd Standarad deviation Plmean-3sd< = X< = mean+3 PI-34.2616 -X< 76.54 0.683 0.955 0.997 2.6726 mean-sd 39.6069 mean+sd -15.7945 mean-2sd 58.0740 mean+2sd -34.2616 mean-3sd mean+3sd 76.5411 not perfectly sure about the answer for problem d.