 negatively correlated so it's not like it flipped to a positive correlation and then hitting the arrow we're gonna say let's make the trend line solid and let's make it orange so clearly in this example unlike the hens and the eggs example we saw last time we can see that there's a mathematical correlation no matter which one we I mean there's a low you know correlation it doesn't look like it's very correlated but if there was any mathematical correlation then we can kind of determine that with the trend line but we have we don't really have any idea what the cause and effect relationship would be at at this point if there was any because with the hands it seems pretty clear that you could say well the hens are causing you know the eggs I would think the hens would be on the X but you can plot it either way and you're still gonna get if there is a correlation that's directional correlation of a negative correlation sloping down positives correlation sloping up okay so there is that so now what we want to do is is compare that let's compare that to to a system just to see what people normally think of when they think of random numbers this is way too like clumped up for most people when they actually try to generate random numbers so so let's add another data set what which would be closer to what people would actually kind of do when they when they try to set up random numbers I'm gonna set one set two so let's say set one and then set two and what I'm gonna do is I'm just going to say I'm just gonna space everything out by five so I'm gonna say this is gonna be let's do it this is gonna be equal well let's just do it this way we'll say five ten I'm gonna bring that up to 100 and we'll stop it at 100 do like that and then I'm just gonna copy that and repeat it multiple times so I'm just gonna copy this and paste it and paste it now these are in the way now get out of my way and then paste it and paste it and paste it and paste it and paste it I'm going up to like 215 is what we had before 200 and paste it to 215 or 16 right there let's delete these and then what I'm gonna do is I'm gonna do the same thing but I'm gonna just have it off a little bit so I'll start this one like at the 30 so I'll paste it I'll paste it here I'll copy the same thing five to five ten fifteen twenty twenty five to a hundred so we'll copy that but I'll start it let's start at 35 I'll paste it here paste paste paste paste paste paste paste paste paste paste and then I'll copy this last bit copy and that should fit basically up top here not exactly but I'll keep I'll do it that's fine I'll do that here so there we have it so there's our numbers now obviously most people when they pick random numbers they wouldn't just count by five but they tend to space things out so for example if I add another column I'm gonna put my cursor on column K right click and insert and then I'll make this a skinnier column and I'm just gonna say this is gonna be my random numbers for one and then I'm gonna insert over here insert this is gonna be a random for two and I'm just gonna generate random numbers this time equals random and this is gonna be just random not between and that'll give us a long decimal format home tab number it's gonna be a long decimal formatted number I'm gonna double click that down taking it all the way down I'm gonna copy that and put that over here control paste and double click copy and it down so now we've got this random number generator now I'm gonna now I want to put a space between these two I want to put a column between them and then I'm gonna make two different tables for random one and random set two so I'm gonna select column M I'm gonna right click and insert so now we have a spacer between these two then I'm gonna insert a table for both of them let me just scroll down and make sure I have everything done correctly if notice I have too many cells on this side I should have brought it down to 216 so so I'm gonna delete this last little bit before I insert the table deleting that and then I'm gonna scroll up top put my cursor here and go to the insert and let's insert a table so we'll insert a table dataset one and this side I'll do the same home tab I'm not insert tab tables insert a table for the second data set alright so now I can shuffle these so I'm gonna shuffle them randomly so now I took my number that had a pattern and I shuffle them over here and I shuffle them these ones as well and this is similar this is more like what people would probably kind of come up with they wouldn't always end with a five but if you were thinking about coming up with random numbers people would be like I have five and then like 45 is like away from that and then like 30 is pretty far away from the 45 and 85 you wouldn't really think to do another 45 right here or something right next to it right people will usually kind of space everything out is what the point is so let's copy these two so it doesn't keep on shuffling I'm gonna put my cursor on column L put my cursor on column O as I hold control so I have non-adjacent cells and I'm gonna copy right click and copy let's put that in column Q right click and paste just one two three just the value so it doesn't keep shuffling and then I'm gonna make a skinny pee column let's make this the header by going to the home tab font group black white let's center it and then let's just select this data I'm gonna say control shift down control backspace and then insert and charts and let's make a scatter chart of this information and so now you have this information that hold on a second that a lot of people would say well that looks random because it's nice and spaced out but the point is that this is not exactly random it's this is this is going to be what it looks like when it's random where you have all these clumpings that happen more often so this clumpiness isn't a sign of unrandomness oftentimes if you see something that's too uniformly distributed like this it's likely that there's not randomness in it now whether it be random or not however we're looking at the correlation between the two we between the two data sets so we'll continue on next time and we and neither of these data sets are really exactly connected to the other the first one we selected to completely random data sets and the second one we had kind of a system and there's a pattern to the two data sets that we used and then we shuffled them but again they're not really connected together so you would think the correlation would be similarly low so in other words if I hit the plus button here and add the trend line you've got a very low correlation I'm gonna say more options trend line and let's make it solid and orange we could still even though there's a low correlation we could still make it a trendy line by making it dressing it up properly so it looks appropriately dressed for the occasion so anyways next time we'll go in and we'll do the the formal calculations continuing on with the practice problem