History Bookmarks Develop Window Help 4) 100% Sun 8:53 PM ESCP 4170 Summer 2018

Question

History Bookmarks Develop Window Help 4) 100% Sun 8:53 PM ESCP 4170 Summer 2018 Payton Golomski 7/15/18 8:53 PM Homework: Homework 10 Score: 0 of 1 pt 10.4.13-T 100110 (7 complete) ? HW Score: 65%, 6.5 of 10 pt Question Help * The accompanying table provides data for tar, nicotine, and carbon monoxide (CO) contents in a certain brand of cigarette. Find the best regression equation for predicting the amount of nicotine in a cigarette. Why is it best? is the best regression equation a good regression equation for predicting the nicotine content? Why or why not? ?Click the icon to view the cigarette content data. Find the best regression equation for predicting the amount of nicotine in a cigarette. Use predictor variables of tar and/or carbon monoxide (CO). Select the correct choice and fill in the answer boxes to complete your choice. (Round to three decimal places as needed.) O A. Niootineco o B. Nicotine-W + (M) Tar ° C. Nicotine-W + CD Tar+ CD co Click to select and enter your answerle) and then click Check Answer

Explanation / Answer

We run regression analysis in excel:

Data > Data analysis > regression

Here we have intercept = a = 0.2095, coefficient of tar = b1 = 0.0960, coefficient of CO = b2 = -0.0101

Hence the required regression equation is

Nicotine = 0.209 + 0.096 * Tar -0.010 * CO

SUMMARY OUTPUT Regression Statistics Multiple R 0.916564 R Square 0.840089 Adjusted R Square 0.825552 Standard Error 0.106812 Observations 25 ANOVA df SS MS F Significance F Regression 2 1.318604 0.659302 57.78847 1.75E-09 Residual 22 0.250996 0.011409 Total 24 1.5696 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 0.209503 0.082247 2.54726 0.018363 0.038934 0.380072 Tar 0.095956 0.01142 8.402261 2.59E-08 0.072272 0.11964 CO -0.03788 0.010056 -3.76685 0.001063 -0.05873 -0.01702

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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