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)

---