Consider the following set of dependent and independent variables. These data can also be found in the Excel file Prob 1543.xlsx.

y 64 43 51 49 40 42 23 37 30 27 20 x1 74 63 78 52 44 47 35 17 15 20 17 x2 22 29 20 17 13 17 8 15 10 10 7 x3 24 15 9 38 18 17 5 40 27 30 33

a. Perform a general stepwise regression using a = 0.05 for the p-value to enter and to remove independent variables from the regression model.

b. Perform a residual analysis for the model developed in part a to verify that the regression conditions are met.

AppendixLO1