Excel 2010 Regression Instructions

Excel 2010 Regression Instructions - example only 3 Make...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Obtaining Regression Output in Excel 2010 To start: Go to the worksheet with the data. Go to Data menu tab and to the Data Analysis menu. Step 1 : Open Regression option in the Data Analysis menu. Step 2 : Run the Regression analysis. 5. To finish, click “ OK ”. 1. Click on “ Input Y Range ” and select the worksheet range containing the dependent variable data (include the label). The cell references shown are for
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: example only. 3. Make sure to select “ Labels ” by checking ( ) the box. 4. Select “ New Worksheet Ply ” – places output in a new worksheet. 2. Click on “ Input X Range ” and select the worksheet range containing the independent variable data (include the label). The cell references shown are for example only. 1. Scroll down and select “ Regression ” option. 2. Click “ OK ”....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online