The data below show the consumption of alcohol (X, liters per year per person, 14 years or older) and the death rate from cirrhosis, a liver disease (Y, death per 100,000 population) in 15 countries (each country is an observation unit).

Country	Alcohol Consumption (x)	Death Rate from Cirrhosis (y)
France	24.7	46.1
Italy	15.2	23.6
Germany	12.3	23.7
Australia	10.9	7.0
Belgium	10.8	12.3
USA	9.9	14.2
Canada	8.3	7.4
England	7.2	3.0
Sweden	6.6	7.2
Japan	5.8	10.6
Netherland	5.7	3.7
Ireland	5.6	3.4
Norway	4.2	4.3
Finland	3.9	3.6
Israel	3.1	5.4

a.Enter the data into Excel - Column A - "Alcohol Consumption (x)" and Column B - "Death Rate from Cirrhosis (y)". Show Excel output.

b.Construct a scatter plot.Label all axes. Show Excel output.

c.Does the scatter plot show evidence of a linear correlation? If yes, what type? Why?

Place the answer in this space. Add more space as needed.

d.Findr andr2.

Place the answer in this space. Add more space as needed.

e.Interpretr2in context of this problem.

Place the answer in this space. Add more space as needed.

f.Test the claim "There is a significant linear correlation between alcohol consumption (x) and the death rate from cirrhosis (y).

Place the answer in this space. Add more space as needed. Show a complete Hypothesis test.

g.Find the regression equation. Write equation in contest of tis problem.

Place the answer in this space. Add more space as needed.

h.Use the regression equation to estimate the death rate for a country when alcohol consumption is 4.8 liters per person per year.

Place the answer in this space. Add more space as needed.

i.Find the residual value for the Death Rate from Cirrhosis for Germany.

Place the answer in this space. Add more space as needed.

j.Find the predicted Death Rate from Cirrhosis for all countries. Enter your results in Excel Column C. Show Excel output.

k.Construct a residual plot. Show Excel output.

l.Is the linear model a valid model? Comment using the results from part 'k".

Place the answer in this space. Add more space as needed.