Manuals/calci/ANOVASINGLEFACTOR

Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets.ANOVA :Single Factor performs a simple analysis of variances between two data sets.

ANOVA :Single Factor performs a simple analysis of variances between two data sets.

ANOVA:SINGLE FACTOR returns #ERROR, if Alpha <0 or Alpha >1.

ANOVA : SINGLE FACTOR

what is ANOVA?

Remarks

Examples

Description

Syntax

=ANOVASIGLEFACTOR(Array, Alpha, GroupBy,NewTableFlag)

where,

Array - Input range should be one or two blocks.

Alpha - represents the constant and value in between 0 and 1.

GroupBy - Either groupby columns or rows.

NewTableFlag - is the TRUE or FALSE.If set as TRUE, the result in new sheet.If NewTableFlag is omitted, it assumed to be false.

	Column1	Column2	Column3	Column4
Row1	1	3	15Space	5
Row2	7	8	9	128
Row3	12	5	14	15
Row4	17	18	#ERROR	20
Row5	37	31	23	168
Row6	16Space	0.850904	1.619775	0.525322

File:Calci1.gif

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Column1	4	37	9.25	46.916666666666664
Column2	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.98702940083107
Within Groups:	273.75	6	45.625
Total:	274.875	7

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Column1	4	37	9.25	46.916666666666664
Column2	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.98702940083107
Within Groups:	273.75	6	45.625
Total:	274.875	7

Lets see an example in (Column3 , Row1)

=ANOVASINGLEFACTOR(R1C1:R4:C2, 0.05, "columns", TRUE)

ANOVASINGLEFACTOR returns the result in new sheet(15Space).

=ANOVASINGLEFACTOR(R1C1:R4C2 , 0.05, "rows", TRUE)

It returns the results in new sheet(16Space).

=ANOVASINGLEFACTOR(R1C1:R4C2 , -0.05, "rows", FALSE)

It returns the #ERROR(Alpha >1 or Alpha<0)