Correlation/Multiple Regression

[Guest]

I'm trying to analyze numerous columns of data using both the correlation and regression functions under Tools--> Data Analysis (toolpak add-in), but I keep getting an error message telling me that some data is in non-numeric format. All of my data points are numerical (ratios, percentages, and currency), so I don't understand why Excel won't recognize the data. Any suggestions?

 

[Dave R.]

Though they are numerical, they may not be recognized as numbers..

How is the ratio written in? Also make sure the numbers, when you activate
the cell, don't have the signs in the actual value. i.e. currency should be
45001.00 even if formatted to look like $45,001.00 and percentages should
be numbers from 0 to 1.

I'm trying to analyze numerous columns of data using both the correlation

and regression functions under Tools--> Data Analysis (toolpak add-in), but
I keep getting an error message telling me that some data is in non-numeric
format. All of my data points are numerical (ratios, percentages, and
currency), so I don't understand why Excel won't recognize the data. Any
suggestions?

 

[Guest]

I tried that, and even cut out and repasted data as values, but there's still something wrong. All of the data originally came from calculations in other spreadsheets, and many have 10 digits to the right of the decimal point. Could that be affecting my analysis? All of my cells are values, not formulas. I appreciate your response. Any more suggestions?

 

[Guest]

I think I figured it out. I have a really big spreadsheet, so I had never actually scrolled through all the data to make sure it was all good. There were a few cells here and there that were blank or had "#NUM", etc. After deleting those rows, the correlation function works. Thanks to Dave R. for responding. I hope this helps others too.

 

[Dave R.]

Glad you fixed it!

I think I figured it out. I have a really big spreadsheet, so I had never

actually scrolled through all the data to make sure it was all good. There
were a few cells here and there that were blank or had "#NUM", etc. After
deleting those rows, the correlation function works. Thanks to Dave R. for
responding. I hope this helps others too.