 We'll say this one is they're going to be the quartile. This one needs another argument a comma and we'll put a one next to it quartile one and Then this is the median which could be quartile two formula or the median for function tab Selecting the data. There's the median and then equals quartile Number three selecting the data this needing another argument therefore a comma and Quartile number three the three next to it and then the max when we maxed out on the calories so the max Selecting the hold on a sec Something happened. This is the max and I got a hit shift nine I could do that to get my function ready to roll and then select in my data So that's when we ate a whole bunch of calories apparently. I don't know I was just drinking drinking bacon fat or something Anyway, then we have the standard deviation on this one equals the Standard and we're looking at the population data at this point. Let's take the standard deviation for the population P and select that and then this will be equal to the stand the variance for the population and We'll pick up that. Let's just do the same thing for the samples Just to pick those up if it were a sample standard deviation Sam and variants variants for the Sam and This is going to be equal to the standard deviation for a sample and This will be equal to the standard deviation For a I'm sorry, this will be equal to the variance Variants for a sample the AR dot s Okay, so there's all the stats that I get them right this time. These are the population population this is for a sample Versus a sample if I look at this one by the way home tab number group And I add some decimals just to see Some a little bit of a differentiation between the two calculations. Alright, let's put some blue borders around this I'm going to select our data and we'll go to the insert tab fonts group hit the bucket drop down if you don't have that blue it's in the more color in the wheel standard side and hitting that wheel and Okay, and then we'll go to the font drop down put some borders around this whole thing Let's let's put a histogram in it now. So let's take our data the calorie data Insert tab up top charts and hit the drop down, but not too hard. Don't break it and then go to the histogram So there we have it So there's our data. It's fairly fairly centered data a little bit, you know skewed to the right here But there's our pictorial format of the data And so now let's do our standard deviation calculation using and our variants using like a table format So we get an idea of what's actually happening with those because they're a bit more complex calculations. So we've got the variants there There oh, hold on a sec variant now. I hit the cap lock variants and I'm going to copy my formula over here So there's the formula. I'll bring it down to like 12 on the font. Let's do 12 font Now you can type in that formula remember with the inserts tab hitting that any equation and then I would use the ink Thing so that you can actually kind of type it in here or hand write it in here Not type it in here. That's the point and it'll start to do your formula up top So I'm going to make this one orange as Well and we'll make this black and white up top for the header black and white Okay, and then we're going to say this is going to be the standard Deviation Form you lie And we'll put that in place making that 12 on the font as well Orange in it making it orange. That is that's what we do. That's what orange in it means when we orange it and so there it is okay, so We can see that these two are related of course because this this whole bit here for the variants Sigma squared is the same thing as what's under Here on the standard deviation and then we're going to take the square root of it to get the standard deviation So let's do that calculation on more of a manual method Which although there's a whole lot of data points here is still pretty easy to do So let's just copy this whole thing I'm going to copy from column a to column b selecting those two columns right-clicking and copy and Let's put them on over here in column R. R and s are So we're going to say control V or just paste it. Let's make a skinny queue column skinny queue and Then we'll just do our standard kind of thing here. So here's all of our Individual points represented by X X I so we're going to go from one all the way up to however many of them There are and of them that is so we're going to say this is going to be the mean So we're going to compare all of them to the mean and If you're if you're over the mean We're going to be mean about it and say that you're getting fat because you're over because you have You have more calories than the mean