Microsoft’s making Excel’s formulas even easier

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.

[ Parent | on HN ]

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?

[ Parent | on HN ]

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.

[ Parent | on HN ]

Re:Microsoft’s making Excel’s formulas even easier by Tams80 on Thursday December 29, 2022 @08:56PM (#34180802)

Whatever orifice you desire.

[ Parent | on HN ]

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.

[ Parent | on HN ]

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.

[ Parent | on HN ]

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.

[ Parent | on HN ]