3. (1 Test (in Excel) for Two Paired Samples) The owner of a chain of mini-markets wants to compare the sales performance of two of her stores, Store 1 and Store 2. Though the two stores have been comparable in the past, the owner has made several improvements to Store 1 and wishes to see if the improvements have made Store 1 more popular than Store 2. Sales can vary considerably depending on the day of the week and the season of the year, so she decides to eliminate such effects by making sure to record each store's sales on the same sample of days. After choosing a random sample of days, she records the sales (in dollars) for each store on these days, as shown in the table. Day Store 1 Store 2 (Store 1-Store 2) Difference 1 2 3 4 5 6 7 8 9 10 11 12 397 297 345 375 365 168 290 270 812 731 869 975 ii. 848 980 220 692 498 823 668 469 605 14 670 370 100 -30 197 20 81 46 307 379 375 206 22 128 Based on these data, can the owner conclude, at the 0.10 level of significance, that the mean daily sales of Store 1 exceeds that of Store 2? Answer this question by performing a hypothesis test regarding #g, the population mean daily sales difference between the two stores. Assume that this population of differences is normally distributed. Use Excel to perform the hypothesis test. a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. c. Identify any critical value(s) and shade the critical region(s). Using the critical value method, should Ho be rejected at the a= 0.10 level of significance? Why or why not? ^ d. Choose an appropriate conclusion based on your decision in part d. i. The mean daily sales of Store 1 exceeds that of Store 2. There is not enough evidence to conclude that the mean daily sales of Store 1 exceeds that of Store 2
3. (1 Test (in Excel) for Two Paired Samples) The owner of a chain of mini-markets wants to compare the sales performance of two of her stores, Store 1 and Store 2. Though the two stores have been comparable in the past, the owner has made several improvements to Store 1 and wishes to see if the improvements have made Store 1 more popular than Store 2. Sales can vary considerably depending on the day of the week and the season of the year, so she decides to eliminate such effects by making sure to record each store's sales on the same sample of days. After choosing a random sample of days, she records the sales (in dollars) for each store on these days, as shown in the table. Day Store 1 Store 2 (Store 1-Store 2) Difference 1 2 3 4 5 6 7 8 9 10 11 12 397 297 345 375 365 168 290 270 812 731 869 975 ii. 848 980 220 692 498 823 668 469 605 14 670 370 100 -30 197 20 81 46 307 379 375 206 22 128 Based on these data, can the owner conclude, at the 0.10 level of significance, that the mean daily sales of Store 1 exceeds that of Store 2? Answer this question by performing a hypothesis test regarding #g, the population mean daily sales difference between the two stores. Assume that this population of differences is normally distributed. Use Excel to perform the hypothesis test. a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. c. Identify any critical value(s) and shade the critical region(s). Using the critical value method, should Ho be rejected at the a= 0.10 level of significance? Why or why not? ^ d. Choose an appropriate conclusion based on your decision in part d. i. The mean daily sales of Store 1 exceeds that of Store 2. There is not enough evidence to conclude that the mean daily sales of Store 1 exceeds that of Store 2
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Transcribed Image Text:AutoSave OFF
Home Insert Draw Design Layout
Paste
B I
vab
References
A^ A Aa v
A
As
A v Av
You can't make this change because the selection is locked.
18
W Using Excel for Hypothesis Testing with Two Means - Read-Only - Saved to my Mac
Mailings
=
Review
V
View
✓
1
2
3
4
5
6
7
8
9
i.
Tell me
10
11
12
ii.
A
3. (t Test (in Excel) for Two Paired Samples) The owner of a chain of mini-markets wants to compare the
sales performance of two of her stores, Store 1 and Store 2. Though the two stores have been comparable in
the past, the owner has made several improvements to Store 1 and wishes to see if the improvements have
made Store 1 more popular than Store 2. Sales can vary considerably depending on the day of the week and
the season of the year, so she decides to eliminate such effects by making sure to record each store's sales on
the same sample of days. After choosing a random sample of days, she records the sales (in dollars) for
each store on these days, as shown in the table.
Difference
Day Store 1 Store 2 (Store 1 - Store 2)
397
345
365
290
812
869
975
848
980
220
692
498
AaBb CcDdEe
297
375
168
270
731
823
668
469
605
14
670
370
100
-30
197
20
81
46
307
379
375
206
22
128
Normal
AaBb CcDdEe
No Spacing
Based on these data, can the owner conclude, at the 0.10 level of significance, that the mean daily sales of
Store 1 exceeds that of Store 2? Answer this question by performing a hypothesis test regarding μd, the
population mean daily sales difference between the two stores. Assume that this population of differences is
normally distributed. Use Excel to perform the hypothesis test.
a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper
notation and formatting.
b. Give the value of the test statistic. Round to three decimal places if needed.
d. Choose an appropriate conclusion based on your decision in part d.
The mean daily sales of Store 1 exceeds that of Store 2.
Aa BbCcDc AaBbCcDdEe AaBb AaBb CcDd Ee
Heading 1
Heading 2
Title
Subtitle
c. Identify any critical value(s) and shade the critical region(s). Using the critical value method, should Ho
be rejected at the a = 0.10 level of significance? Why or why not?
There is not enough evidence to conclude that the mean daily sales of Store 1 exceeds that of
Store 2.
Focus
Share
E
Styles
Pane
I
Viewing
Dictate
Comments
Editor
BOD
+ 100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman