Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a) Conduct a two sample T-test to see if the average number of units sold is the same or different for the South and North
a) Conduct a two sample T-test to see if the average number of units sold is the same or different for the South and North Regions.
b) Is there a difference between the two regions for units sold? How do you know?
Can this please be done in excel. Thank you.
Store and Regional Sales Database | ||
Sales Region | Units Sold | Week Ending |
South | 28 | October |
South | 30 | November |
South | 9 | December |
South | 30 | October |
South | 35 | November |
South | 39 | December |
South | 28 | October |
South | 3 | November |
South | 38 | December |
South | 25 | October |
South | 27 | November |
South | 33 | December |
South | 8 | October |
South | 8 | November |
South | 10 | December |
South | 8 | October |
South | 8 | November |
South | 8 | December |
South | 9 | October |
South | 9 | November |
South | 8 | December |
South | 18 | October |
South | 18 | November |
South | 20 | December |
South | 38 | October |
South | 30 | November |
South | 3 | December |
South | 30 | October |
South | 32 | November |
South | 33 | December |
South | 25 | October |
South | 5 | November |
South | 26 | December |
South | 28 | October |
South | 27 | November |
South | 29 | December |
North | 18 | October |
North | 20 | November |
North | 4 | December |
North | 12 | October |
North | 24 | November |
North | 36 | December |
North | 29 | October |
North | 11 | November |
North | 38 | December |
North | 21 | October |
North | 24 | November |
North | 30 | December |
North | 27 | October |
North | 25 | November |
North | 23 | December |
North | 80 | October |
North | 82 | November |
North | 75 | December |
North | 65 | October |
North | 24 | November |
North | 55 | December |
North | 55 | October |
North | 57 | November |
North | 47 | December |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started