Forum Discussion
Non-Numeric Data
my excel can't process anova because the blank coloumn identified as non-numeric data
any solution guys?
sorry my english is bad
1 Reply
- If you included B1:F1 in the input range, did you specify that the first row contains labels? Otherwise, Excel will treat B1:F1 as data, causing the error that you mention.
- Make sure that the empty-looking cells are really empty - try clearing them. If they contain spaces or formulas that return "", you'd get the error message.
ANOVA can handle really blank cells:
