“‘we just created one in Excel where you point to the amount column… you can go look at the visual and you see huge spikes’”

Daniel McCarville · The Audit Podcast · Ep 297: Benford's Law w/ Daniel McCarville

Play from 9:39
9:39

Audio streams from the publisher’s own feed. Verbatim does not host or copy it.

What was described

build an Excel sheet where you point to an amount column and it automatically plots the Benford digit distribution

Said nearby on the same subject

“The one piece of advice I would give is first normal form inside a table in Excel. So that means that where you've got different months across the top, you don't want different months. You want a column and then a single column of values.”
MP
Mark Proctor
FP&A Unlocked ·
How they work Share this moment
“Excel is not dead ... until we get to a point where we are building systems that are customized for that business, you're still going to have external files”
PK
Purity Kabaki
FP&A Today ·
Contrarian take Share this moment
“Ended up with hundreds of sheets of sort of emotional journeys, came back and hundreds and hundreds of different pain points… I was able to compare and see where the relationships lie”
NW
Neil Williams
This is Journey Management ·
How they work hundreds of sheets; hundreds of pain points Share this moment
“We plotted all of them, put the image into CLIP and plotted this CLIP space in 2d ... we found a big island of solutions that are not open-ended and a small island where the coolest simulations lie”
♫
Said on Machine Learning Street Talk (MLST)
Tool 260,000 rules plotted Share this moment

Moments like this, every Monday

The strongest new moments on your topics, in the speakers' own words. Free for three topics.

No card. No password. One-click unsubscribe.

Track a competitor?

Pro watches up to 25 names or phrases and emails you the morning after they are said.

See Pro, $29 a month

Verbatim quotes a short extract and links to the episode; the episode belongs to its publisher. Remove a show.