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 percent of students passing) in school districts in the greater Cincinnati metropolitan area along with state averages.

a. 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.

b. 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?
c. Compare the models in parts ( a) and ( b). Are they the same? Why or why not?