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 a = 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 a = 12 should be rejected for Costco. State the null and alternative hypotheses. Ho: o² = 144 H₂:0² Ⓒ144 Calculate the value of the test statistic (to 2 decimals). p-value is With a .05 level of significance, what is your conclusion?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

please help asap i will upvote!!

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 a = 12 should be rejected for Costco.
State the null and alternative hypotheses.
Ho: 0²
H₂ : 0²
Calculate the value of the test statistic (to 2 decimals).
= 144
144
p-value is
With a .05 level of significance, what is your conclusion?
(
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 a = 12 should be rejected for Costco. State the null and alternative hypotheses. Ho: 0² H₂ : 0² Calculate the value of the test statistic (to 2 decimals). = 144 144 p-value is With a .05 level of significance, what is your conclusion? (
D2
File
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
วา
Home
A
Satisfaction
Score
95
90
83
76
95
98
80
80
80
92
88
80
97
67
64
Insert
B
Arial
fx
Draw
Part a
Mean
Part b
Variance
Page Layout
✓ 10
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)
Data +
Calculation Mode: Automatic Workbook Statistics
B
Formulas
Can the hypothesis that the population
standard deviation is 12 be rejected? (Enter
"Can be rejected" or "Cannot be rejected")
4.
Data
D
Review
12
0.05
View
E
ab
Formula
Help
Number
F
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
←0
.00
.00
→.0
G
H
Ev
J
Editing
27
K
Give Feedback to Microsoft
L
Comments
M
100% +
Transcribed Image Text:D2 File 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 วา Home A Satisfaction Score 95 90 83 76 95 98 80 80 80 92 88 80 97 67 64 Insert B Arial fx Draw Part a Mean Part b Variance Page Layout ✓ 10 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) Data + Calculation Mode: Automatic Workbook Statistics B Formulas Can the hypothesis that the population standard deviation is 12 be rejected? (Enter "Can be rejected" or "Cannot be rejected") 4. Data D Review 12 0.05 View E ab Formula Help Number F #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A ←0 .00 .00 →.0 G H Ev J Editing 27 K Give Feedback to Microsoft L Comments M 100% +
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Most of the answers are all incorrect. Please provide correct answers!!

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman