Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
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.
Free download pdf