Forum Discussion
Regression in Excel issue saying some of my data is non-numeric
Get an error message when trying to run my regression analysis in Excel. Says some of my data is non-numeric. What could the issue or possible fixes be?
Column X contains 5 cells which have a "." in them. Select column X, press F5, click Special, select Constants, uncheck "Numbers" and click OK. Now hit the TAB key to move through the selected cells.