Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
528

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.

Confi dence Level for Mean


Click to print the specifi ed confi dence level for the mean in each row or col-
umn of the input range.

Kth Largest


Click to print the kth largest value for each row or column of the input range;
enter the value for k in the corresponding box.
Free download pdf