ANOVA table issue with non numeric data

Copper Contributor

Good evening, 


I am trying to create a single factor ANOVA table but receive this error message each time '

Anova: Single Factor - Input range contains non-numeric data." 


Does anyone have advice on how to fix this. I have the 16.59 version of excel (the most recent). I am trying to solve this for my stats class and am not sure why I am having this error

1 Reply
Just format your data so that all cells...including blank ones...are numeric format. And don't forget to have your data so that variable (eg. months of year) are column headings and your data points (eg # customers) are listed under each column heading.