Fix Excel ANOVA Input Range Contains Non-Numeric Data Error
Question details
The user needs to run a one-way ANOVA in Excel for three groups with unequal sample sizes.

- Product
- Microsoft Excel Analysis ToolPak
- Device & OS
- not provided
- Scenario
- Running ANOVA: Single Factor on three groups of observations.
- Observed behavior
- Excel reports that the input range contains non-numeric data.
Locate the three groups and note whether their labels are included in the selected range. Check that Data Analysis is available on Excel's Data tab.
Clean the input range and rerun ANOVA: Single Factor
Use this method to identify text, incorrect labels, or other invalid values in the selected observations.
In the worksheet, select the cells containing the three groups. Look for text entries, error values, formulas returning text, and numbers stored as text.
Select any numbers stored as text and use the warning icon's Convert to Number command, if available. Alternatively, select the affected cells and use Data > Text to Columns > Finish.
Keep group names only in the header row if you plan to include labels. Clear accidental text or invalid entries from observation cells; leave trailing cells blank where shorter groups have no observations.
Go to Data > Data Analysis > ANOVA: Single Factor. Select the range containing the groups, choose Grouped By: Columns, and check Labels in First Row only if the selected range includes headers.
Select an Output Range or New Worksheet Ply, then click OK to run the analysis.

Review ANOVA source data with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. Open compatible Excel files to review and edit group data as you move between office suites; use Excel to troubleshoot its Analysis ToolPak error.

Frequently Asked Questions
Can Excel run a one-way ANOVA with unequal sample sizes?
Yes. ANOVA: Single Factor supports groups with different numbers of observations. Leave unused trailing cells blank rather than filling them with zeros.
Should I include group headers in the ANOVA input range?
You can include headers when the groups are in columns. In Data > Data Analysis > ANOVA: Single Factor, check Labels in First Row if the selected range includes them.
How can I convert numbers stored as text?
Select the affected cells and choose Convert to Number from the warning icon, if it appears. You can also try Data > Text to Columns > Finish.
Why does a cell that looks blank cause a problem?
It may contain a formula that returns an empty text string or another non-numeric value. Select the cell and check the formula bar; clear or correct the entry if it is not an observation.




