Ch6 regression explanation

Ch6 regression explanation - How to perform Simple...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
How to perform Simple Regression using Excel 1. Open up excel and verify that you have the data analysis option under the drop down tool menu. If you do not see data analysis under the tool menu, you need to add this feature. Click on -- tools, click on-- add ins, and click on -- analysis toolpak. You may have to insert the startup CD for Microsoft if you did not do a full install. 2. You must have data on an excel worksheet when you are ready to perform the regression analysis. The dependent variable (Y) should be set up in cells in a column. The dependent variable we will be working on for this course will be cost. The independent variable (X) should be set up in cells in a column. The independent variable is what is driving the change in cost, so it will be an activity (i.e. cost driver). Go to tools, click on data analysis, and scroll down until you see regression. Click on regression and click OK. 3. Click in the box labeled input Y Range and go to your column of dependent variable data. Highlight the data or type in the range of information that contains the dependent variable. If you have typed in any labels, make sure you do not include them in your input. 4. Click in the box labeled input X Range and go to your column of independent variable data. Highlight the data or type in the range of information that contains the independent variable. If you have typed in any labels, make sure you do not include them in your input. 5. Make sure the output option is on a new worksheet. You can click in the box entitled a new worksheet to name the worksheet. If you are trying to choose among different independent variables you may want to label each of the worksheets with the name of the independent variable. Now, click OK. The regression output table should appear on a separate worksheet. To view the total contents of a column while the worksheet it still
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Ch6 regression explanation - How to perform Simple...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online