LEARNING OBJECTIVES After studying this chapter, you should be able to:
- Determine whether multiple regression would be applicable to
a given instance.
- Formulate a multiple regression model.
- Carry out a multiple regression using the spreadsheet
template.
- Test the validity of a multiple regression by analyzing residuals.
- Carry out hypothesis tests about the regression coefficients.
- Compute a prediction interval for the dependent variable.
- Use indicator variables in a multiple regression.
- Carry out a polynomial regression.
- Conduct a Durbin-Watson test for autocorrelation in residuals.
- Conduct a partial F test.
- Determine which independent variables are to be included in a
multiple regression model.
- Solve multiple regression problems using the Solver macro.
|