Question

The accompanying table, MultiLinear Regression 5, provides data for tar, nicotine, and carbon monoxide (CO) contents in a certain brand of cigarette. All measurements are in milligrams (mg). Part a) Run the Multilinear Regression Analysis in Excel with both predictor variables. What is the adjusted R2 value to the nearest hundredth of a percent (i.e. 45.67%)? Adjusted R2 =

Nicotine (Y)	Tar (X1)	CO (X2)
0.4	5	3
0.9	9	11
0.7	12	18
0.8	13	18
1	16	18
0.6	6	6
0.9	15	18
1.1	15	15
0.8	13	18
1.2	17	16

Answer 1

Applying multiple regression in excel:

Regression Statistics
Multiple R	0.9061
R Square	0.8211
Adjusted R Square	0.7699
Standard Error	0.1135
Observations	10
ANOVA
	df	SS	MS	F	Significance F
Regression	2	0.4138	0.2069	16.0603	0.0024
Residual	7	0.0902	0.0129
Total	9	0.5040
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	0.2372	0.1161	2.0438	0.0803	-0.0372	0.5117	-0.0372	0.5117
Tar (X1)	0.0773	0.0192	4.0267	0.0050	0.0319	0.1227	0.0319	0.1227
CO (X2)	-0.0236	0.0143	-1.6487	0.1432	-0.0574	0.0102	-0.0574	0.0102

adjusted R2 value =76.99%