 This is a quick little video tutorial to show you how to use Microsoft Excel in order to do regression, and here's our example. Now to do regression, you have to be very careful because you're getting an equation. So you have to make sure you know which is the x, the independent variable, and which is the y, the dependent variable you think you're trying to predict. We're trying to predict job performance, that's the y. Okay, so to do regression, first you have to have that add-in that we talked about. So that you remember you checked off the box called analysis tool pack. Analysis tool pack was an add-in, right? So this way when you go to data, you're going to see data analysis. You won't see it if you didn't check off that analysis tool pack. Okay, you look for regression, there it is, regression. Okay, notice you have a lot of other things you could teach yourself. Everything from histograms, moving averages, okay, regression. Okay, now it's asking you, it's already here, but I'll tell you it's not here. It's asking you, oops, it's asking you. Let's do this again. We can do this again. Yeah, we'll do it again. Okay, all right, data, data analysis, regression, okay. And let's pretend this is not here. So we need the y. Y comes here, okay, that's D2 to D15. And the x, and remember it's very important. If you get your x and your y mixed up, you'll get the wrong answer all every time. The only thing that'll be right is your R will be the same, but every equation will be all messed up. Okay, let's keep it, you want this on the regression output on a new worksheet. You may want to see the residuals, we'll click here if you want to see it. And that should be enough. So again, check, is this the y, D2 to D15? Yes, is this the x, B2 to B15? All right, click okay. And now expand this, I'll let you expand it. Expand it so it's easier to read. Just highlight all the columns that you're using, double click anywhere. Oh, best way to do that. Okay, now first of all, notice you got, it's called multiple R here, because this is also used for multiple regression. It's really R, 0.80, the R squared we saw was 0.64. You have an F value, it's significance, which you're going to learn about. It's definitely significant. And here's your regression equation, the residuals I just showed you. These are the residuals that you're going to learn about. But here's the equation right here, this is where your equation is located. You have the slope term, point, the teacher may call that B1. And that's point 0.151. And then you have the intercept term. Okay, your teacher may either call that A or B0, I call it B subscript 0. That's minus 5.987. And that's your regression equation right here. So you have a regression equation, you have a test of significance. You have a few other things you're going to learn. But one thing you also check, make sure it says 14 observations. If it says something else, I know that I started with 14 observations. Anyway, now you have the basics of how to do regression in Excel. Do you want to add it? No, I'm good. Good. Okay.