In: Statistics and Probability
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?
Tar   Nicotine   CO
5   0.5   3
15   1.0   19
17   1.1   16
14   0.7   19
14   0.8   19
14   1.0   13
15   1.0   16
14   1.1   14
15   1.2   15
8   0.8   12
13   0.8   18
12   0.8   16
12   0.8   18
15   1.0   17
2   0.3   3
16   1.1   17
15   1.0   14
13   0.7   19
13   1.1   14
15   0.9   16
15   1.1   14
15   1.1   16
8   0.6   8
18   1.3   17
14   1.1   13
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.
A. Nicotine = __ + (__) Tar + (__) CO
B. Nicotine = __ + (__) Tar
C. Nicotine = __ + (__) CO
the best regression equation for predicting the amount of nicotine in a cigarette.
A. Nicotine = __ + (__) Tar + (__) CO is the correct choice of predicting the variables
Nicotine = 0.255+0.082 Tar - 0.028 CO
Multiple linear regression is one of the best satistica; anlysis to predict the vatiables.
STep 1: Run a Regression analysis in excel followd by below procedures
Goto data tab --> Data analysis --> choose Regression

Results:
