Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 531

Variable 2 Range

Enter the range of the second sample, either a single row or a single column.

Labels

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

Alpha

Enter the alpha level used to determine the critical value for the F-statistic.

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

the output storage options.

Histogram

The Histogram command creates a frequency table for data values located

in a row, column, or list. The frequency table can be based on default or cus-

tomized bin widths. Additional output options include calculating the cu-

mulative percentage, creating a histogram, and creating a histogram sorted

in descending order of frequency (also known as a Pareto chart).

Input Range

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

row, column, or rectangular region.