Databases Reference
In-Depth Information
FIGURE 4.25
Launching the linear regression tool.
each parameter does. Even using the autocomplete feature as shown in Figure 4.27 provides little
insight into the function of each parameter.
Of the 30 arguments passed to the Regress subroutine, only the X data range, Y data range,
and new Worksheet name are readily apparent by looking at the recorded macro code. One way
to discern what all the other parameters mean is to execute the code and randomly vary the
Boolean results and observe the outcome. A more practical way is to conduct a search for the
macro “ATPVBAEN.XLA!Regress” on the Internet and see if any practical information can be
located.
When the Regress subroutine in the Analysis Toolpak is run, a line is fitted to the specified
data of the form
ymxb
=+
(4.11)
where m
y intercept.
On the analysis sheet created by the Regress macro, the slope is for some reason labeled X
(instead of m) (cell B18, if the results are placed into a new Worksheet), and the intercept is
appropriately labeled intercept (cell B17, if the results are placed into a new Worksheet). For the
=
slope, and b
=
FIGURE 4.26
Executing the regression tool on the sample data set.
