Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using PivotTables, find the mean and standard deviation of sales by region in the data provided. Complete the table below. (Type integers or decimals rounded
Using PivotTables, find the mean and standard deviation of sales by region in the data provided.
Sales Data Product Region East Book Book North South DVD West Book Book East East East West West West South North South West West East West West North West Amount $20.31 $16.66 $20.33 $24.71 $15.71 $15.45 $17.38 $20.82 $19.20 $22.92 $19.69 $17.51 $24.45 $15.18 $23.75 $22.64 $20.42 $242.40 $18.92 $15.18 DVD Book DVD DVD Book DVD Book Book DVD DVD Book Book Book Book DVD Complete the table below.
(Type integers or decimals rounded to two decimal places as needed.)
Average of Amount
StdDev of Amount
East. [ ] [ ]
North [ ] [ ]
South [ ] [ ]
West [ ] [ ]
Grand Total [ ] [ ]
data in picture
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