Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION
Jump to navigation
Jump to search
Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets.
ANOVA:TwoFactor without replication performs an analysis of variances between two or more data sets. And used when we only have one sample from each data set.
ANOVATWOFACTORWITHOUTREPLICATION returns #ERROR, if Alpha <0 or Alpha >1.
ANOVA : TWO - FACTOR WITHOUT REPLICATION
what is ANOVA?
Remarks
Examples
Description
Syntax
=ANOVATWOFACTORWITHOUTREPLICATION(Array, Alpha, NewTableFlag)
where,
Array - Input range should be one or two blocks.
Alpha - is the constant in between 0 and 1.
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)
=ANOVATWOFACTORWITHOUTREPLICATION(R1C1:R12C2, 0.01, TRUE)
ANOVATWOFACTORWITHREPLICATION returns the result in new sheet(8Space).
=ANOVATWOFACTORWITHOUTREPLICATION(R1C1:R12C2, -0.05, FALSE)
It returns the #ERROR(Alpha >1 or Alpha<0)
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 3 | 8Space | 5 |
| Row2 | 2 | 5 | #ERROR | |
| Row3 | 6 | 41 | ||
| Row4 | 8 | 45 | ||
| Row5 | 9 | 56 | ||
| Row6 | 10 | 8 | ||
| Row7 | 7 | 8 | 9 | |
| Row8 | 12 | 5 | 14 | 15 |
| Row9 | 17 | 18 | 20 | |
| Row10 | 72 | 31 | 23 | 40 |
| Row11 | 6 | 3 | ||
| Row12 | 2 | 7 |
| Count | Sum | Average | Variance | |
|---|---|---|---|---|
| Row1 | 2 | 4 | 2 | 2 |
| Row2 | 2 | 7 | 3.5 | 4.5 |
| Row3 | 2 | 47 | 23.5 | 612.5 |
| Row4 | 2 | 53 | 26.5 | 684.5 |
| Row5 | 2 | 65 | 32.5 | 1104.5 |
| Row6 | 2 | 18 | 9 | 2 |
| Row7 | 2 | 15 | 7.5 | 0.5 |
| Row8 | 2 | 17 | 8.5 | 24.5 |
| Row9 | 2 | 35 | 17.5 | 0.5 |
| Row10 | 2 | 103 | 51.5 | 840.5 |
| Row11 | 2 | 9 | 4.5 | 4.5 |
| Row12 | 2 | 9 | 4.5 | 12.5 |
| Column1 | 12 | 152 | 12.666666666666666 | 369.69696969696974 |
| Column2 | 12 | 230 | 19.166666666666668 | 360.3333333333333 |
| Source of Variation | Sum of Squares | Degree of Freedom | Mean of Squares | F | Probability | F Critical |
|---|---|---|---|---|---|---|
| Rows: | 4990.833333333334 | 11 | 453.71212121212124 | 1.6419915556286661 | 0.21186926809792436 | 4.460024010499913 |
| Columns: | 253.50000000000017 | 1 | 253.50000000000017 | 0.9174206283928278 | 0.4028687266699078 | 9.64473915180063 |
| Error: | 3039.500000000002 | 11 | 276.318181818182 | |||
| Total: | 8283.833333333335 | 23 |