Fatal errors in MS excel 2000 when running regression

What would cause the Fatal errors in MS excel 2000 when
running the Analysis add-in( regression analysis tool)?

I am able to select Tools/Data Analysis/Regression then
choose C20 to N20 and C21 to N21 then check the labels box
and it works fine. However, if I select the actual label
that he wants to use in B20 (his label) to N20, I get the
execel.exe error "excel.exe has generated errors and will
shut down". The error happens after I hit OK in the
regression window and the data begins to pop up.

Running it the same way works on a desktop a few times
then I tried it again on the same desktop and it did not
work. Something I noticed is: on my laptop, if I put the
label and all of the numbers in a column instead of a row,
it calculates regression just fine.

I am baffled. If it were a corrupt file, it would fail all
of the time no matter where you open it. Correct? Are
there files I need to update? And then why would it work
on a laptop only after I put them in columns?

Any insight to this would be most helpful! :-)

Thank you,

findljl <anonymous@discussions.microsoft.com> wrote:
: What would cause the Fatal errors in MS excel 2000 when
: running the Analysis add-in( regression analysis tool)?

: I am able to select Tools/Data Analysis/Regression then
: choose C20 to N20 and C21 to N21 then check the labels box
: and it works fine. However, if I select the actual label
: that he wants to use in B20 (his label) to N20, I get the
: execel.exe error "excel.exe has generated errors and will
: shut down". The error happens after I hit OK in the
: regression window and the data begins to pop up.

: Running it the same way works on a desktop a few times
: then I tried it again on the same desktop and it did not
: work. Something I noticed is: on my laptop, if I put the
: label and all of the numbers in a column instead of a row,
: it calculates regression just fine.

: I am baffled. If it were a corrupt file, it would fail all
: of the time no matter where you open it. Correct? Are
: there files I need to update? And then why would it work
: on a laptop only after I put them in columns?

: Any insight to this would be most helpful! :-)

: Thank you,


I believe you will find that one of the requirements of the Data Analysis Wizard is that the
data must be in columns not rows. The wizard assumes that if the there are multiple columns
then it must be a multiple regression problem. It must confuse the hell out of the calculations
to try and solve a multiple regression problem with only two observations and a dozen varables.
It can't be done and there apparently is not enough error checking on the input side
which causes the gpf when it actually tries to calculate the necessary values.

If the data must be in rows use the =linest() function to run the regression.

Pieter Vandenberg