Mr. Mike Wilde is president of the teachers' union for the Otsego School District. In preparing for
Question: Mr. Mike Wilde is president of the teachers' union for the Otsego School District. In preparing for the upcoming negotiations, he would like to investigate the salary structure of classroom teachers in the district. he believes there are three factors that affect a teacher's salary: years of experience, a rating of teaching effectiveness given by the principal, and whether or not the teacher has a master's degree. A sample of 20 teachers resulted in the following data.
Salary ($1,000’s) Experience Principal's Rating Master's Degree
21.1 8 35 no
23.6 5 43 no
19.3 2 51 yes
33.3 15 60 yes
28.6 11 73 no
35.0 14 80 yes
32.0 9 76 no
26.8 7 54 yes
38.6 22 55 yes
21.7 3 90 yes
15.7 1 30 no
20.6 5 44 no
41.8 23 84 yes
36.7 17 76 no
28.4 12 68 yes
23.6 14 25 no
31.8 8 90 yes
20.7 4 62 no
22.8 2 80 yes
32.8 8 72 no
A. Determine the regression equation. Interpret your results.
B. What salary would you estimate for a teacher with five years' experience, a rating by the principal of 60, and no master's degree?
Deliverables: Word Document