ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)

where, is an array of numbers or reference to cells containing array
represents a constant value between '0' and '1'
is a method to perform the analysis by columns or rows
decides if the output is to be displayed in the same worksheet or a new space cube.

ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets.

Description

Analysis Of Variances(ANOVA) is a method of checking relationship between two or more data sets.
should be in between '0' and '1'. Else Calci displays #N/A error message.
Analysis can be done by columns or rows. The choice should be entered in quotes (e.g. "COLUMNS" or "ROWS").
can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If is TRUE, the result is displayed on new zspace sheet.

Consider the following table with Columns A and B as array inputs for ANOVASINGLEFACTOR() function.

=ANOVASINGLEFACTOR(A1:B4,0.05,"COLUMNS",TRUE) displays results in a new space.

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
ColumnA	4	37	9.25	46.916666666666664
ColumnB	4	34	8.5	44.333333333333336

ANOVA
Source of Variation	Sum of Squares	Degree of Freedom	Mean of Squares	F	Probability	F Critical
Between Groups:	1.125	1	1.125	0.024657534246575342	0.8886077621608085	5.987702296337573
Within Groups:	273.75	6	45.625
Total:	274.875	7