Complete Problems 4-22 and 4-23.
Complete Problem 4-24. In addition to the questions in this problem, respond to the following:
1. State the linear equation.
2. Explain the overall statistical significance of the model.
3. Explain the statistical significance for each independent variable in the model
4. Interpret the Adjusted R2.
5. Is this a good predictive equation(s)? Which variables should be excluded (if any) and why? Explain.
Complete Problem 4-30.
Use Excel's regression option to perform the regression. Use one Excel spreadsheet file for the calculations and explanations, with one worksheet per problem. Use the problem number for each worksheet name. Cells should contain the formulas