Regression Analysis Error message

C

Champy58

Every time I run a multi-variable regression analysis I get the following
error message:"Regression LINEST() - function returns error. Please check
input ranges again."

If I run a single x vs y regression, the analysis completes correctly. Only
when I am running multiple x's against a single y do I get this error. Any
suggestions?
 
C

Champy58

FYI - Followup comment: This error message is not a result of having blanks
in the dataset. It is occurring with a full data field, accurately entered.
 
J

Jerry W. Lewis

Hard to say without seeing the data.

The caracterization of this group as "Excel Application Errors" in
Microsoft's Office Discussion Groups Home is easily misinterpreted. The
standard name of the group is microsoft.public.excel.crashesgpfs, and your
post has nothing to do with Excel crashing. You would have gotten an almost
immediate response had you posted the question in Worksheet Functions or
General Questions, where it would have been more on topic.

Jerry
 
J

Jerry W. Lewis

Most likely the model is numerically singular (some column is a linear
combination of the other columns, or at least nearly so). Again, without
seeing the data it is impossible to be more specific.

If your "Input X Range" is say B1:G20, then put 1's in A1:A20 and compute
=MDETERM(MMULT(TRANSPOSE(A1:G20),A1,G20))
Alternately, if you had checked "Constant is Zero" then you would just need
=MDETERM(MMULT(TRANSPOSE(B1:G20),B1,G20))
If you get a zero determinant from whichever form is appropriate, then the
model is numerically singular.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top