0

Please login or register to vote for this query.

(click on this box to dismiss)

Benford's law, also called the first-digit law, states that in lists of numbers from many (but not all) real-life sources of data, the leading digit is distributed in a specific, non-uniform way. According to this law, the first digit is 1 about 30% of the time, and larger digits occur as the leading digit with lower and lower frequency, to the point where 9 as a first digit occurs less than 5% of the time. This distribution of first digits is the same as the widths of gridlines on the logarithmic scale.

Q&A for scientists using computers to solve scientific problems

-- Testing Benton's Law
-- Benford's law, also called the first-digit law, states that in lists of
-- numbers from many (but not all) real-life sources of data, the leading digit
-- is distributed in a specific, non-uniform way. According to this law, the
-- first digit is 1 about 30% of the time, and larger digits occur as the
-- leading digit with lower and lower frequency, to the point where 9 as a
-- first digit occurs less than 5% of the time. This distribution of first
-- digits is the same as the widths of gridlines on the logarithmic scale.

with data as (Select count(*) as total,
    (select max(Reputation) from Users where Reputation > 1) as MAXREP,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '1') as one,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '2') as two,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '3') as three,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '4') as four,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '5') as five,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '6') as six,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '7') as seven,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '8') as eight,
    (Select cast(Count(*) as decimal) from Users where Reputation > 10 and SUBSTRING(CAST(Reputation AS VARCHAR), 1, 1) = '9') as nine
    from Users where Reputation > 10) select
100*one/total as "1",
100*two/total as "2",
100*three/total as "3",
100*four/total as "4",
100*five/total as "5",
100*six/total as "6",
100*seven/total as "7",
100*eight/total as "8",
100*nine/total as "9",
MAXREP,
total
from data;

fork query

edited sep 27 23 anonymous

created jun 28 11 rq