00:01
All right, so for this problem, we're asked to use pivot data, pardon me, pivot tables to find the mean and standard deviation of sales by region in the data provided.
00:12
So i have all of the data copied down here.
00:16
I had to use an image to excel table tool, so i'm just looking over this to make sure there are no typos or no misreads.
00:24
Looks all good.
00:25
So i'm going to select the data, go to insert pivot table, on a new word.
00:30
And now what we want to do is we want the region to give us our rows.
00:39
So as we would hope for, we have east, north, south, and west as our rows.
00:44
Then we know that we want to have the information about the values, or pardon me, the amount.
00:52
So we'll bring down the amount there or sum of amount.
00:56
But that's not actually what we're interested in.
00:59
In fact, what we're interested in, what we're interested in is the average as well as the standard deviation.
01:09
So there are two different ways to do this, but i'll just show it this way.
01:13
So we'll click on the right on the arrow to the right of sum of amount.
01:17
Go to value field settings.
01:19
And you can see that we have a few different options here...