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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!