 and then this is going to be in space space this is going to be uh this is going to be less one and this is going to be n minus one so n is going to be the count so we'll say equals count brackets and then i'll count these oh hold on a second so we'll just count those meaning there's one two three four five six rows less one let's put an underline here for formatting sakes for formatting sake can't for formatting sake this is going to be six minus one or five let's put an underline under it for formatting sake and then let's indent these for fancy formatting sake home tab alignment indent home tab alignment indent and this is going to be the r correlation which will be equal to the zero over the five which is of course zero even if we decimalize it so that's the point that we want to get to we're like okay wait a second it comes out to a correlation of zero which would mean zero correlation but when you look at it intuitively we probably want to say well it looks like these two things are moving together quite consistently until of course that last point and that's where we have to we can't that's where we have to say we can't just rely on any one statistics oftentimes uh because we have to we have to then look at it from different angles so if we were to look at this in different angles we would say i don't know if that's telling me the whole story about the correlation or relationship between these data points given the fact that this outliers throwing everything off obviously if i remove the outlier they would be perfectly correlated right so and that's just the the the beware story let's go ahead and and plot this thing out if i grab this and i go into my insert up top and we go into the charts and we do a scatter plot you can see what's happening here so we can see uh what is happening uh hold on a sec i think i messed it up you messed it up okay i didn't want to grab that excel you know what i'm doing stop being stupid oh okay so let's get rid of this and then let's label this thing plus button here axis titles starting with the x which is always the left data by default so there's the x and then the y which is equal to the y now remember that here we know i don't know if there's a causal factor or anything because we have random data that is happening uh here so we're just looking if there's a mathematical relationship between them and we wouldn't really know you know which data set should be on the x versus the y you can plot it either way but usually the independent variable we think about on uh the x but if i plot this out if you look at it we're now saying hmm that looks like a straight line that looks like a perfect kind of correlation but if you add the this one out here mathematically our correlation calculation comes out to zero correlation even though there's just a clearly a fundamental relationship between these lines so if this was a real data set in real life would we really want to say that there's no relationship between these two data sets probably not there's probably something going on with this one data point that messed everything up there's you know so that's why again anything we're looking at with statistics we can't really look at it just from one angle typically we want to look at it from pictorial standpoints uh data standpoint analysis and other things and this is what often people frustrate it frustrates people with statistics because they say well that makes it confusing and you can't really nail anything down that way and whatnot because people can lie about it and stuff but again that's the same with words like anything that you communicate with it's the same people say stuff and you can't just listen to what they say because a lot of people don't say what the what the truth or or even if they're trying to say the truth it may not be right so you have to kind of dig down and that's just the way to it so in any case if i add a trend line over here you can see it's a perfectly straight line it's like what because it should you would think it would be uh there'd be some kind of relationship but no and then i'm going to hit the drop-down