Forum Discussion
Gin1015
Nov 12, 2023Copper Contributor
ANOVA single factor
Hello,
I am new to this community. I have to do an ANOVA single factor test (which I am very new to) in Excel to analyse my data, however for almost all of my variables I only have one value per group. Unfortunately this was all I was able to obtain. Every time I conduct an ANOVA, it simply comes up with #DIV/0 in all of the variance boxes, and #NUM! in the P-value and F crit box. Is it not at all possible to do an ANOVA despite only having one value per group? Unfortunately at the time this was unavoidable, I know my results will ultimately not have great significance.
- JKPieterseSilver ContributorCan you perhaps share some of your data (even if made-up)?