1. Shown is a partial computer output from a regression analysis

Sales Ad NumEmp Temp

11 4 3 32

13 4 4 40

14 5 5 50

10 3 3 29

12 4 3 33

13 3 4 36

15 4 6 52

18 6 7 53

17 7 6 52

20 8 7 60

The regression equation is

Sales = 5.20 + 1.25 Ad + 1.5 NumEmp + 0.72 Temp

Predictor Coef SE Coef T P

Constant 5.200 1.432 3.63 0.016

Ad 1.250 0.532 2.35 0.047

NumEmp 1.500 0.811 1.85 0.102

Temp 0.720 1.125 0.64 0.538

R-Sq = ------

Analysis of Variance

Source DF SS MS F P

Regression ---- ------- ------ 60.00 0.01

Residual Error ---- ------- 1.25

Total ---- -------

Stepwise Regression: Sales versus Ad, NumEmp, Temp

Backward elimination.

Step 1 2 3

Constant 5.200 4.320 3.432

Ad 1.250 2.300

T-Value 2.35 2.90

P-Value 0.034 0.024

NumEmp 1.500 3.125 3.205

T-Value 1.85 4.80 9.72

P-Value 0.152 0.010 0.002

Temp 0.720

T-Value 0.64

P-Value 0.657

a) Calculate all of the missing entries.

b) Using Analysis of Variance table, determine whether there is a significant linear

relationship between Y and at least one of the three explanatory variables at 0.05 level of significance