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
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.
| 1 | 3 | |
| 7 | 8 | |
| 12 | 5 | |
| 17 | 18 | |
=ANOVASINGLEFACTOR(A1:B4,0.5,"COLUMNS",TRUE) displays results in a new space.
| Groups | Count | Sum | Average | Variance |
|---|---|---|---|---|
| ColumnA | 4 | 37 | 9.25 | 46.916666666666664 |
| ColumnB | 4 | 34 | 8.5 | 44.333333333333336 |
| 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 |