Question

In: Statistics and Probability

Mike Wilde is president of the teachers’ union for Otsego School District. In preparing for upcoming...

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.

  1. Salary ($ thousands), y Years of Experience, x1 Principal's Rating, x2 Master's Degree,* x3
    31.1 8 35 0
    33.6 5 43 0
    29.3 2 51 1
    43.0 15 60 1
    38.6 11 73 0
    45.0 14 80 1
    42.0 9 76 0
    36.8 7 54 1
    48.6 22 55 1
    31.7 3 90 1
    25.7 1 30 0
    30.6 5 44 0
    51.8 23 84 1
    46.7 17 76 0
    38.4 12 68 1
    33.6 14 25 0
    41.8 8 90 1
    30.7 4 62 0
    32.8 2 80 1
    42.8 8 72 0
  2. Develop a correlation matrix. Which independent variable has the strongest correlation with the dependent variable? Does it appear there will be any problems with multicollinearity? (Round your answers to 3 decimal places.
  3. Determine the regression equation. What salary would you estimate for a teacher with 5 years’ experience, a rating by the principal of 60, and no master’s degree? (Negative amount should be indicated by a minus sign. Round salary to nearest whole number, all other answers to 3 decimal places.)
  4. The regression equation is:
  5. 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.)

  6. 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.)

  7. 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.

Solutions

Expert Solution


Related Solutions

Salaries for teachers in a particular elementary school district are normally distributed with a mean of...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of $44,000 and a standard deviation of $6,500. We randomly survey ten teachers from that district. 1.Find the probability that the teachers earn a total of over $400,000 2.If we surveyed 70 teachers instead of ten, graphically, how would that change the distribution in part d? 3.If each of the 70 teachers received a $3,000 raise, graphically, how would that change the distribution in part...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of $44,000 and a standard deviation of $6,500. We randomly survey ten teachers from that district. Find the 85th percentile for the sum of the sampled teacher's salaries to 2 decimal places.
Salaries for teachers in a particular elementary school district are normally distributed with a mean of...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of $41,000 and a standard deviation of $6,100. We randomly survey ten teachers from that district. A. Give the distribution of ΣX. (Round your answers to two decimal places.) ΣX - N ( , ) B. Find the probability that the teachers earn a total of over $400,000. (Round your answer to four decimal places.) C. Find the 80th percentile for an individual teacher's salary....
Salaries for teachers in a particular elementary school district are normally distributed with a mean of...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of $46,000 and a standard deviation of $4,900. We randomly survey ten teachers from that district. (Round your answers to the nearest dollar.) (a) Find the 90th percentile for an individual teacher's salary. (b) Find the 90th percentile for the average teacher's salary.
Salaries for teachers in a particular elementary school district are normally distributed with a mean of...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of $46,000 and a standard deviation of $4,500. We randomly survey ten teachers from that district. (Round your answers to the nearest dollar.) A) Find the 90th percentile for an individual teacher's salary. B)Find the 90th percentile for the average teacher's salary.
Salaries for teachers in a particular elementary school district have a mean of $44,000 and a...
Salaries for teachers in a particular elementary school district have a mean of $44,000 and a standard deviation of $6,500. We randomly survey 36 teachers from that district. Why can we say the sampling distribution of mean salaries for teachers in this district is approximately normal? Find the probability that the mean salary is less than $43,000. Find the probability that the mean salary is between $45,000 and $47,000.
Salaries for teachers in a particular elementary school district are normally distributed with a mean of...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of $42,000 and a standard deviation of $5,700. We randomly survey ten teachers from that district. (Round your answers to the nearest dollar.) (a) Find the 90th percentile for an individual teacher's salary. $ = (b) Find the 90th percentile for the average teacher's salary. $ =
Salaries for teachers in a particular elementary school district are normally distributed with a mean of...
Salaries for teachers in a particular elementary school district are normally distributed with a mean of $44,000 and a standard deviation of $6,300. We randomly survey ten teachers from that district. (Round your answers to the nearest dollar.) (a) Find the 90th percentile for an individual teacher's salary. (b) Find the 90th percentile for the average teacher's salary. A typical adult has an average IQ score of 105 with a standard deviation of 20. If 19 randomly selected adults are...
The following table shows the number of fifth and sixth grade teachers in a school district...
The following table shows the number of fifth and sixth grade teachers in a school district and the number of students in each of those grades. The number of teachers for each of the grade levels was determined by using the Huntington-Hill apportionment method. The district has decided to hire a new teacher for either the fifth or sixth grade. Number of teachers Number of students Fifth grade 19 607 Sixth grade 23 739 (a) Use the apportionment principle to...
7.75 p. 428 Salaries for teachers in a particular elementary school district are normally distributed with...
7.75 p. 428 Salaries for teachers in a particular elementary school district are normally distributed with a mean of $44,000 and a standard deviation of $6,500. We randomly survey ten teachers from that district. a. In words, X = ______________ b. X ~ _____(_____,_____) c. In words, ΣX = _____________ d. ΣX ~ _____(_____,_____) e. Find the probability that the teachers earn a total of over $400,000. f. Find the 90th percentile for an individual teacher's salary. g. Find the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT