The Bureau of Labor Statistics reported that the average yearly income of doctors in the year 2017 was $115,000. A sample of 300 dentists, which was taken in 2018, showed an average yearly income of $120,000. Assume the standard deviation of the population of dentists’ incomes in 2017 is $30,000. We want to test and determine if there has been a significant increase in the average yearly income of dentists. Compute the test statistic. Compute the critical value. Determine the p-value; and at a 5% level of significance, test the hypotheses. *Because we know the sample size I will use a Z-test statistic. However, I need help with computing the z-test statistic in excel. Particularly, I'm a bit confused about how to set up the formula Z Test = (x̄ – μ) / (σ / √n) and computing the critical value. Thank you

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
icon
Related questions
Question

The Bureau of Labor Statistics reported that the average yearly income of doctors in the year 2017 was $115,000. A sample of 300 dentists, which was taken in 2018, showed an average yearly income of $120,000. Assume the standard deviation of the population of dentists’ incomes in 2017 is $30,000. We want to test and determine if there has been a significant increase in the average yearly income of dentists.

  1. Compute the test statistic.
  2. Compute the critical value.
  3. Determine the p-value; and at a 5% level of significance, test the hypotheses.

*Because we know the sample size I will use a Z-test statistic. However, I need help with computing the z-test statistic in excel. Particularly, I'm a bit confused about how to set up the formula Z Test = (x̄ – μ) / (σ / √n) and computing the critical value. Thank you. 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
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