Thursday, April 18, 2013

How to Calculate a Standard Error Regression


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.

Blogger news