Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 523

New Workbook

Click to send output to a new workbook.

Anova: Single Factor

The Anova: Single Factor command calculates the one-way analysis of vari-

ance, testing whether means from several samples are equal.

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.

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.