Regression in Excel issue saying some of my data is non-numeric

Copper Contributor

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?

 

1 Reply
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.