Regression Analysis Error message

[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?

 

[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.

 

[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

 

[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