Forum Discussion

delaneywickermiller's avatar
delaneywickermiller
Copper Contributor
Apr 03, 2022

ANOVA table issue with non numeric data

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

Excel
  • cool2021's avatar
    cool2021
    Iron Contributor
    Apr 18, 2023
    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.

Share

Resources