Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 527

Covariance

The Covariance command creates a table of the covariance for values in

rows or columns on the worksheet.

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.

Descriptive Statistics

The Descriptive Statistics command creates a table of univariate descriptive

statistics for values in rows or columns on the worksheet.