Download Calculating and displaying regression statistics in Excel and more Lecture notes Statistics in PDF only on Docsity!
Calculating and displaying regression statistics in Excel
Note: the Analysis TookPak is no longer included in Excel for the Mac. You need to download a third party analysis program to perform some statistical tests. These instructions apply to Excel for Windows.
You will need to have the Data Analysis add-in installed to your version of Excel to run statistical tests. If you click on the “Data” menu tab and see the “Data Analysis” option as below, then the add-in is already installed.
If you do not see the “Data Analysis” option, you will need to install the add-in. Depending on the version of Excel you are using, you do this by clicking on the Office button in the top left corner, and selecting the “Excel Options” button (below left), or clicking on the “File” tab and then the “options” button (below right).
You will then see the Excel Options menu (left): click on the “Add-Ins” button and select the “Analysis ToolPak” and click the “Go” button to install. The “Data Analysis” tab should then appear in the “Data” menu as shown above
To run the regression, arrange your data in columns as seen below. Click on the “Data” menu, and then choose the “Data Analysis” tab. You will now see a window listing the various statistical tests that Excel can perform. Scroll down to find the regression option and click “OK”.
Now input the cells containing your data. In the menu box, click in the “Input Y Range” box and then use the cursor to select the column containing the data for the dependent variable. As you select the cells in your spreadsheet, the range should also appear in the menu box window. Repeat the process for “Input X Range” and your independent variable data. When everything looks good, click “OK”. You will now see the results of your statistical test (unless you selected otherwise, by default the results will open in a new worksheet).
