AI Agents having access to the functionality of Excel means that they won’t be wrong with the actual calculations though, since it doesn’t do 5x10 in the LLM but instead uses excels built in functions to do it.
AI and excel are a match made in heaven tbh. Same with AI and databases.
That’s funny because I grew up with math teachers constantly telling us that we shouldn’t trust them.
Normal calculators that don’t have arbitrary precision have all the same problems you get when you use floating point types in a programming language. E.g. 0.1+0.2==0.3 evaluates to false in many languages. Or how adding very small numbers to very large numbers might result in the larger number as is.
If you’ve only used CAS calculators or similar you might not have seen these too since those often do arbitrary precision arithmetics, but the vast majority of calculators is not like that. They might have more precision than a 32 bit float though.
Trillions of dollars to develop a calculator that’s wrong sometimes.
AI Agents having access to the functionality of Excel means that they won’t be wrong with the actual calculations though, since it doesn’t do 5x10 in the LLM but instead uses excels built in functions to do it.
AI and excel are a match made in heaven tbh. Same with AI and databases.
I mean, most calculators are wrong quite often
No, the user is wrong quite often, the calculator gives the answer to the question asked, not the answer to the question the user wanted to ask.
Garbage in, garbage out.
I’ve never seen a calculator being wrong, and I’m genuinely curious what you’re talking about.
That’s funny because I grew up with math teachers constantly telling us that we shouldn’t trust them.
Normal calculators that don’t have arbitrary precision have all the same problems you get when you use floating point types in a programming language. E.g. 0.1+0.2==0.3 evaluates to false in many languages. Or how adding very small numbers to very large numbers might result in the larger number as is.
If you’ve only used CAS calculators or similar you might not have seen these too since those often do arbitrary precision arithmetics, but the vast majority of calculators is not like that. They might have more precision than a 32 bit float though.
Now, that’s a fine hair to be splitting.
Only when people use the wrong input, garbage in and garbage out.
In the same vein I can’t think of any instance where excel had calculated things wrong unless there was a fault in the formula that I made.
Except if you’re calculating dates from a long time ago. It famously takes some liberties with leap years.
https://devblogs.microsoft.com/oldnewthing/20160628-00/?p=93765
https://en.m.wikipedia.org/wiki/Pentium_FDIV_bug
this one is just wrongerer