A school board has instituted a series of standardized tests in math, history, English, and science that
a. Using Excel, develop the multiple regression equation for these data.
b. What is the coefficient of determination for this regression equation? Do you think the administrator is correct in his beliefs?
c. The administrators school board has an average test score of 74 with an average teachers salary of $37,500 and an average teacher tenure of 7.8 years. The administrator has proposed to the school board a salary increase that would raise the average salary to $40,000 and a benefits program with a goal of increasing the average tenure to nine years. He has suggested that if the board passes his proposals, the average test score will increase to 80. Is he correct according to the forecasting model?
Step by Step Answer: