The State of Virginia has instituted a series of standards of learning (SOL) tests in math, history,
a. Using Excel or QM for Windows, develop the multiple regression equation for these data.
b. What is the coefficient of determination for this regression equation? Do you think the superintendent is correct in his beliefs?
c. Montgomery County has an average SOL score of 74, with an average teacher salary of $27,500 and an average teacher tenure of 7.8 years. The superintendent has proposed to the school board a salary increase that would raise the average salary to $30,000 as well as a benefits program, with the goal of increasing the average tenure to 9 years. He has suggested that if the board passes his proposals, then the average SOL score will increase to 80. Is he correct, according to the forecastingmodel?
Step by Step Answer: