Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
