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
that decides to display the output 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.
- 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.
Examples
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
|
See Also
References