As of now, GPT is far from being as reliable or stable as people might think. When using GPT for Excel data analysis, you often run into strange errors. Large models still have a lot of accuracy issues, which makes it hard for them to be widely used in fields like mathematical statistics where precision is key. That’s why it’s tough to rely on GPT for data analysis in the workplace.

like
Posting as :
works at
You are currently posting as works at

GPT on Excel should be used in isolation, at best, to figure out a missing piece. How to get you from A to B. Which does happen but usually down to the user not seeing the issue as several smaller issues and trying to do everything in one step.

Building a whole data model is just lazy, and at work, unacceptable. Also as a nerd, it's probably the most enjoyable part of analytics imo.

How can you provide assurance when you don't understand all the processes in your model? What happens when the data changes, etc.

An added issue I’ve noticed is consistency of output. You may get one output right once. Then you feed it the same data set and ask it to do the same analysis, and yet you get a different output. I think it’s GPT trying to learn and improve, but it’s actually unreliable at this point in time. At least the version we have.

Related Posts

Looking for possible Google referral, interested in positions out of Reston VA and Washington DC ( security clearance, DoD work)

like

I’m Looking for a flexible 100% globally Remote opportunity in either of these:

Project Management
Scrum Master
Delivery Manager
Digital Manager

Any help would be greatly appreciated🙏
Please like to push the app to share.

likesmarthelpful

🥱🥱 you can’t never trust nobody

Post Photo
like

Anyone in Chicago have recommendations for places to watch shop? Looking in the few hundred $ range. In the city today and disappointed by the selection at Nordstrom and I’m pretty sure Macy’s closed.

like

Books or websites to learn more about social media strategy, community management, and smart decision making for social?

like

Hi all, I'm planning to join Accenture. Also in the next one year, I'm planning to apply for express entry into Canada at my personal capacity. Is it easy to get transferred to Canada in such cases? Accenture Accenture India

like

“The shaft is not always welcome, but but hole always is.”

likefunny

I recently joined TW some months back and I dont know why I think have made a wrong choice for myself. I am feeling like I am lost. I am not able to fit in in this high expectations environment. I am used to working in a place where we always worked by taking help from others and here it is sort of assumed that we would be knowing everything right from day 1. Also there is no pairing in my project. Any suggestions on what should be done would be welcome.

like

I know it won’t make a big difference in the payslip as it’s a taxable benefit but is it worth keeping the private medical in the UK? All this time I’ve never used it and we need to go through the NHS first anyway for pretty much everything.

like
like

On H1-B with approved I-140, currently looking out for State & Local Tax Senior/New Manager opportunity. Kindly share the leads, thank you.

like

Just found out that sperm banks pay $70 per donation. I just found my side hustle 😏

funnylike

I’ve 4+ years of experience and currently working as a Product Manager (non-tech) (1.7yoe as PM)

I’m interested in getting into MBB, at which level in MBB they will hire me?

How to prepare and what are the resources to be used for interviews/skillset?

like

Anyone familiar with Ephesoft Transact that would let me pick their brain?

like

Okay fish what is going on: I'm still eating at my caloric deficit, working out 1hr x 5-6 days / week, my measurements are smaller BUT I've gained 2kg in 2 weeks - what gives?

like

Any recommendation for a extra firm good quality mattress under $1k?

like

What laptop do people recommend getting?

I recently heard someone say that: "Wokeism is destroying academia." Curious everyone's thoughts on this...

like

For those who work in Agencies, how do you accurately identify the work capacity of your Account Management team? I’m currently comparing against account billable/number of accounts, however, there are still discrepancies. I layer on time tracking, but smaller billable accounts will sometimes be just as demanding as larger billable accounts which create profitability issues.

like

Additional Posts in Excel Genius

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

How do I compare two sheets to make sure they are identical?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal