Manuals/calci/ANOVASINGLEFACTOR

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.

Description

ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)

• 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.

Examples

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

1	3
7	8
12	5
17	18

=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

Related Videos

ANOVASINGLEFACTOR

See Also

• ANOVATWOFACTORWITHOUTREPLICATION
• ANOVATWOFACTORWITHREPLICATION

References

• ANOVA Single Factor