How Do You Run Regression Analysis In Microsoft Excel?
• Open Microsoft Excel. Loading… • Enter the data into the spreadsheet that you are evaluating. You should have at least two columns of numbers that will be representing your Input Y Range and your Input X Range. Input Y represents the dependent variable while Input X is your independent variable. Click the Data tab, then the Data Analysis tab. If you don’t have Data Analysis under your Data tab you will need to do the following: • Click on the office button at the top left of the page. • Click the tab called Excel Options. • Click on Add-Ins on the left side of the page. • Click on Analysis ToolPack on the right. • Click on Ok and you should be set up to run regression analysis. • Select Regression from the list of Analysis Tools. • Define your Input Y Range. Place the cursor in the Input Y Range field. While the cursor is still blinking, highlight the column of independent numbers. You will see a formula that has been entered into the Input Y Range spot. • Repeat the previous step
