Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 535

Rank and Percentile

The Rank and Percentile command produces a table with ordinal and per-

centile values for each cell in the input range.

Input Range

Enter the range of worksheet data you want to analyze. The range must be

contiguous.

Grouped By

Indicate whether the range of samples is grouped by columns or by rows.

Labels in First Row/Column

Indicate whether the fi rst row (or column) includes header information.

See “Output Options” at the beginning of this section for information on

the output storage options.

Regression

The Regression command performs multiple linear regression for a variable

in an input column based on up to 16 predictor variables. The user has the

option of calculating residuals and standardized residuals and producing

line fi t plots, residuals plots, and normal probability plots.