Homework Help is Here – Start Your Trial Now!
Math
Statistics
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 superinter is correct in his beliefs? c. If the certain school has an average SOL score of 74, with an average teacher salary of P27,500 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 P30,000 as well as a benefits program, with the goal increasing the average tenure to 9 years. He has suggested that if the board passes his proposals, th

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 superinter is correct in his beliefs? c. If the certain school has an average SOL score of 74, with an average teacher salary of P27,500 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 P30,000 as well as a benefits program, with the goal increasing the average tenure to 9 years. He has suggested that if the board passes his proposals, th

Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter4: Polynomial And Rational Functions
Section4.6: Variation
Problem 37E
See similar textbooks
icon
Related questions
Question
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. If the certain school has an average SOL score of 74, with an average teacher salary of P27,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 P30,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 forecasting model?
Transcribed Image Text: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. If the certain school has an average SOL score of 74, with an average teacher salary of P27,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 P30,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 forecasting model?
Average Tenure of Average SOL Average Teacher School the Teachers in Score Salary Years 81 34,300 9.3 2 78 28,700 10.1 3 76 26,500 7.6 77 36,200 8.2 84 35,900 8.8 6 86 32,500 12.7 7 79 31,800 8.4 8. 91 38,200 11.5 6. 68 27,100 8.3 10 73 31,500 7.3 11 90 37,600 12.3 12 85 40,400 14.2 st LO
Transcribed Image Text:Average Tenure of Average SOL Average Teacher School the Teachers in Score Salary Years 81 34,300 9.3 2 78 28,700 10.1 3 76 26,500 7.6 77 36,200 8.2 84 35,900 8.8 6 86 32,500 12.7 7 79 31,800 8.4 8. 91 38,200 11.5 6. 68 27,100 8.3 10 73 31,500 7.3 11 90 37,600 12.3 12 85 40,400 14.2 st LO
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS