Consumer Reports uses a 100-point customer satisfaction score to rate the nation's major chain stores. Assume that from past experience with the satisfaction rating score, a population standard deviation of 12 is expected. Costco with its 432 warehouses in 40 states was the only chain store to earn an outstanding rating for overall quality. A sample of 15 Costco customer satisfaction scores is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet a. What is the sample mean customer satisfaction score for Costco (to 2 decimals)? b. What is the sample variance (to 2 decimals)? c. What is the sample standard deviation (to 2 decimals)? d. Construct a hypothesis test to determine whether the population standard deviation of 12 should be rejected for Costco. State the null and alternative hypotheses. H₂=144 H₁: 144 Calculate the value of the test statistic (to 2 decimals). p-value is With a .05 level of significance, what is your conclusion? The hypothesis that the population standard deviation is 12 [cannot be rejected

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 13PPS
icon
Related questions
Question
100%
Consumer Reports uses a 100-point customer satisfaction score to rate the nation's major chain stores. Assume that from past experience with the satisfaction rating score, a population standard deviation of o = 12 is expected. Costco with its 432 warehouses in 40 states was the only chain store to earn an outstanding rating for overall quality. A sample of 15 Costco
customer satisfaction scores is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
X
Open
spreadsheet
a. What is the sample mean customer satisfaction score for Costco (to 2 decimals)?
b. What is the sample variance (to 2 decimals)?
c. What is the sample standard deviation (to 2 decimals)?
d. Construct a hypothesis test to determine whether the population standard deviation of o= 12 should be rejected for Costco.
State the null and alternative hypotheses.
Ho: o² = 144
H₂:0² v
Calculate the value of the test statistic (to 2 decimals).
144
p-value is
With a .05 level of significance, what is your conclusion?
The hypothesis that the population standard deviation is 12 [cannot be rejected ✔✔
Transcribed Image Text:Consumer Reports uses a 100-point customer satisfaction score to rate the nation's major chain stores. Assume that from past experience with the satisfaction rating score, a population standard deviation of o = 12 is expected. Costco with its 432 warehouses in 40 states was the only chain store to earn an outstanding rating for overall quality. A sample of 15 Costco customer satisfaction scores is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. X Open spreadsheet a. What is the sample mean customer satisfaction score for Costco (to 2 decimals)? b. What is the sample variance (to 2 decimals)? c. What is the sample standard deviation (to 2 decimals)? d. Construct a hypothesis test to determine whether the population standard deviation of o= 12 should be rejected for Costco. State the null and alternative hypotheses. Ho: o² = 144 H₂:0² v Calculate the value of the test statistic (to 2 decimals). 144 p-value is With a .05 level of significance, what is your conclusion? The hypothesis that the population standard deviation is 12 [cannot be rejected ✔✔
L23456NHAGEN
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
A
Satisfaction
Score
93
90
85
77
95
98
80
83
80
93
89
80
97
67
66
B
Part a
Mean
Part b
Variance
Part c
Standard Deviation
Part d
Degrees of Freedom
с
Hypothesized Standard Deviation
Chi Square Test Statistics
Lower-Tail p-value
Upper-Tail p-value
Two-Tail p-value
Significance Level (alpha)
Can the hypothesis that the population
standard deviation is 12 be rejected? (Enter
"Can be rejected" or "Cannot be rejected")
D
12
0.05
E
Formula
F
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Transcribed Image Text:L23456NHAGEN 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 A Satisfaction Score 93 90 85 77 95 98 80 83 80 93 89 80 97 67 66 B Part a Mean Part b Variance Part c Standard Deviation Part d Degrees of Freedom с Hypothesized Standard Deviation Chi Square Test Statistics Lower-Tail p-value Upper-Tail p-value Two-Tail p-value Significance Level (alpha) Can the hypothesis that the population standard deviation is 12 be rejected? (Enter "Can be rejected" or "Cannot be rejected") D 12 0.05 E Formula F #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 6 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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL