Question

A)Draw a scatter plot to show a moderately strong relationship between wind consumption and heart disease death rate.

B)Calculate a, b, and R2 in the relationship Y = a + bX, where X is wine consumption and Y is heart disease death rate.

C)Use the equation above to predict the heart disease death rate in a country where wine consumption is 1 and and in a country where the consumption is 8.

Table 2; Problem 6.5 Country Wine Heart diseaseCountryWine Heart disease 7.50 Netherlands 2.75 New Zealand 2.50 Norway1.75 5.00 2.50 Switzerland 6.00 United Kingdom 2.75 United States 1.25 60 70 100 80 50 90 70 120 120 Italy Australia 3.25 Austria 4.75 Belgium 2.75 Canada 1.50 Denmark 4.50 Finland 3.00 France 8.50 Germany 3.75 Iceland1.25 Ireland 2.00 80 100 60 80 90 120 40 90 110 130 Spain Sweden

Answer 1

a)

Heart disease 140 120 100 80 60 Heart disease 40 20 0.00 2.00 4.00 6.00 8.00 10.00

b) solving using excel

SUMMARY OUTPUT Regression Statistics MultipleR R Square Adjusted R Square Standard Error Observations 0.644904211 0.415901441 0.381542702 20.1084088 19 ANOVA Significance F 1 4894.503275 4894.503 12.104680.002870742 MS Regression Residual Total 176873.917777 404.3481 18 11768.42105 Intercept Wine Coefficients Standard Error t Stat P-value Lower 95% Up er 95% Lower 95.0% Ug r 95.0% 115.86055229.39928677 12.326536.67E-10 96.02979075 135.69131 96.0297908 135.6913137 8.04982144 2.313713823 -3.47918 0.00287112.93133087-3.168312 -12.9313309 -3.16831202

a = 115.86

b = 8.05

R Square =0.416

$\small \hat{Y}$= 115.86 - 8.05X

c) Predicted heart disease death rate in a country where wine consumption is 1

$\small \hat{Y}$ = 115.86 - 8.05(1)

= 107.81

Predicted heart disease death rate in a country where the consumption is 8

$\small \hat{Y}$= 115.86 - 8.05(8)

= 51.46