 do. Let's decimalize it to see if we can get a little bit more understanding about it. You've got to think about it with a little bit. You're just covering the surface and we need to get a little bit in-depth understanding about the psychological psychology of the mean right there and get into the mean's head. This is going to be the standard deviation s for the sample. Remember it's dot s this time we're working on the dot s is not the dot p's and this is going to be for the distance traveled control shift down enter so there's our standard d let's decimalize it home tab number group decimalize and let's do the same thing for the for the distance remaining equals I could copy that over the other cell but I'm going to do it again just so we can do it again average just because it's good times average tab picking up the distance remaining control shift down and enter decimalizing it home tab number group decimalize and then equals the standard deviation s for the sample as opposed to p for the population distance remaining control shift down and enter and decimalize home tab number group decimalizing it all right now we might we might then create a chart from it like we did before we might say well what does this thing look like if I just looked at them one at a time control shift down control backspace we get back out to where we're looking insert tab let's just look at a histogram and see what that looks like let's make a histogram boom what does that do what's that looking like and this is going to be a distance traveled okay and notice it should it's if we had a whole lot of datasets this will conform not to what we saw before which looked more like a bell curve but it's going to conform more to a uniform uh distribution because if we had a bunch of random numbers it's they should all be coming up somewhat evenly if we did it onto infinity right so even though we have a different kind of it's gravitating towards a nor a different kind of standard distribution or a curve if a line was to represent that it would be the uniform distribution as opposed to like a bell curve it's still going to have the correlation here which is going to be a perfect negative correlation in this case between that data set and this data set which will also have kind of a uniform distribution so I'm going to say control shift down and say insert and say let's go to the charts and make well before I do that let's go here and control shift or control backspace so I can put it where I want to put it and then insert charts make a histogram again and then this one is going to be for did okay now I can't see what I'm typing distance remaining okay so it also looks like somewhat of a uniform distribution they're not exactly the same but they both look like they're going to do this that they might conform to a similar type of curve which again would be an indication that there might be some you know relationship between them if this one looked like a bell curve you know it was more in the middle and tapered off to the sides and this one looked more like a uniform distribution that might be an indication you're not going to find a real relationship in terms of the correlations for example so we'll then say okay well let's just copy this I'm not going to make like a uniform distribution like we did last time with the bell curve I'm just going to say let's do the correlation calculation so we'll say here's our formula that we'll be working with now also before I do that just note that we might then just plot this and say if I select these two and say control shift down and control backspace I might say well let's plot these together which would be the next logical thing to do and I can say let's insert and we're going to go to the charts and we want to do this dots so scatter plot and it's like wow that's correlated all right it's a perfect negative correlation it looks like now I'm going to do the same thing we did before and that I'm going to remove the title because what I really want to know is where the x and y's are on the chart so the whenever we do these charts the one on the left is always going to be the x so I always think of x first so if I was to say plus over here add the axis titles this I can click on the axis title and say equals and I can point to the first one which is going to be the default x and enter and it'll do it with a formula there it is in the formula bar up top I can do it over here equals and this is going to be the distance remaining and enter so there we have that one obviously we don't really need a trend line because they all the dots are falling on a line but if I later on will enter the trend lines here so let's just practice doing that and more options on the trend line I'm going to go to the bucket and I like to make the line like solid like thing I like things to be solid man it's a solid line and then there we have it okay and then so there we have it now notice that normally we have the independent variable on the x but we might not know which one is the independent variable it might be useful to plot it the other way so we have the distance remaining on the x so you can see it either way the relationship is still there either way so so we so you could do it the other way let's just practice that now the easiest way to do that would be to actually reverse the columns to have the distance remaining on the left but you might have this in a larger data set or something like that you don't want to do that so let's just do the same thing and then we'll then we'll change we'll change the relationship afterwards so we'll select the data insert and then we're going to go into charts scatter plot and there it is there's the same thing but this time deleting the title adding the data labels I want the axes this time the x axis I want it to be equal to the distance remaining and I want this axis to be equal to the distance traveled now it's current currently reversed so we need so in order to flip them I select the data chart design up top data area or group select the data and then I'm going to go into my distance remaining edit it and then here we have it we're going to I'm going to leave the name alone x series I want to change that it's currently picking up the one on the left I want it to pick up the one on the right so I'm going to delete it put my cursor in the six control shift down control backspace back up to the top close it and I think that's good now the second one selecting it delete it be careful because it gets a little finicky excel gets a little tricky here sometimes and then this is going to be the one that we want on the y which is going to be uh the one we want on the y is going to be this one now control shift down and control backspace and there we have it so now we've got they're flipped I think I hopefully I got them flipped okay it looks quite similar because of the nature of our graph here and so I'll say okay so you can see it's still negatively trending uh so it looks it looks very similar but we flipped the axis so it's not like you might think at first that it would flip to be like if you flip the axes that it would flip to be like a perfectly positive correlated no it's still perfectly negatively correlated a downward sloping line uh and if I added my trend line I could say more options and let's put a line in here let's make it a solid line and let's make it orange orange orange you glad that I added the trend line because I would have no idea how close that was to a line