 my data and When I click on this one, I'm gonna I'm gonna say edit this data and Because it's a scatter. I've got the X and the Y Notice it's picking the series name up from the feet. I'm not too worried about that I just want to switch the X and the Y's So this is so the X I want to be feet So I'm gonna click on this one delete what's in there and this gets a little finicky so be careful with it put my cursor in here control shift down and and Control backspace so I think that's picking it up I'm gonna say okay and then on the Y I'm gonna say this one and delete this stuff equals The inches control shift down control backspace and then okay So I think it flipped them now So it's picking up Right, right Okay, so say okay And obviously you have a very similar looking Chart, but it's not exactly the same right the feet are over here now You can see the feet going from up to eight and the inches going here up to 100 Again, you can add the trend line Which isn't much helpful here because you can see it's exactly a straight line But if we add it just for practice purposes We'll say bucket. I like to make it a straight line and Then bucket drop down and orange Sometimes it's it kind of lags when you Are working in the charts so be patient with Excel Don't get mad at Excel because then if you get mad at it It just closes up and stops responding altogether And you don't want Excel to get like that. Don't get don't make it get like that Okay, so then What we'll do then let's actually pull these over here To get them out of the way Pull them under here talvace Mui be to the end. That's perfect location for those charts Because they can really be pretty large and express themselves In a meaningful way without interfering with other Areas that also need to have their own space for self-expression Okay, so then Let's add then another column between the inches so and I'm I'm I'm gonna put I'm gonna put the Z scores related to it. So this is our actual data Not what we did before what we did before was then plot the normal distribution Now we're gonna do it the same similar kind of process with the actual data So let's I'm gonna put my cursor in column V and select the entire thing right click and insert Which will insert a column in the middle and then I'm gonna call this Z for the inches So these are my Z scores for my actual data so same calculation of the Z it's gonna be equal to brackets I'm gonna pick up that 16 Minus the mean for X which is over here So the mean for X was this one and then I'm gonna say F4 on the keyboard Making it absolute closing up the brackets and divided by the standard D the standard D Which is this one F4 and I think that's it we can say okay So let's let's go ahead and decimalize it home tab number group if you really want to know it You have to you have to look at the decimals You don't really know it until you until you get it get to see their decimals and then you can Understand the Z. All right. Anyways, we're gonna say there's that the feet and then this is the Z feet The Z feet that sounds like a funny name The Z feet sounds like the name of a punk band or a rock band or something Here come the Z feet Like a zebra foot is not a hoof that would be a hoof not a foot at all if it was a Z zebra foot Anyways, this is gonna be equal to well before I do that We're gonna say. Oh, no, that's right. Here we go. Here we go. Just stop talking about zebra hooves Get to business. This is gonna be one minus each data set minus the the mean For the feet now and then f4 in the keyboard making an absolute closing it up Divided by and then we're looking for standard deviation Standard deviation is that one f4 in the keyboard and that is it So I'm gonna say enter. Let's add some decimals home tab number decimalize it Okay, so there we have it and then I can copy that down double-click and copy that down So now we've taken we're basically Looking at our formula. We took each set of data for X and Y subtracted it from its perspective its perspective mean and then divided it by the The standard deviation which is the Z score for the X's and Y's so now we need to basically sum all that up Multiply it together, you know and divide by the n minus one. So let's do that this way. I'm gonna do it Sum it up here. I'm gonna say this is Z inches times I'll do that with the asterisks Z feet Z it sounds like a French guy saying it it's the inches times Z feet I Don't know. I don't know many I don't know French too well, but I would like to learn I've been anyway So we're gonna multiply this out. This is gonna be Z inches times Z feet and Then we're gonna say that's the best I can do for a French accent. It's probably horrible. I have I don't have much reference here home tab I watched the pink panther When I was a child the detective where the Accent anyways, let's add some decimals here and then we'll multiple copy of this down and then Now so now we have that so let's make a skinny Z a skinny Z For Z column All right, stop that Stop with the accent. It's horrible People have turned off the video. They went to the next lecture and they're not even gonna know what to do Because they just wanted to hear you shut up Okay, here we go We're gonna sum up Sum up the Inches times Actually, I could do this with a formula just to make it fancy if I want to put this in here So I can change it I can say equals and then I'm gonna say brackets I'm gonna say it's the sum in the brackets. That's the text and then tie it to what's in this cell and then say it's gonna be the sum of Z inches and Z feet I probably should put a space in there too or maybe like another bracket and a space bracket And I got to tie that in with it and So you can get kind of fancy with that if you want to kind of copy your worksheets over But I'll put that in the outer column equals the sum of This column control shift down So we just summed that up and Then I can I'm gonna take the rest of my formula is I divide it So I did this whole top bit now divided by n minus one So I'm gonna say here in minus one colon let's make a small in minus one colon So I'm gonna say this is gonna be in Just in just in not minus not minus one Stop trying to figure out what I'm trying to do it So you don't know what I'm doing. I'm too complex. My mind is too complex for you to try to read it So we're gonna say this is count Just cuz you got some AI going here Control shift down Think you can read my mind. You ain't no human being. You're not you're not a human being less Yeah, you don't know what I'm thinking not even human beings know what I'm thinking less one Okay, calm down Excel wasn't trying to be offensive