Question: I need help solving the following problems, C, D, E please type answer Mike Wilde is president of the teachers' union for Otsego School District.

I need help solving the following problems, C, D, E please type answerI need help solving the following problems, C, D, E please typeanswer Mike Wilde is president of the teachers' union for Otsego SchoolDistrict. In preparing for upcoming negotiations, he is investigating the salary structure

Mike Wilde is president of the teachers' union for Otsego School District. In preparing for upcoming negotiations, he is investigating 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 teaching effectiveness rating given by the principal, and whether the teacher has a master's degree. A random sample of 20 teachers resulted in the following data. Salary ($ Years of thousands), y Experience, x1 31.1 8 33.6 5 29.3 2 43.0 15 38.6 11 45.0 14 42.0 9 36.8 7 48.6 22 31.7 3 25.7 1 30.6 5 51.8 23 46.7 17 38.4 12 33.6 14 41.8 8 30.7 4 32.8 2 42.8 8 Principal's Rating, X2 35 43 51 60 73 80 76 54 55 90 30 44 84 76 68 25 90 62 80 72 Master's Degree, * x3 0 0 1 1 0 1 0 1 1 1 OOOOOO *1 = yes, O = no. picture Click here for the Excel Data File c. Conduct a global test of hypothesis to determine whether any of the regression coefficients differ from zero. Use the 0.05 significance level. (Round your answers to 2 decimal places.) HO is rejected if F> HO is rejected 0.05. Computed F = 0.59 . At least one regression coefficient is not zero. d. Conduct a test of hypothesis for the individual regression coefficients. Would you consider deleting any of the independent variables? Use the 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) or right of A regression coefficient is dropped if computed t is to the left of Keep" "and" "drop" e. If your conclusion in part (d) was to delete one or more independent variables, run the analysis again without those variables. (Round your answers to 4 decimal places.) Dropping" "we have: Salary =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!