 because then you'd have to get into the analysis part of it. This is just looking at the relationship of the data. But if I was to guess, if you'd come up with a hypothesis, you might say, well, maybe these cars are being driven on the road where there's a lot of stop and go on the freeway and whatnot, where higher horsepower cars are not going to be quite as efficient. So if you're driving a really high horsepower car around here in this range, not on the freeway, but stop and go traffic, you're probably going to be much less efficient at how far you're going to go. But maybe if people have really super sports power, very cars, they only drive them when they can actually go at a decent speed and not stop and go. In that case, maybe the horsepower wouldn't be such a bad issue. It's usually the stop and go. But that's just a guess. Then you can get into the analysis on what's the cause. Now, note that if you wanted to make the same graph and say, Hey, look, I don't want to pull the data over. I want to just make it from this data set. So I can, I can select the data this way. I can go to the horsepower and I can go to the miles per gallon, right? I could select these two data sets. And so I've got them selected all the way down. I noticed this one is selected. I just want the data in the table. So sometimes that could be a little bit difficult to do. I could say I want, then let's try the keyboard method. One way you could do this by the way, you can select the whole thing and drag all the way down like this just to make sure you're getting the whole data set and not going like to the whole column. And then you hold control down and then I can put my cursor here and I can select these non adjacent columns and select them. So that's the most intuitive way. You still need the keyboard to do it. And then you can insert that way. Another way you might try is you could put your cursor. Let's say I put my cursor here and I use the keyboard holding down control and shift and then down arrow. This usually takes you to the bottom of the data set, but because I'm scrolling down, that you have these blank spots here, it didn't take me all the way to the bottom. It got stopped at the blank. So I'm going to do it again, control shift down, control shift down until I get to the bottom of the data. And that's why those blank spots are problematic in a data set. And then to get back up to the top, I'm going to hold down control in the backspace. Now I'm back up at the top. I'm going to hold down control to get back to the miles per gallon. So now I have two non adjacent cells selected. Now I'm holding control shift again and the down arrow. So now it's selected the whole data down to here. Now I don't want to be at the bottom when I insert the scatter plot or else it's going to insert it way down here at 395. So I want to hold down control backspace, taking me back up to the top. All right. So now let's do it again. I'm going to go to the insert tab. We're going to go to the charts and let's do another scatter plot, not that one, this one, inserting it. And then so there we have created it again. So boom. And there we have it. And actually selected, I believe going the so well, no, it's opposite now. See now you've got now you've got the horsepower over here. And I'd like to switch the the the rows, right? Because and why did it do that? Because I had the miles per gallon on the left. So I want to switch now the X and Ys. So there's a shortcut kind of thing up top. So if I go into here and I go into the data, it's got this switch right there. But it's not letting me do it because of the maximum number of data series. So I'm just going to do it manually. I'm going to go in and say, All right, let's go to the data data. And I'm going to look at the data in the edit. And now you can see your X and Y data. So here's your X data. If I click in it, it's the miles per gallon. I want it to be the horsepower. So I'm going to delete what's in there. You could put an equals and then select the item or you can select this thing. And then click over here where you want it to go. I'm going to try to select the data, putting my cursor where I have the arrow drop down. So it selects that data set. And then I'm going to select this again. And that'll allow me to see the whole box. And then in the Y, I'm going to do the same thing, delete the Y and then click this item to select the series I want, which is going to be the miles per gallon. I'm going to put my cursor where I hear see that arrow, select. And then there we have it. I'll click this again. So now I've switched the X and the Y. I can say okay. And okay. So now we have the same basic scatter plot. And what we would typically want to do is hit the plus button. And we're going to say title axisies. I'll do this quicker because we've seen this before. This is going to be equal to the horsepower. So I'm going to do it this way this time. I'm going to say equals horsepower. You could see the the table up top. So now if I change the headers, it'll change automatically. Axis title down here is is I'm sorry that was the wrong one. Wait a second. This one should be the miles per gallon. And this one should be the horsepower. Now I lost that one. This one should be equal to the power of the horse. The power of the horse. And then of course we can add our regression line in the same fashion adding the trend line. And then I want to look at linear more options. But I can go to I can add the equation if I want. Boom. The bucket. And then I'd like to make it a line and red. You also have this glowing this glow thing over here that I think I put on the example if you wanted to go into here they've got some neat kind of shade. And then the glow is kind of interesting. So they've got these default glow settings. So then if you wanted that dotted line that's not so pronounced so that you could still see the other dots in there maybe instead of a linear but then you add that glow to it then that lets it let's it stand out or maybe you have just a blue line with a bit of a glow to it so it kind of stands out but doesn't cover anything else up. All right let's do the same thing comparing now miles per gallon as I'm going to make a skinny J put in my curse between J I and J or skinny I. And so there we have it a skinny I because I want to be skinny. And so I'm going to say and then we're going to say let's do the same for the miles per gallon as the independent variable the x axis and the acceleration. So I'm going to do this one faster. So I'm just going to take this whole column right click and copy. And the easy way to do this is we're just going to put our columns of data side by side over here. I'm just going to right click and paste. So there's our miles per gallon and then acceleration. So I'm going to put my cursor here right click and copy and put my cursor in Z right click and paste. Okay and then I'm going to select the entire thing putting my cursor in here insert. I'm going to go to the tables tab insert a table and say okay. So it looks like it got the table all the way down looks like properly allocated table I can sort now by miles per gallon Z to A or A to Z Z to A Z to A and I can sort this way as well. And now if I want to insert a scatter I could select this whole thing maybe I want the titles in there too if I scroll down you got to be careful that it doesn't select the entire thing so sometimes it might be easier to like select these two control shift.