This example data set shows us the years of service and salary of 39 employees for an imaginary company. If you download the Excel file at the top of the page, you will find 2 columns labeled Years and Salary. Khan Academy – Linear Regression Lets Start by Looking at the Data I highly the Khan Academy video posted below if you are looking to brush up on your statistics. I am not going to go too deep into the math here. Using that line, you can then predict the value of Y given X. The general idea, as seen in the picture below, is finding a line of best fit through the data. Linear Regression is a method of statistical modeling where the value of a dependent variable based can be found calculated based on the value of one or more independent variables. If you would like to follow along with the exercise, please download it from the link below:Įxcel File Download: Linear Regression Example File 1 What is Linear Regression? I have uploaded a spreadsheet to this page. Today we are going to use Excel to tackle a simple regression problem. Another great reason to use it, is that regression tools are easy to find.
With its different flavors, regression analysis covers a width swath of problems.
Regression Analysis is still the most popular method used in Predictive Analytics. Link to video on Linear Regression using Excel
0 kommentar(er)
