 on the whole numbers. Now my format appears in a number generation because when I generate these it puts it back into the general. So I kind of, so well let's keep it like that. We'll keep it like that. I'm just going to double click it down and boom, brings it on down. So what happened to this one? Oh it's a negative interesting because it was a bell curve so we had a negative number. Okay so there we have it. Now if I convert to feet let's convert it to feet and we're gonna say okay font group black white center so feet would be inches divided by 12. That's how we do things over here in America we use this weird you divide it by 12 like 12 that's so sloppy like why don't you use a unit of measure based on 10 you know that would make sense whatever whatever this is how we do things home tab number group tell me don't tell me get the king of England over here trying to tell me that I have to or we measure actually we got our measurements from the king of the king of England's foot I think is how we anyways whatever that's how it is so I'm gonna close this up and then we're gonna say all right then all right let's make a skinny G skinny G skinny skinny G and then we're gonna say inches let's say I'm gonna say this is gonna be equal the inches again rounded and then the feet and I'll just copy the format painter this time home tab clipboard format painter boom alright let's make it let's make the mean mean it's gonna be equal to we'll say average tab going on over to the inches and control shift down taking the average of it we can add some decimals decimalizing it home tab number group decimalize and then we're gonna say this is the feet equals average decimalize isn't a word by the way but I'm making it into a word control shift down I think it will be a word once I have shown its utility in practice decimalize alright then we're gonna say this is gonna be standard deviation equals the standard deviation we're look we're moving to the sample this time so s not the population standard deviation of the sample tab I'm gonna say control shift down picking that up boom decimalize and that one home tab number decimalize so we could really recognize you can't recognize how they really are unless you can see the decimals you need to see the decimals you need to get under the hood before you know who they really are home tab number group decimalize okay so so so now when I compare these two obviously I can look at the difference now the difference and I could say alright well what if I was to like look at these two this way I could look at the difference in the mean and the difference in the standard deviation but that doesn't tell me too much right because home tab number group because they're in different units so doesn't that doesn't really help me but I could compare like there's z scores so that's one thing I can do I can compare and that's how our correlation will basically work before we do that however let's first let's first imagine that we're gonna say hey that this set of data looks like it might look like a bell curve like if I select this data I'm gonna go hmm is there a relationship with this data if I select all this data control backspace and then go insert and make a histogram from it here's my histogram based on inches so this is the inches histogram and why is it not when I type you do something that's how computers work computer don't you start protesting on me you know I was typing something so and if I do the same thing for the feet control shift down backspace control backspace and insert and then boom and then this is gonna be feet okay so I can see there's kind of a relationship right I can say those look kind of similar but I can't really compare that center point of course because they're in different units but it's like okay well they both look similar they both look like they conform possibly to a bell curve relationship so maybe I would maybe I'd compare the bell curve just to play with the bell curve before we get into the correlation here and then so I'll do that because that'll be fun muy divertido muy divertido okay so this is gonna be then let's say we'll take this standard deviation let's take four standard deviation so if I'm gonna do this bell curve thing what I want to do is plot out the bell curve X for inches and then P of X and then we'll do the Z as well and then we'll do the same thing for X for feet and then P of X and then we'll do the Z for feet this will be the Z for inches all right but I need to know how far I need to go where do I need to start at with my X's so I can say we'll do the four standard deviations as we saw in a prior unit because that'll encompass the vast vast majority of the data so I'm gonna say four standard deviations and let's say that we go upper X and lower X so I'm gonna put them I'll keep the same headers here inches and feet this time so the upper X is gonna be equal to the mean plus the standard deviation times four that's as high as we that's how far up we're gonna go and the lower I wait I usually do the lower first don't I let's do the lower lower X and then the upper X so let's be consistent if you would otherwise you confuse people times this no it's minus minus this times four okay so that makes sense so we're taking the 16.29 times four standard deviations minus the center point the mean alright so negative 30 and then this one is going to be equal to the upper which is going to be the center point of the mean plus the standard