Revision as of 20:39, 5 January 2014

ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)

where, $Array$ is an array of numbers or reference to cells containing array
$Alpha$ represents a constant value between '0' and '1'
$GroupBy$ is a method to perform the analysis by columns or rows
$NewTableFlag$ 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.

Analysis Of Variances(ANOVA) is a method of checking relationship between two or more data sets.
$Alpha$ 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").
$NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If $NewTableFlag$ 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.5,"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

@@ Line 4: / Line 4: @@
 *<math>Alpha</math> represents a constant value between '0' and '1'
 *<math>GroupBy</math> is a method to perform the analysis by columns or rows
-*<math>NewTableFlag</math> that decides to display the output in the same worksheet or a new space cube.
+*<math>NewTableFlag</math> 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 ==
 ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)