 formula it's a main formula we're gonna say control shift down for ran data one enter 49 let's add some decimals to get a little bit more precise home tab number group decimalize in it and then let's do the same thing this time let's just copy it over if I just copy it over like so double click on it to double check it and it is picking up the correct data there so that looks good let's do the standard deviation from the sample standard deviation for the sstd ev dot s sample tab selecting the data control shift down for ran one data and enter decimalizing home tab number group decimalize copying it to the right so we do the same thing for ran data set number two so there it is double click double check and it's done what what it needs to do all right note we could look at this and say what if I made a histogram of this data sets to see if they look similar so I could say control shift down and then control backspace insert and let's go to the charts and let's make a histogram of this histogram for ran data set number one looks like this randomly generated buckets this is going to be for ran one so it made our buckets and it listed the numbers that are how many times we had a number between 1 and 18 1835 3552 and if we were to approximate this with some kind of curve or formula it's going to approximate a straight line because this is going to go towards a uniform distribution because we chose randomly generated numbers so let's let's do it as opposed to a bell shape distribution right it's more of like it's going to go towards as we have more data it's going to tend towards a uniform distribution or straight line let's go to the the ran to and do the same thing selecting all this data can and I had control backspace and then insert chart histogram boom next one and this is going to be ran to so it looks very similar see so see you'd say okay look this one looks like it's going to be a uniform kind of distribution too it's got kind of a little bit unusual look here that you know it's tapered off a lot on the 97 to 113 which is interesting but it should still be because we use we use randomly generated numbers the more numbers that we produce it would tend towards a straight line so they look kind of similar like that but still you would think they might not have a correlation because there's there there's or at least not a high correlation because there's nothing really tying these two together other than the randomly generated from 1 to 100 so let's let's say okay let's make this one a little bit larger let's make this cell a little larger and I'll make this one smaller so it fits in there fits in the spot there put everything in its place it needs to go where it needs to go and then I can choose these two control shift down and control backspace and do a scatter plot between them insert charts let's do a scatter plot boom looks like that so now we're scattering these I'm gonna delete the top one and this is the random numbers and so now I'm gonna say let's hit the plus button up top and label them so I'm gonna put the axis labels and by default if I go to the first let's go to the x-axis first I usually think about that first the x-axis is the one on the left so this is the random one data the y-axis is the one on the right so this is equal to the random two data so there's our there's our correlation and you could see if I was to try to draw a regression line between them or in here we could say plus button trend line and you could see it's it's got a low negative correlation to it so I can say if I add my formula there's the formula for the line and then I can say let's make sure I'm back on the trend line I'm gonna say plus trend line options I'm bucket I like to make my line solid and orange solid orange line that's solid man that's solid so there we have it so you can see it's has a low you know negative correlation for the two that have been randomly generated between one and a hundred now you could also say well what if I wanted to put because we might not know of course what's we don't we don't know what the causal factor would be which should be on the x and which should be on the y because really they're not related other than picking random numbers between one and a hundred so if I select these two and control back and I want to put ran two on the x-axis I can go to the insert I can go into the charts scatter plot scatter there's a scattered plot out there and to do something we're gonna say plus button let's do the axis titles this time I want the x-axis to be ran two and I want the y-axis to be the ran one which is backwards because by default excel will always plot the one on the left on the x so how can I switch the two if I don't want to rearrange the actual columns we can go into the chart design the data we can go into our ran data and edit it and then this is the x values I'm gonna delete these and say that delete that and this was ran one we want to be ran to info yo and then okay and then this one I'm gonna delete that and say this needs to be the data for the ran one so we switched the x's and the y's hopefully if I did that properly and so I'm gonna say okay and okay and so now we've got our scatter plot which looks very similar still negative negative well that's the wrong one negatively correlates put that right backward goes and then it's still gonna be negatively correlated so if I add the trend line trend line