2002RegressQuickGuide

2002RegressQuickGuide - Regress Quick Guide 2002-2003 E...

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

View Full Document Right Arrow Icon
1 Regress Quick Guide 2002-2003 Duke’s Fuqua School of Business stablishing a Regress-ready data set in Excel Before you invoke Regress to run a multiple regression, there is one preparatory step you must take. Regress requires that your Excel data be arranged in named ranges . If you think of your Excel data in its row and column orientation, a named range can be simply a column of the data with a name assigned to the column. Naming each of your columns of data allows Regress to then use these column names in its analyses. There are several ways to name data ranges in Excel. Assuming your data is arranged in columns (so each row of data constitutes a record), the easiest method is this one: 1) If your data does not already have headers, add a header row and provide a name for each column of data. 2) Select the headers and the data beneath them. 3) Choose the Excel commands Insert and then Name, Create . In the “Create Names” dialog that appears, Create names in Top row should be checked. If not, select it and click OK . Excel names each column using the header label above it. You now have a “named range” for each column of data. 4) Test to make sure the range name operation has worked properly by clicking the drop-down arrow to the right of Excel’s “name box” in the formula bar and selecting any range name in the drop-down list. Excel should then highlight whatever range name you select. Click the drop-down arrow to the right of Excel’s name box
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.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 4

2002RegressQuickGuide - Regress Quick Guide 2002-2003 E...

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