Using the WK7_VALIDGroup.xls dataset, construct a simple regression with alcohol

Question

Using the WK7_VALIDGroup.xls dataset, construct a simple regression with alcohol consumption (alco_dr) as the dependent variable and saturated fat (sfat_dr) as the independent variable. What were the null and alternative hypotheses? Explain in your own words what the answer means.

alco_dr (y) sfat_dr (x) 2.18 11.82 3.45 12.71 2.62 14.04 5.2 14.38 0.96 14.42 0.78 14.6 4.4 14.68 0.05 15.18 6.68 15.3 13.79 15.39 22.89 15.94 8.18 15.99 2.25 16 0 16.04 27.26 16.61 0 16.73 4.17 16.74 20.69 16.93 13.91 16.98 13.11 17.26 0.51 17.48 6.6 17.64 0.83 17.73 3.7 17.73 0.38 17.74 0.57 17.92 12.18 18 2.22 18.12 11.15 18.33 7.31 18.57 19.38 18.59 2.98 18.63 8.1 18.64 8.49 18.75 1.39 18.79 20.5 18.83 12.48 18.94 0.9 19.03 0 19.73 1.43 19.79 15.12 19.81 10.86 20.06 8.22 20.07 7.28 20.2 3.77 20.39 22.31 20.39 27.86 20.46 8.09 20.71 0.95 20.72 0 20.74 0 20.87 0 21.04 14.23 21.34 7.18 21.35 0.6 21.39 4.21 21.41 2.79 21.56 11.16 21.57 0.8 21.58 0.38 21.76 12.97 21.79 10.35 21.9 12.03 21.95 9.49 21.98 7.79 22.02 3.11 22.16 1.27 22.32 2.56 22.42 4.75 22.51 2.69 22.61 22.66 23.17 0 23.34 9.92 23.42 1.99 23.43 0.39 23.45 5.37 23.48 21.78 23.49 1.89 23.56 1.89 23.59 15.6 23.62 7.85 23.65 28.28 23.66 32.72 23.79 5.39 23.98 12.95 24.09 5.97 24.1 13.62 24.16 0.79 24.37 4.49 24.38 7.75 24.51 3 24.61 8.15 24.62 0 24.78 9.69 24.83 0 25.1 4.6 25.11 15.69 25.17 9.43 25.25 10.04 25.28 0 25.47 0 25.62 15.41 25.69 23.97 25.85 4.88 25.97 8.31 26.24 6.92 26.25 5.23 26.26 1.58 26.4 4.75 26.4 5.04 26.4 2.26 26.46 27.55 26.46 25.74 26.48 17.27 26.58 3.44 26.76 2.2 26.83 32.64 26.98 49.15 27.08 17.9 27.15 1.76 27.39 1.84 27.5 6.97 27.51 16.61 27.59 0.4 27.74 5.17 27.83 0.85 27.92 3.35 27.99 15.72 28.02 1.76 28.04 4.57 28.26 2.93 28.33 0.77 28.34 37.9 28.63 5.84 28.65 0 28.72 7.12 29.06 0 29.17 5.97 29.35 0.6 29.57 0.63 29.59 8.75 29.6 17.22 30.01 17.76 30.92 3.82 30.98 10.41 31.2 7.82 31.35 28.29 31.35 31.26 31.41 37.28 32.03 4.67 32.19 0 32.86 8.26 33.2 11.13 33.25 1.14 33.26 0 34.04 22.44 34.14 40.11 34.25 23.44 34.34 2.17 34.61 8.65 36.16 4.6 36.19 0 36.31 16.51 36.44 6.77 38.68 20.13 38.73 0.14 39.3 18.69 39.36 28.79 39.43 6.99 40.59 0 41.01 0.03 45.31 10.12 46.01 29.81 46.36

Explanation / Answer

Sol:

Regression output:

alco_dr (y)=2.509+0.259(sfat_dr (x))

slope=0.259

y intercept=2.509

The null hypothesis states that the slope is equal to zero, and the alternative hypothesis states that the slope is not equal to zero.

If there is a significant linear relationship between the independent variable X and the dependent variable Y, the slope will not equal zero.

SUMMARY OUTPUT Regression Statistics Multiple R 0.181418 R Square 0.032912 Adjusted R Square 0.027257 Standard Error 9.53143 Observations 173 ANOVA df SS MS F Significance F Regression 1 528.6946 528.6946 5.819541 0.016907 Residual 171 15535.03 90.84816 Total 172 16063.73 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 2.508851 2.771819 0.905128 0.366671 -2.96254 7.980238 sfat_dr (x) 0.258871 0.10731 2.412373 0.016907 0.047049 0.470693

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.