Excel Reference 537
Confi dence Level
Click to indicate a confi dence interval for linear regression parameter esti-
mates. A 95% confi dence interval is automatically included; enter a different
one in the corresponding box.
Residuals
Click to create a column of residuals (observed—predicted) values.
Residual Plots
Click to create a plot of residuals versus each of the predictor variables in
the model.
Standardized Residuals
Click to create a column of residuals divided by the standard error of the
regression’s analysis of variance table.
Line Fit Plots
Click to create a plot of observed and predicted values against each of the
predictor variables.
Normal Probability Plots
Click to create a normal probability plot of the Y variable in the Input Y
Range.
See “Output Options” at the beginning of this section for information on
the output storage options.
Sampling
The Sampling command creates a sample of an input range. The sample can
be either random or periodic (sampling values a fi xed number of cells apart).
The sample generated is placed into a single column.