regression error - non-numeric data

[ajcolyer]

I am trying to do a multiple regression. My data set contains just the labels (and I've checked the label box) and hard numbers. Otherwise there is no non-numeric data, nor are there any blanks. When I do the regression I get the error "Regression - Input range contains non-numeric data."

Interestingly, when I try to enter either the Y range or the data output range, the cursor goes to one cell over from where I click.

How to I solve this and do my multiple regression?

 

[tusharm]

It's possible one of the columns (or just a single cell) contains what looks like numbers but in text form. If that's the problem, the fix would be to copy a truly empty cell (no formula, no formatting, no numbers or text -- just a really empty cell), then select all the cells containing what you believe are numbers and doing a right-click | Paste Special... | in the resulting dialog box in the Operation section, select the Add option.

 

[Lucas Ventura]

Hello guys! My name is Lucas Ventura and I'm from Brazil. This is my first post! Well... To fix this problem you must follow these steps:

1). Select the cells where you will put your data and format them as Number.

2). When you type your data, don't put this configuration >> 3.6. You must put your number in this way: 3,6. In other words, with comma.

God bless you!

Enjoy it guys!

It's possible one of the columns (or just a single cell) contains what looks like numbers but in text form. If that's the problem, the fix would be to copy a truly empty cell (no formula, no formatting, no numbers or text -- just a really empty cell), then select all the cells containing what you believe are numbers and doing a right-click | Paste Special... | in the resulting dialog box in the Operation section, select the Add option.

 

[Aladin Akyurek]

Hello guys! My name is Lucas Ventura and I'm from Brazil. This is my first post! Well... To fix this problem you must follow these steps:

1). Select the cells where you will put your data and format them as Number.

2). When you type your data, don't put this configuration >> 3.6. You must put your number in this way: 3,6. In other words, with comma.

God bless you!

Enjoy it guys!

You are welcome. But, post formatting, that is, after an entry is made, is just for eyes. Excel will keep the original formatting, unless it's really changed for example as described in the tusharm post. Also, a numeric entry like 3,6 (one with comma) is not universal. On a US system, it's rather 3.6 (with a dot).