MU Ohio Education Performance Analysis Results Project

CASE DESCRIPTION

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. 

INSTRUCTIONS

1. Import the OhioEducationPerformance.xlsx data into SAS JMP.
2. Use JMP to
   1. Suggest and build the best regression model to predict math success as a function of success in the other subjects by examining the correlation matrix.
   2. Run the Regression tool for this set of variables. (NOTE: “ALL” is not an academic subject!)
3. Develop a multiple regression model to predict math success as a function of success in all other subjects using the systematic approach described in chapter 8 of the textbook. Is multicollinearity a problem?
4. Compare the models in parts 2 and 3. Are they the same? Why or Why not?
5. Write a brief narrative comparing the two models.
6. Save and name the file unique_ID_OhioPerformance.
7. Submit your .jmp file.