regress1.8ausersguide9-99

# regress1.8ausersguide9-99 - Regress Users Guide Jeffrey H...

This preview shows pages 1–3. Sign up to view the full content.

Regress User’s Guide Jeffrey H. Moore Graduate School of Business, Stanford University Introduction A statistical regression add-in to Microsoft Excel on Macintosh and Windows computers, Regress 1 makes exploratory regression analysis fast and convenient. It does this by displaying preliminary results in a temporary window that you can easily dis- miss during the exploratory modeling phase. This allows you to run many regression models, interactively adding and dropping variables, as you evaluate alternative models for reasonableness and goodness- of-fit. Since Regress is an add-in to Excel, you have all the normal Excel worksheet capabilities available. This includes, for example, the ability to cut and paste the results into another Excel worksheet, Microsoft Word document, or other Windows or Macintosh compatible application. Moreover, you have complete freedom to change the formatting, the fonts, the size of tables and charts, etc., to suit your particular requirements. This flexibility is rarely present in other dedicated regression packages. I Tutorial Getting Started with Regress To begin, launch Excel as usual. 2 Regress should appear as the last item on the "Tools" menu. See the figure below, left. If you do not see “Regress” listed, it has not been properly installed on your computer (or, if you purchased Regress, you neglected to re-start Excel after installing it on your computer.) 1 © Copyright Sept., 1999 This manual documents Version 1.8a of Regress for Excel Ver. 98 for Macintosh (System 8+) and Excel Ver. 97/2000 for Windows PC's (Windows 95/98/NT). The Regress software is available from Nexus Systems, P.O. Box 20075, Stanford CA 94309-20075. 2 Macintosh users: Excel on Macintosh defaults to a too small memory partition for Excel yielding a severe response time penalty caused by virtual memory swaps to disk for large Add-Ins, such as Solver or Regress. Macintosh Excel users should increase Excel's default memory allocation by an additional 1 megabyte or more as Excel’s “Preferred Size,” i.e., click the Microsoft Excel application icon and press Command-i to display and change Macintosh Excel's preferred memory size require- ment.

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

View Full Document
2 Now, click the “Regress” item on the Tools menu, causing Regress to be loaded into Excel as an Add-In. During the load pro- cess, you should see three changes: (1) Excel will ask if you wish to allow a macro add-in to be opened. Click “Enable Macros” to begin. (2) A herald window will remind you that you need to open a workbook containing your data. (See the figure below, right.) (3) Finally, a small toolbar entitled “Regress,” containing three but- tons, will appear in the upper right corner of your screen. (See the small figure below.) When the herald window closes, loading of Regress is complete. Regress will remain loaded into Excel and available until you quit Regress by clicking the “ Q ” button. Normal spreadsheet functions are unaffected by Regress, and you can use Excel as usual. Since its only function is to initiate loading, the “Regress” item on
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 48

regress1.8ausersguide9-99 - Regress Users Guide Jeffrey H...

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

View Full Document
Ask a homework question - tutors are online