Question

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. Using the data provided below, calculate the p-value for the following hypothesis test:

H0:μ=131,520H0:μ=131,520

Ha:μ≠131,520

A:

Listeners after change
125,020
139,250
101,590
94,800
83,700
84,380
139,170
89,380
91,410
139,570
138,980
102,710
124,600
144,770
156,920
131,100
140,020
139,250
118,800
128,380
168,370
133,140
106,930
129,630
120,820
125,250
122,860
122,500
135,230
148,870

P.s: Please provide only Excel formula that should be used

Answer 1

셀 Significance level alpha = 1-0.95 Given p-value 0.0743 Since P.udue 〉0.05 Significance lewd Je do not have Snsftcient evidence we conelud t oos rgrifcance Level the manager should fail to naject the hypsthests ere is not enoug evidence to Conclude. Ihat he number unigae daily stenehas chauged