Use Excel to test whether the true proportion of complaints submitted on a Monday is different from 20%. Identify the test statistic, z, and p-value from the Excel output, rounding to three decimal places. Provide your answer below: test statistic= p-value=
A CEO wondered if her company received either more or less complaints from its workers on Monday than any other day. She figured that if it were truly random, 20% of the complaints should have been filed on Monday. She randomly selected 50 complaints and checked the day that they were submitted. In those complaints 13 were submitted on a Monday.
The CEO conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of complaints submitted on a Monday is different from 20%.
(a) H0:p=0.2; Ha:p≠0.2, which is a two-tailed test.
(b) Use Excel to test whether the true proportion of complaints submitted on a Monday is different from 20%. Identify the test statistic, z, and p-value from the Excel output, rounding to three decimal places.
Provide your answer below:
Step by step
Solved in 3 steps with 2 images
