If you added headers in the first cells of each column, click the check box next to "Labels."Ĭlick the radio button next to "Output Range" then place your cursor into the text box next to the radio button and click on cell C1.Ĭlick "OK" and your regression table will appear on the spreadsheet starting in cell C1. Clicking the box next to the Y and X ranges will allow you to use the click and drag feature of Excel to select your input ranges. Congratulations, you have made it to the regression window. Place your cursor into the "Input X Range" text box and repeat the process to select the data set that holds your independent, or explanatory, variables. Click Data then Data Analysis and then click Regression and OK. Now click and hold on the top cell in the column that contains your dependent variables, drag the mouse down to the last data-holding cell in that column and release the mouse button. Excel says df (Regression) 3 your software above has df (regression) 4. This might be due the degrees of freedom used in the respective analyses. The results were slightly different to those shown on this page. Place your cursor into the "Input Y Range" text box. I put the data above into Excel 2016 and used the inbuilt Analysis ToolPak (Data Analysis Regression) to analyse the data. Select "Regression" from the list that appears in the Data Analysis window and then click "OK." If desired, you can add headers to your data in cells A1 and B1 so that you can tell the data sets apart.Ĭlick on the "Data" tab at the top of the Excel window and then click the "Data Analysis" button when it appears on the ribbon. ![]() Repeat the process with your second set of values down the second column. Continue to enter the rest of the set of values down the cells in the first column. ![]() Select cell A1 and enter the first value for your first set of values. Click the small check box next to "Analysis ToolPak" and click "OK." You will now have access to the regression feature. Click on "Add-Ins" on the left side of the Options window and then click "Go" when the button appears at the bottom of the Options window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |