Welcome to DU!
The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards.
Join the community:
Create a free account
Support DU (and get rid of ads!):
Become a Star Member
Latest Breaking News
Editorials & Other Articles
General Discussion
The DU Lounge
All Forums
Issue Forums
Culture Forums
Alliance Forums
Region Forums
Support Forums
Help & Search
General Discussion
Showing Original Post only (View all)It Took Many Years And Billions Of Dollars, But Microsoft Finally Invented A Calculator That Is Wrong Sometimes [View all]
Not the Onion.
https://defector.com/it-took-many-years-and-billions-of-dollars-but-microsoft-finally-invented-a-calculator-that-is-wrong-sometimes
It's not AI winter just yet, though there is a distinct chill in the air. Meta is shaking up and downsizing its artificial intelligence division. A new report out of MIT finds that 95 percent of companies' generative AI programs have failed to earn any profit whatsoever. Tech stocks tanked Tuesday, regarding broader fears that this bubble may have swelled about as large as it can go. Surely, there will be no wider repercussions for normal people if and when Nvidia, currently propping up the market like a load-bearing matchstick, finally runs out of fake companies to sell chips to. But getting in under the wire, before we're all bartering gas in the desert and people who can read become the priestly caste, is Microsoft, with the single most "Who asked for this?" application of AI I've seen yet: They're jamming it into Excel.
Excel! The spreadsheet program! The one that is already very good at what it does, which is calculation and data analysis. You put some numbers in and it spits some numbers out. According to The Verge, "Microsoft Excel is testing a new AI-powered function that can automatically fill cells in your spreadsheets." Using natural language, the idea goes, you tell it what you want and then the AI will "classify information, generate summaries, create tables, and more."
If you squint a little, or just look at this through the eyes of a person or company with a vested financial interest in shoving AI products into every cranny of your life, you can sort of see the vision. Excel requires some skill to use (to the point where high-level Excel is a competitive sport), and AI is mostly an exercise in deskilling its users and humanity at large. If everything works right, you'll be able to tell the program, in words, broadly what you want it to do, rather than have to learn the formulas that already exist and have for decades, which tell the program exactly what you want it to do.
Ah, but there's a rub. Microsoft explicitly warns users that its AI function should not be used for things like "doing math" or "anything actually important":
Excel! The spreadsheet program! The one that is already very good at what it does, which is calculation and data analysis. You put some numbers in and it spits some numbers out. According to The Verge, "Microsoft Excel is testing a new AI-powered function that can automatically fill cells in your spreadsheets." Using natural language, the idea goes, you tell it what you want and then the AI will "classify information, generate summaries, create tables, and more."
If you squint a little, or just look at this through the eyes of a person or company with a vested financial interest in shoving AI products into every cranny of your life, you can sort of see the vision. Excel requires some skill to use (to the point where high-level Excel is a competitive sport), and AI is mostly an exercise in deskilling its users and humanity at large. If everything works right, you'll be able to tell the program, in words, broadly what you want it to do, rather than have to learn the formulas that already exist and have for decades, which tell the program exactly what you want it to do.
Ah, but there's a rub. Microsoft explicitly warns users that its AI function should not be used for things like "doing math" or "anything actually important":
(screensnap)

So, don't use Copilot for calculations and record-keeping,
and the value proposition (for the billions we spent on this "feature" ) is ????
And the bigger question, IMNSHO, is "Why bother with Excel at all when you can ask (insert chatbot of your choice) to just drop an answer on you?"
Personally, if accuracy matters, scrap Excel entirely.
Here are some shortcomings in data analysis:
https://mode.com/blog/best-excel-alternatives-for-data-analysts
What to rethink: Excels biggest limitations
When comparing Excel to other spreadsheet programs like Google Sheets, Zoho Sheet, or Apache OpenOffices Calc, the differences are fairly minor. But putting it up against todays best solutions for advanced data analysis shows that its limitations are pretty prohibitive:
Excel cant handle large datasets or combine different data types and formats.
Excel doesnt allow for real-time analytics, machine learning, or any cutting-edge analysis.
Its hard to track changes and comments in Excels user interface
Analysts cant build in guardrails that keep data clean and standardized.
Excel workflows arent secure enough for the modern tech stack.
When comparing Excel to other spreadsheet programs like Google Sheets, Zoho Sheet, or Apache OpenOffices Calc, the differences are fairly minor. But putting it up against todays best solutions for advanced data analysis shows that its limitations are pretty prohibitive:
Excel cant handle large datasets or combine different data types and formats.
Excel doesnt allow for real-time analytics, machine learning, or any cutting-edge analysis.
Its hard to track changes and comments in Excels user interface
Analysts cant build in guardrails that keep data clean and standardized.
Excel workflows arent secure enough for the modern tech stack.
If accuracy and accountability (being able to audit calculations for correct algorithms and for accuracy) or even SEE the algorithms! then the following are a few solid alternatives for when you need "more than a pie chart"
https://statanalytica.com/blog/open-source-data-analysis-tools/
(good article)
Python (Pandas, NumPy, Matplotlib, Seaborn)
R
Jupyter Notebooks
Octave (Matlab alternative)
and others
Key features of each, and some others, are summarized at the site.
11 replies
= new reply since forum marked as read
Highlight:
NoneDon't highlight anything
5 newestHighlight 5 most recent replies

It Took Many Years And Billions Of Dollars, But Microsoft Finally Invented A Calculator That Is Wrong Sometimes [View all]
usonian
Aug 21
OP
Thanks, usonion! Great read! I've been pointing out for years, whenever anyone idiotically compared
highplainsdem
Aug 21
#7