A school board has instituted a series of standardized tests in math, history, English, and science that

Question:

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.


Average Test Average Teacher Average Teacher School Salaries ($) Tenure (yr) Score $44,300 81 9.3 38,700 2 78 10.1 76 36


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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Operations Management Creating Value Along the Supply Chain

ISBN: 978-1118301173

1st Canadian Edition

Authors: Roberta S. Russell, Bernard W. Taylor, Ignacio Castillo, Navneet Vidyarthi

Question Posted: