The Academic Performance Index (API), described in Exercise 12.13, is a measure of school achievement based on

Question:

The Academic Performance Index (API), described in Exercise 12.13, is a measure of school achievement based on the results of the Stanford 9 Achievement Test. The API scores for 12 elementary schools in Riverside County, California, are shown below, along with several other independent variables.5

The variables are defined as
y = API score in 2010
x1 = % of students who are "English learners"
x2 = % of students who receive a free or reduced cost lunch
x3 = Average parent education level (with 1 = Not a high school graduate, 2 = High school graduate, 3 = Some college, 4 = College graduate, 5 = Graduate school)
x4 = % of students in Gifted and Talented Education Program
x5 = API score in 2009
The MINITAB printout for a first-order regression model is given below.
Regression Analysis: y versus x1, x2, x3, x4, x5
The regression equation is
y = 15 - 0.306 x1 + 0.076 x2 - 48.1 x3
+ 1.93 x4 + 1.13 x5

a. What is the model that has been fit to this data? What is the least-squares prediction equation?
b. How well does the model fit? Use any relevant statistics from the printout to answer this question.
c. Which, if any, of the independent variables are useful in predicting the API, given the other independent variables already in the model? Explain.
d. Use the values of R2 and R2(adj) in the following printout to choose the best model for prediction.