Question

Country	%GDP	LE	IMR	Country	%GDP	LE	IMR
Australia	9.8	82	3.8	Japan	9.6	82.7	2.3
Austria	10.8	81.1	3.6	Korea	7.4	81.1	3
Belgium	10.5	80.5	3.3	Luxembourg	8.2	81.1	4.3
Canada	11.2	81	4.9	Mexico	6.2	74.2	13.6
Chile	7.5	78.3	7.4	Netherlands	11.9	81.3	3.6
Czech Republic	7.5	78	2.7	New Zeland	10.3	81.2	5.5
Denmark	11.1	79.9	3.6	Norway	9.3	81.4	2.4
Estonia	5.9	76.3	2.5	Poland	6.9	76.9	4.7
Finland	9	80.6	2.4	Portugal	10.2	80.8	3.1
France	11.6	82.2	3.5	Slovak Rep	7.9	76.1	4.9
Germany	11.3	80.8	3.6	Slovenia	8.9	80.1	2.9
Greece	9.1	80.8	3.4	Spain	9.3	82.4	3.2
Hungary	7.9	75	4.9	Sweden	9.5	81.9	2.1
Iceland	9	82.4	0.9	Switzerland	11	82.8	3.8
Ireland	8.9	80.6	3.5	Turkey	6.1	74.6	7.7
Israel	7.7	81.8	3.5	United Kingdom	9.4	81.1	4.3
Italy	9.2	82.7	3.4	United States	17.7	78.7	6.1

Recall that %GDP is an abbreviation for “healthcare expenditures as a percentage of gross domestic product,” LE for “life expectancy” (at birth), and IMR for “infant mortality rate”(number of deaths of babies under 1 year of age per 1000 live births. Now that you have studied regression and correlation, you can analyze the relationship between %GDP and LE, or the relationship between %GDP and IMR. I recommend that you use Microsoft Excel or another piece of technology to solve the following problems.

Choose either LE or IMR to analyze, and answer the following questions accordingly.

a. Considering % GDP as the predictor (independent) variable and LE or IMR as the response (dependent) variable, construct a scatterplot of the data.

b. Does the data point for the US appear to be an outlier? Explain your answer and discuss it in the context of %GDP and either LE or IMR.

c. Find the regression equation for the data. Plot the regression lines and the data points.

d. Remove the data point for the US, and find the regression equation for the new data. Plot the regression lines and the data points.

e. Is the data point for the US an influential observation? Explain your answer and discuss it in the context of %GDP and LE or IMR.

f. Obtain the coefficient of determination (R2), both with and without the data point for the US. Interpret your results.

g. Obtain correlation coefficient (r), both with and without the data point for the US. Interpret your results.

h. This week, we learned about linear regressions. Are there any applications from this week’s content to your major, your profession, or your interests? Please explain.

Can someone please show step by step using excel thank you.

Answer 1