Regression function in MS excel

  • Thread starter Thread starter rick
  • Start date Start date
R

rick

I am trying to use the regression function in excel and
when I run I receive the msg: Regression - Input range
contains non-numeric data.

I have changed input data to values, as opposed to
formulas, and formatted the cells as numbers. Any idea
why I am getting this msg?
 
Hi Rick,
I have changed input data to values, as opposed to
formulas, and formatted the cells as numbers. Any idea
why I am getting this msg?
Click to expand...

The numbers are seen as text by Excel.Select them all and choose Data,
text to columns, finish.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top