excel math is fine if you use the syntax correctly. Its problems are mostly assume many number inputs as dates and other performance issues. Doing math wrong is not one of them.
excel math is fine if you use the syntax correctly. Its problems are mostly assume many number inputs as dates and other performance issues. Doing math wrong is not one of them.
NewNewAugustEast@lemmy.zip 15 hours ago
No there were math errors. Was it using statistical functions? I can’t recall, I just know we had to double check everything.
addie@feddit.uk 12 hours ago
Yeah, some of the answers it produces are very questionable. The implementation of a lot of the stat functions is super-naive and not very stable in borderline cases. Take the standard deviation of three identical numbers, get an answer which is nearly-but-not-quite zero. They’ve also refused to improve their algorithms as it might break existing customer worksheets.
Knock_Knock_Lemmy_In@lemmy.world 10 hours ago
www.mrexcel.com/…/bug-with-rand-in-excel-2003/