The State of Ohio Department of Education has a mandated ninth‐grade proficiency test that covers writing, reading, mathematics, citizenship (social studies), and science. The Excel file Ohio Education Performance provides data on success rates (defined as the percentage of students passing) in school districts in the greater Cincinnati metropolitan area along with state averages.
a. Develop a multiple regression model to predict math success as a function of success in all other subjects using the systematic approach described in this chapter. Is multicollinearity a problem?
b. Suggest the best regression model to predict math success as a function of success in the other subjects by examining the correlation matrix; then run the regression tool for this set of variables.
c. Develop the best regression model to predict math success as a function of success in the other subjects using best‐subsets regression.
d. Develop the best regression model to predict math success as a function of success in the other subjects using stepwise regression.
e. Compare the results for parts (a) through (d). Are the models the same? Why or why not?