# Manuals/calci/ANOVASINGLEFACTOR

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.This should be used when you have one indepenedent variable.

## 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.05,"ROWS",TRUE) displays results in a new space.
```
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
RowA 4 37 9.25 46.916666666666664
RowB 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