Answered step by step
Verified Expert Solution
Link Copied!

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.
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 image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Alaskas Permanent Fund Dividend Examining Its Suitability As A Model

Authors: K. Widerquist, M. Howard

2nd Edition

0230112072, 9780230112070

More Books

Students also viewed these Accounting questions

Question

What is IBMs Lets Put Smart To Work strategy?P-968

Answered: 1 week ago

Question

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago