The State of Virginia has instituted a series of Standards of Learning (SOL) tests in math, history, English, and science that all high school students must pass with a grade of 70 before that are allowed to graduate and receive their diploma. The school superintendent of Montgomery County believes the tests are unfair because they are closely related to teacher salaries and teacher school tenure (i.e., the years a teacher has been at a school). The superintendent has sampled 12 other county school systems in the state and accumulated the following data for average teacher salaries and average teacher tenure.

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 superintendent is correct in his beliefs?
c. Montgomery County has an average SOL score of 74 with an average teacher€™s 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 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 SOL score will increase to 80. Is he correct according to the forecastingmodel?

Transcribed Image Text:

le rel 3 1 7 2 8 7 8 1.5 2.3 2.3 2.3 2 a les 00 00 00 200 00 500 00 00 100 500 600 00 34 28 26 36 35 32 31 38 27 31 37 40 81 78 76 84 86 79 91 68 73 90 85 AO bo 123456789111