Page 1 of 1
error in excel slope function
Posted: May 1st, 2004, 4:39 am
by gjlipman
for some reason, when I use the formula=SLOPE({0.03965;0.03605;0.03325},{0.0225;0.0225;0.0225}) it gives me a value of 0, whereas it should give me a value of #NA. It also seems pretty unpredictable, sometimes it gives me a 1, or anything in between. I couldn't see this problem documented anywhere on the microsoft site - does anyone know what is causing it? I guess it seems to be a flaw in the way that excel handles lines with infinite slope?Thanks,
error in excel slope function
Posted: May 3rd, 2004, 11:07 am
by Oinker
Laet night (5.2) I visited the MS Downloads site looking for upddates, patches, etc. and I vaguely remember downloaded something that acknowledged that Excel sometimes "sometimes gets it wrong" (No!....Really!?!) using SLOPE() and a few other regression like functions. Perhaps you are experienceing the same. Hope this can help you out... Usually I never read the info -- I just download the stuff and forget about it. For some reason this caught my eye...Good Luck
error in excel slope function
Posted: May 3rd, 2004, 3:22 pm
by kenzo
I had the same problem, what you need is an update: Excel 2003 KB834691.HTH
error in excel slope function
Posted: May 3rd, 2004, 9:10 pm
by gjlipman
hmmm. But I'm working in excel 2002, so that shouldn't be the problem.