Forum Discussion
ANOVA two factor with replication
P value is coming up with #NUM! error in Sample and interaction, but is working for columns.
Entering rows as 12 from data table as I have 12 sets of data and one row of titles
| Anova: Two-Factor With Replication | ||||||
| SUMMARY | A | B | Total | |||
| 7 | ||||||
| Count | 12 | 12 | 24 | |||
| Sum | 50 | 38 | 88 | |||
| Average | 4.166667 | 3.166667 | 3.666667 | |||
| Variance | 0.515152 | 4.515152 | 2.666667 | |||
| Total | ||||||
| Count | 12 | 12 | ||||
| Sum | 50 | 38 | ||||
| Average | 4.166667 | 3.166667 | ||||
| Variance | 0.515152 | 4.515152 | ||||
| ANOVA | ||||||
| Source of Variation | SS | df | MS | F | P-value | F crit |
| Sample | 0 | 0 | 65535 | 65535 | #NUM! | #NUM! |
| Columns | 6 | 1 | 6 | 2.385542 | 0.136726 | 4.30095 |
| Interaction | 0 | 0 | 65535 | 65535 | #NUM! | #NUM! |
| Within | 55.33333 | 22 | 2.515152 | |||
| Total | 61.33333 | 23 | ||||
No RepliesBe the first to reply