Manuals/calci/ANOVATWOFACTORWITHREPLICATION

Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets.

---

ANOVA :Two-Factor with replication performs an analysis of variances between two more data sets. And used when we have more than one sample from each data set.

---

ANOVATWOFACTORWITHREPLICATION  returns #ERROR, if Alpha <0 or Alpha >1.

It returns the #ERROR, when length of Array != length of NumberofSample.

---

ANOVA : TWO - FACTOR WITH REPLICATION

---

what is ANOVA?

---

Remarks

---

Examples

---

Description

---

Syntax

---

=ANOVATWOFACTORWITHREPLICATION(Array, NumberofSample, Alpha, NewTableFlag)

where,

Array - Input range should be one or two blocks.

Alpha - is the constant in between 0 and 1.

NumberofSample - Input range should be one blocks.

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

---

Lets see an example in (Column3 , Row1)

=ANOVATWOFACTORWITHREPLICATION(R1C1:R12C2, 2, 0.01, TRUE)

ANOVATWOFACTORWITHREPLICATION  returns the result in new sheet(13Space).

=ANOVATWOFACTORWITHREPLICATION(R1C1:R12C2 , 2,-0.05, FALSE)

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

---

	Column1	Column2	Column3	Column4
Row1	1	3	13Space	5
Row2	2	5		#ERROR
Row3	6	41		File:Copy-cube.gif
Row4	8	45
Row5	9	56
Row6	10	8
Row7	7	8	9	128
Row8	12	5	14	15
Row9	17	18	10000	20
Row10	72	31	23	40
Row11	6	3	1.619775	0.525322
Row12	2	7

File:Calci1.gif

---

Anova: Two-Factor With Replication
SUMMARY

Groups	Count	Sum	Average	Variance
Array1	12	152	12.666666666666666	369.69696969696974
Array2	12	230	19.166666666666668	360.3333333333333

ANOVA

Source of Variation	Sum of Squares	Degree of Freedom	Mean Square	F-Value	Probability	F Critical
Sample:	3270.333333333334	5	654.0666666666668	2.8081574239713784	0.06629115945265437	5.061984369714618
Columns:	253.50000000000017	1	253.50000000000017	1.0883720930232565	0.36437615127626016	9.332898584189282
Interaction:	1965.0000000000018	5	393.00000000000034	1.6872987477638656	0.2120282015971952	5.061984369714618
Within:	2795	12	232.91666666666666
Total:	8283.833333333335	23

---