Once you have your data entered in Excel, highlight a blank area of 2 columns by 5 row and type =LINEST. The LINEST function is standard in Excel on both Macs and PC's and a version of it is available in Google docs. The R 2 tells us essentially how reliable the regression is or. So if we have a quarterback with a 100 QB rating, we can plug his 100 into our formula (y 0.097 100 2.495) and get a reasonable estimation of what his Adjusted Net Yards per Pass Attempt (ANY/A) would be (about 7.2). The chart now displays the regression line (Figure 4) Figure 4. One of the fun things about regressions is that they give us formulas line equations, specifically.
Choose the Options tab and select Display equation on chart (Figure 3): Figure 3. Along the top ribbon in Excel, go to the Data tab and click on Data Analysis. Select the Linear Trend/Regression type: Figure 2. Enter the following data for the number of hours studied, prep exams taken, and exam score received for 20 students: Step 2: Perform multiple linear regression. If the truth is non-linearity, regression will make inappropriate predictions, but at least regression will have a chance to detect the non-linearity. To obtain the slope and the y-intercept, along with additional statistical details, you can use the LINEST function. Perform the following steps in Excel to conduct a multiple linear regression. THE MODEL BEHIND LINEAR REGRESSION 217 0 2 4 6 8 10 0 5 10 15 x Y Figure 9.1: Mnemonic for the simple regression model.