# The data provided below calculate the p value for the

• Test Prep
• 19
• 96% (82) 79 out of 82 people found this document helpful

This preview shows page 10 - 13 out of 19 pages.

the data provided below, calculate the p-value for the following hypothesis test:: H 0 :μ=131,520 H0:μ=131,520 H a :μ≠131,520 To use Excel’s T.TEST function for a hypothesis test with one sample, you must create a second column of data that will act as a second sample. So, first enter the historical average production rate into each cell in column B associated with a day in the sample; that is, enter 131,520 into cells B2 to B31 . Then, the p-value of the two-sided hypothesis test is T.TEST(array1, array2, tails, type)=T.TEST(A2:A31,B2:B31,2,3), which is approximately 0.0743. You must link directly to values in order to obtain the correct answer.
12) A streaming music site changed its format to focus on previously unreleased music from rising artists. The site manager now wants to determine whether the number of unique listeners per day has changed. Before the change in format, the site averaged 131,520 unique listeners per day. Now, beginning three months after the format change, the site manager takes a random sample of 30 days and finds that the site now has an average of 124,247 unique listeners per day. The manager finds that the p-value for the hypothesis test is approximately 0.0743. What can be concluded at the 95% confidence level?
13) A streaming music site changed its format to focus on previously unreleased music from rising artists. The site manager now wants to determine whether the number of unique listeners per day has changed. Before the change in format, the site averaged 131,520 unique listeners per day. Now, beginning three months after the format change, the site manager takes a random sample of 30 days and finds that the site has an average of 124,247 unique listeners per day. The manager finds that the p-value for the hypothesis test is approximately 0.0743.