 our squared, or this is going to be a calculation of the goals to this, squared difference from the mean. So this is going to be our squared difference from the mean, which you can look at either of these formulas. But if I'm looking up here, I'm going to get to the variance. I've got the numerator. So I'm got the 104 and then the count. So this is going to be the count, which is represented by n. That equals this number that we counted because we just counted 1234. And let's put an underline, home tab, font group and underline. And that's going to give us then, if we divide, it's going to give us the variance divide doesn't want to give me the divide, or I have to do it this do it this way and then divide. And then variance. Now, if I want to represent the variance with a with a symbol, I could use, I can format the cells one way we can do it or we can enter a symbol for it. So for example, if I was to enter a symbol and I go to the insert tab symbols, I would then go to the normal text, Greek and Gothic, and then you can look for it up top. I also have it down here in my recently used. So there's my Sigma insert. It needs to be squared. So I'm going to put a two and then select that to right click on it, format the cells, make it a subscript. And so now we've got a subscript of the two. I don't know why it's so large though, which is kind of odd. What happened in my two I have a huge number two. It's just the font size got ridiculously large for some reason. Whoops, let's make this a two and bring it down to I think it was 11 is the font 11 something like that. This font is 11. Number two needs to be at 11. Okay, alright, and then as so that's going to be equal to this over this 26. And then we're going to get the standard deviation standard deviation, which is represented by just a Sigma. So if I go into the insert symbols, and enter a Sigma insert. And so then we do that by taking the square root. So we're going to take the square root. And so that's going to be equal to this. Actually, you got to do a formula with that. So it's going to be the square root function, which equals sqrt square root of the 26 gets us to five. Now let's add a couple decimals. And you can see it's not exactly five. It's a 5.1. So it's a little bit higher, which is typically the case. When we use this method, as opposed to our simply intuitive method of just the average, the average deviation. So you get, you get a distinct number. And that's what that's another one of the properties that's that is different from the standard deviation than the average. So we might go into that in a little bit more in future presentations just to drill down on that point as to why another reason why we might use this number as opposed to doing a calculation like this. But for now, let's go ahead and make this blue and bordered home tab font group, making it blue and bordered. If you don't have that blue, it's in it's in the color wheel. There's the blue. And now, of course, we can also get to the shortcut there by using our Excel functions. So I can I can say this is going to be the population variance using Excel, right? And I'm going to say that let's make this cell a little bit larger. And this is going to be the same as this. So I'll copy that and put it here. So the formatting is there with it as well. And I could say this is going to be equal to the VA. And we're looking for these these two these two here VARP dot P VAR dot s, we're looking at the population right now. And we'll look at the very the sample in a second and more in a future future presentation. So if I if I select my data, then we get the 26 right same as this 26 up top. And let's go ahead and make this bracket and blue. And then I can take my my can calculate my population standard deviation. Let's make this one a little bit wider again so I can then copy my Sigma. It's going to be represented by Sigma. So this is going to be equal to ST. And once again, you've got the standard. It's these two we're looking at STD EV dot P dot s, we're looking at the population at this point. So I'm going to say dot P, select my data, and enter, let's add a couple decimals. And we get to the 5.1. Let's make this blue and bordered. Now just to compare that to the formulas, which we'll take a look at in more detail later, which is the sample variance and Excel. So that's going to be equal to the very the variance. So the variance, but let's look at the sample just to get the difference. And let's pick up the data. So if I use that calculation, I get 35 adding a couple decimals, we'll add some decimals here, it's even there. And then we're going to say if I took my sample standard deviation in Excel equals the standard deviation for the sample, then our data, we get something a little bit different. Right. So we'll talk more about that in future presentations, because we're focused on the population here. But let's make that yellow for now just to say that that's, that's a little bit different of the formula for the population. Okay, in a future presentation, we might dive into a little bit more on, on analyzing the difference between using this calculation and why this kind of more intuitive, possibly more intuitive calculation. Another reason why we might use it, use this one instead as the default, right?