RegressSkillBuildingAndQuickGuide03

RegressSkillBuildingAndQuickGuide03 - The Excel Regress...

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

View Full Document Right Arrow Icon
The Excel Regress Add-In Skill-Building and Quick Guide 2002-2003
Background image of page 1

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

View Full DocumentRight Arrow Icon
A Brief Guide to Contents Page Skill-Building Regress for Class. .................................................................. 1 The Regress Software . ............................................................ 1 This Skill-Building Session. ......................................................... 2 The Session Demo Files. ........................................................... 2 Running a Multiple Regression Using SmythPieData.xls Step 1: Plan the Regression . .............................................. 2 Step 2: Prepare the Data Set . ............................................ 3 Step 3: Start the Regression . ............................................. 4 Step 4: Identify to Regress the Dependent & Independent Variables. ..4 Identifying the dependent variable . .............................. 5 Identifying the independent variable(s) . ......................... 5 Step 5: Start the Regression – Or – First Choose Outputs. .............. 5 Step 6: Choose Other Regression Reports. ............................... 6 Step 7: Manage Your Regress Reports. ................................... 7 A Special Report: Forecast with Regress . ........................ 8 Step 8 (Optional): Use the Regress Reports in a Word Document. ..... 8 Step 9: Interpret Regress’s Results. ...................................... 9 Step 10: Quit Regress (or Run Another Analysis) . ....................... 9 Practice: Running a Multiple Regression Using Calculus.xls. ..................... 10 A Quick Guide to Regress Installing Regress. 11 Establishing a Regress-ready Data Set in Excel . ................................. 11 Starting Regress from within Excel. 12 Using the Regress Interface. ...................................................... 12 Selecting Regress Outputs. ........................................................ 14 Managing Report Outputs . 15 Quitting Regress . 15 Getting Help . ..................................................................... 15
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
1 Skill-Building Regress for Class You’ll be asked to use Regress software to run multiple regression analyses for your Probability and Statistics class. You should be quite familiar with the mechanics of using Regress software before you reach that topic in the class. These notes to accompany our short classroom session are intended to familiarize you with the key Excel/Regress tools you need to know. That is, how to: Establish a data set in Excel so it’s suitable for analysis with Regress Invoke Regress from within Excel Use the Regress interface Select Regress outputs Manage Regress output formats I assume you already have Regress installed on your computer. If you need assistance with this step, contact Fuqua’s technical support group (telephone 919/660-7878). The Regress Software The commercial Excel add-in named Regress is similar to but more flexible than Excel’s built-in regression tool for running multiple regression analyses. Regress can use named ranges of variables no matter where these ranges are located on a worksheet. Compared to Excel’s regression, Regress can produce a wider variety of text and graphical reports. Regress outputs are displayed in an outline type of arrangement, making them easy to expand or collapse. Because Regress has a 256-observation maximum, if you find you need to run a regression on larger data sets, consider using Statgraphics for which Fuqua and Duke have a site license. (To download a copy of Statgraphics see this website address: http://www.oit.duke.edu/site/software/statgraphics.html) For the complete Regress documentation — written by Regress’s author — download and print the Word-version Regress guide from the “Excel Add-Ins” header on this web page: http://faculty.fuqua.duke.edu/~pecklund/excelreview/ExcelReview.htm
Background image of page 4
2 This Skill-Building Session In this session we’ll see how Regress works by analyzing two small sample data sets.
Background image of page 5

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

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

Page1 / 20

RegressSkillBuildingAndQuickGuide03 - The Excel Regress...

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

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