News for hackers. Stuff that matters.
Re:Microsoft’s making Excel’s formulas even easier by Godel_unicode on Thursday December 29, 2022 @05:12PM (#34178745)
People get really mad when you call this p-hacking, btw. I used to try and make this point to ”analysts” that I worked with, that science involves coming up with a hypothesis and then looking at the data. The response I got often enough that I’m sure it’s being taught somewhere was that you “need to let the data tell it’s own story”.

Turns out lots of people have decided what the conclusion is and are taking that conclusion and the data, and then blindly munging until they get a path which connects them.

Re:Microsoft’s making Excel’s formulas even easier by axelf4 on Thursday December 29, 2022 @05:28PM (#34178945)
As my professor said: All good statistics is done before you have looked at the data.
Re:Microsoft’s making Excel’s formulas even easier by sideshowb on Thursday December 29, 2022 @05:46PM (#34179130)
But where do you get your hypothesis from?
Re:Microsoft’s making Excel’s formulas even easier by beckingz on Thursday December 29, 2022 @06:43PM (#34179670)
your hypothetical model of reality.

But that's a lot of work so businesses don't want to pay for it.

Re:Microsoft’s making Excel’s formulas even easier by Tams80 on Thursday December 29, 2022 @08:56PM (#34180802)
Whatever orifice you desire.
Re:Microsoft’s making Excel’s formulas even easier by merouan on Thursday December 29, 2022 @08:59PM (#34180833)
True, for clean data. You can’t clean data without looking at it (a lot), though.
Re:Microsoft’s making Excel’s formulas even easier by vanviegen on Friday December 30, 2022 @03:15AM (#34183039)
If you have data that's so 'dirty' that you can't decide on the filtering rules in advance (or based on only historic data), then what you have is garbage, not data. Therefore, we could call the art of shaping this into meaningful stories garbage science.
Re:Microsoft’s making Excel’s formulas even easier by WastingMyTime89 on Friday December 30, 2022 @06:43AM (#34184153)
Tell me in a comment you have never worked with business data in your life.

Business data is full of minor inconsistencies which are not obvious until you sit in front of it. Products are sold by different units. Reporting ranges and aggregates are slightly different. Subsidiaries use categories which are close but not exactly identical.

There is generally plenty of massaging to do before you can get the information you need.

Re:Microsoft’s making Excel’s formulas even easier by SoftTalker on Thursday December 29, 2022 @07:15PM (#34179934)
> I’m sure it’s being taught somewhere was that you “need to let the data tell it’s own story”.

AWS is pushing this message on every NFL broadcast with their Next Gen Stats ads. "The data tells us all"

Re:Microsoft’s making Excel’s formulas even easier by extr on Thursday December 29, 2022 @08:43PM (#34180699)
I think a lot of times unless you are operating at hyperscale and bps matter, most business data analysis is more art than science. Ex, if you have < 200 sales in a month and you want to report this, it's totally normal to want to pull it into excel and fiddle with the numbers, make ad-hoc corrections, divide those 200 sales up in very subjective ways, etc. The smaller the company the more the reporting layer is only a weak approximation of reality, there isn't enough there to create a narrative around. "Hypothesis testing" such data is honestly a waste of time.

Of course you want to be intellectually honest about it, and I agree that cherry-picking the "right" data can be a big problem in the wrong kind of organization. I remember one time a Jr analyst I managed was asked by the CEO to create a certain chart. I was not looped in. The CEO then used that chart to convince himself and many others on the executive team to make a huge product change that ended up being a complete disaster.