Question

Sales	Direct	Newspaper	Television
15.98	1.05	1.35	1.55
21.59	1.29	2.25	1.97
25.47	0.96	1.79	1.64
16.02	1.51	1.73	1.73
16.58	1.30	1.71	1.61
20.10	1.06	1.61	1.82
17.49	0.86	1.62	1.97
22.53	0.78	2.20	1.61
23.98	1.20	1.77	1.13
18.96	0.83	1.17	1.77
24.64	1.01	1.76	2.04
19.52	1.34	1.81	1.63
19.97	0.55	2.25	1.93
18.86	1.06	1.98	1.63
22.79	0.90	1.54	2.27
20.38	1.88	1.15	1.45
16.51	0.51	1.19	1.93
18.32	0.53	1.75	1.44
16.04	1.21	1.01	1.46
18.91	0.90	1.68	1.66
20.09	0.97	1.72	1.59
19.83	1.01	1.72	1.42
18.42	1.29	1.47	2.05
21.99	1.35	1.94	2.28
20.57	1.07	2.31	1.77

RUN MULTIPLE REGRESSION AND SHOW CALCULATION MANUALLY PLEASE. I HAVE GOT 2 HOURS LEFT.

IF POSSIBLE PLEASE CALCULATE THE CONFIDENCE INTERVALS WITH 95% OR 90%

Answer 1

ANSWER:

Given that,

The dependent variable is Sales.

The independent variables are direct,newspaper and television.

By Using Minitab we get the following Output.

From the above output we have R^2=0.195.The fit is not good for the model.

The regression equation is,

Sales = 12.3 + 0.57 Direct + 3.32 Newspaper + 0.73 Television.

From the above output we have the p-value of the regression coefficient Direct is 0.744 .So it is large. There is no significantly different from zero at 0.05 significance level.

From the above output we have the p-value of the regression coefficient Direct is 0.712 .So it is large. There is no significantly different from zero at 0.05 dignificance level.

From the above output we have the independent variable Newspaper has the strongest impact on the dependent variables.The independent variable Direct has the weakest impact.

From the above output we have the p-value of the regression coefficient of news paper is 0.043 .So it is small. It is significantly different from zero at 0.05 significance level.