Jeffrey H. Moore
Graduate School of Business, Stanford University
A statistical regression add-in to Microsoft Excel on
Macintosh and Windows computers, Regress
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-
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
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.
Getting Started with Regress
To begin, launch Excel as usual.
Regress should appear as
the last item on the "Tools" menu.
See the figure below, left.
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.)
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
The Regress software is available from
Nexus Systems, P.O. Box 20075, Stanford CA 94309-20075.
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-