How to Calculate a Standard Error Regression

Regression analysis is used for analyzing historical or experimental data. It allows you to determine to what extent the results are correlated with your inputted values. The equation for a linear regression is y = mx + b, where x is the independent variable, y is the dependent variable, m is the slope of the line, and b is the y-intercept. You can calculate a linear regression as well as the standard error (or average deviation of a set of means) using Microsoft Excel 2007.

Things You'll Need

  • Microsoft Excel 2007
Show More

Instructions

    • 1

      Open Microsoft Excel 2007. Input your data into the spreadsheet into two columns. You should have known values for y (your dependent variable) and each independent variable.

    • 2

      Go to the "Data Analysis" command under the "Data" tab on the user interface. If you do not have this function, you must add it in. To add the analysis to Excel, go to the "Microsoft Excel" button in the right-hand corner of your screen. Go to "Excel Options and Add-ins." Select the "Data Analysis" toolpak. Download to your Excel program.

    • 3

      Select "Data Analysis." A list of statistical choices will appear. Choose "Regression."

    • 4

      Input the data in the correct ranges. A box will prompt with an input for Y-range and X-range. In addition, select where you want the results to appear, on a separate worksheet or the same worksheet. If you want the results to appear on the same worksheet, select "Output Range" and highlight the cells you want the results to appear on.

    • 5

      Click OK and look at the summary output. There will be a list of the regression results, including the standard error.

Learnify Hub © www.0685.com All Rights Reserved