 Hi, this is Dr. Don. I'm going to show you very quickly how to run a basic simple linear regression using the Excel data analytics tool pack regression tool and while we're doing that we're going to create the scatter chart That goes along with it. So here's our data We've got the number of starbucks stores in each state and the population in each state And we're going to start by going to data Go to data analysis And we're going to drop down here and find regression And we want to input the y Range and i'm going to say that I want number of starbucks to be On my y-axis because i'm kind of thinking i want to say does Population predict the number of starbucks So i'm going to put the number of starbucks the population rather in the x column And i always like to double check to make sure i've got matching ranges Regression and excel requires matching ranges. I've got labels at the top I want to put my output range on this page. So i'm going to click there Get my insertion cursor flashing and pick that point now to get the plots I want to click on down here in the residuals the line fit plot And if you want to look at your residuals, you can click the residual plot and that's useful But i'm going to cover that in another video. So i'm going to go ahead and click on okay And excel gives us our output And of the regression and we get a little chart here, but i'm going to expand that of course And we see that we've got our actual data points in blue And they've added these orange squares, which are the predicted number of starbucks Now you can leave that if you want what i like to do is add the trend line and the regression equation So i'm going to click just on one of these orange dots to click select them and click delete And so i've gotten rid of the predicted now i can click on Just one of the blue dots the actual data right click add trend line We get the secondary menu over here. Yes, I want the linear and I want to Show the regression equation and our square and i want to click that off So here we have our basic chart The reason I like creating the scatter chart this way is because the equation of the line and our square Will always match exactly what is in the actual regression calculations Sometimes when you create your scatter chart separately you reverse the x and the y and that kind of messes things up So this is a quick way of getting the regression done and the scatter chart. So hope this helps