Macro Sheets Only
Performs two-factor analysis of variance with replication.
If this function is not available, you must install the Analysis ToolPak add-in macro.
Syntax
ANOVA2(inprng, outrng, sample_rows, alpha)
ANOVA2?(inprng, outrng, sample_rows, alpha)
Inprng is the input range. The input range should contain labels in the first row and column.
Outrng is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.
Sample_rows is the number of rows in each sample.
Alpha is the significance level at which to evaluate critical values for the F statistic. If omitted, alpha is 0.05.
Related Functions
ANOVA1 Performs single-factor analysis of variance
ANOVA3 Performs two-factor analysis of variance without replication
List of Statistical Functions