Forum Discussion

Gin1015's avatar
Gin1015
Copper Contributor
Nov 12, 2023

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.

Resources