Counting the amount of times the leading digit is a 1, 2, 3 etc
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
eletwat9999
5 - Atom
‎02-20-2023
03:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to count how many times the leading digit in a single grouping in my file is a 1, a 2, a 3, etc... I have no idea where to start on this and would love some help!
Labels:
- Labels:
- Workflow
3 REPLIES 3
flying008
15 - Aurora
‎02-20-2023
06:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
‎02-20-2023
06:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @eletwat9999 - Please see attached. This coupled with Benford Analysis: https://en.wikipedia.org/wiki/Benford%27s_law
Benford's law, also known as the Newcomb-Benford law, the law of anomalous numbers, or the first-digit law, is an observation that in many real-life sets of numerical data, the leading digit is likely to be small. In sets that obey the law, the number 1 appears as the leading significant digit ...
Raj
16 - Nebula
‎02-20-2023
10:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
can you please share some sample data ?
