Given a set of data video demonstrates how to find the linear regression for the data and the correlation using Excel which includes a graph with a best-fit. Select Regression and click OK. We have all the values in the above table with n 4.
Now we will do the excel linear regression analysis for this data.
So far it looks a lot like a good old-fashioned linear regression. As you can see the equation shows how y is related to x. Select the x-axis horizontal and y-axis data and click OK. 2 Regression Analysis Using Scatterplot with Trendline in Excel Select your entire two columned data including headers.