Consider the following data: Using Minitab to answer the following questions:

Y X1 X2 X3 X4 X5 X6

381 46 185 -16 -3 1.1 24.4

2040.8 86 282 5 0 10.9 20.9

978.7 53 183 6 -47 7.6 22.6

668.2 64 248 -22 -7 5.1 26.8

677.1 55 201 0 2 5.9 29.2

1128.8 88 305 -3 -2 7.1 23.1

514.6 53 198 6 -2 3.9 24.1

1154.9 84 301 -3 -1 7.5 28.1

502.8 58 219 -15 -4 1 27.5

491.5 41 175 -13 -3 5.4 25.3

281.3 36 139 -14 -4 2.6 25.4

1163.4 63 202 -5 1 8.7 26.2

808.4 44 160 -2 -7 7.5 24.6

903.8 95 310 -11 -28 2.8 27.3

537.5 64 228 -8 -5 0.9 24.3

665.2 45 176 -6 -4 6.6 29.6

537 47 182 -2 -3 5.2 30.0

482.3 53 195 -8 -7 2.9 21.2

1924.7 76 253 -16 -4 10.9 21.8

1254.1 65 241 3 -2 8.8 26.4

1.What is the regression equation for Y, in terms of the independent variables: X1, X2, X3, X4, X5 and X6?

2.How much of the variability in Y is explained by your model?Explain.

3.State the hypotheses to test for the significance of the regression equation. Is the regression equation significant at alpha=0.05? Explain.

4.State the hypotheses to test for the significance of the independent factors.

5.Which independent factors are significant at alpha= 0.05? Explain

6.What tools would you use to check if the model hasmulticollinearity problems?

7.Does this model have multicollinearity problems? Explain.

8.If you were to propose a simplified regression model by eliminating some of the variables, what would the regression equation be? What variables would you eliminate? Why would you eliminate these variables?

9.How would you checkif the model assumptions are met?