 In this video tutorial, we're going to show you how to make a very nice scatter plot in Microsoft Excel. We'll even include a trend line for you. Let's look at our data. There we go. Here's our data. Before we learned how to do the correlation coefficient, which was 0.80 approximately. First, you have to highlight all the data, the x and the y. It's all highlighted. You're going to be inserting a chart. Go to Insert, okay, and you can see all the charts that are available to you. Make sure you click on All Charts, you can see everything. The one you want is called the XY Scatter. That's a scatter plot, and it's an x and a y. You see it already. Say okay. Right next to it, you can put it on a different page. You've got the scatter plot, and you can see all your points are here. You should actually count it, make sure you get everything here. But you can see some of the key points. Here's the person, that was the one whose performance was a 1. See the person with a 1 whose high school average was 60. That was the lowest high school average. Look at the person up here with the highest performance of 10, and that's the person with a 97.5 average. See the person with 97.5 and a 10 performance? This point, every point is accounted for. Now you have what's called a scatter plot. This is a researcher looking at this scatter plot, would say, hey, this looks like a positive linear trend. Which isn't that surprising when you saw the correlation coefficient of 0.8. Yeah, it's positive and it's a strong linear trend. Notice, now let's say you want to draw a line through this, the best line. We'll learn about regression lines later in the course. Easy schmeezy. You cook on any point. See, once you have that symbol on each point, you need to get all the points accounted for. Right click. Right click, right click on your mouse. Remember, right click. Okay. And now, see it says add trend line. That's what you want, a trend line. The line is going to go through these points. And you want it to be linear. And scroll down. You can even have it put in an equation, which you're going to learn about called regression equation. You don't need that right now. You do want to display the r squared, possibly. Here's your r squared value. Okay. So now, again, notice, make sure I got everything I want. It's linear. I want a linear line. I want to see the r squared. And again, something just may want to see the equation. Right now, we don't need it. Click up here. And there it is. You see that line going through your points? Actually, two points are on the line. Most of the points are off the line. We're going to learn about how the line is drawn mathematically. Okay. But now you have what's called a trend line. That is called the trend line. You have the r squared up there, 0.6408, which you can calculate yourself by taking 0.8005 vr. And squaring it, you'll learn in regression the r squared measure is very important. It's called the coefficient of determination. Goodbye.