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