00:01
Okay, so for this problem, it was asking to find the, so part a was to find the mean advertising spent for each sector.
00:10
Round your answers to two decimal places for both the automated in the department store, and it wanted you to use the excel spreadsheet.
00:21
And so to find the mean, what you do is you go to the auto sum and you click on average.
00:30
And then you drag your mouse up or down, whatever column that you're finding the average of, you hit enter.
00:38
And then if you just put your mouse right here with that little boxes, and then you drag it over to the right and then hit enter, it also will find the mean for the column that's right next to it.
00:52
I just want to change this color back to blue.
00:56
And so i have the mean for the automotive and the in the mean for the department store column.
01:05
Then it wants the standard deviation.
01:07
And to find the standard deviation, what you have to do is you click this down arrow and you go to more functions.
01:14
And the standard deviation is this st -d -e -v -s.
01:20
So if i go to show all functions and i start talking about.
01:26
Typing in for standard deviation, these pop up.
01:30
You can use the first one.
01:32
So you click on that and then you insert the function...
