Forum Discussion
dbterrell03
Dec 07, 2021Copper Contributor
error message for input range trying to do regression analysis
While trying to input data to do a regression analysis, I keep getting an error message that says the input data contains nonnumeric data
4 Replies
Sort By
- JKPieterseSilver ContributorSelect your input data. Press F5 and click "Special". Select Constants and ONLY check the Text box. Any cell it now highlights Excel thinks it contains text.
- Renj09Copper ContributorWhat if the shortcut key F5 doesn't work? What can be the alternative?
- JKPieterseSilver Contributor
Renj09 Or click the Home tab, find the looking glass icon (Find & Select) click it and choose Goto Special