A school board has instituted a series of standardized tests in math, history, English, and science that all high school students must pass with a grade of 70 before they are allowed to graduate and receive their diploma. One school administrator 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 administrator has sampled 12 other school board systems 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 administrator is correct in his beliefs?
c. The administrator€™s school board has an average test score of 74 with an average teacher€™s 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?

Transcribed Image Text:

Average Test Average Teacher Average Teacher School Salaries ($) Tenure (yr) Score $44,300 81 9.3 38,700 2 78 10.1 76 36,500 7.6 46,200 4 77 8.2 84 45,900 8.8 86 42,500 12.7 79 41,800 8.4 91 48,200 11.5 9. 68 37,100 8.3 41,500 10 73 7.3 11 90 47,600 12.3 12 85 50,400 14.2 3.