Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
526

Correlation

The Correlation command creates a table of the Pearson correlation coef-
fi cient 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.
Free download pdf