Ask HN: For users with 10k+ karma, how much time do you spend on HN?

Re:Ask HN: For users with 10k+ karma, how much time do you s... by andrewmcwatters on Thursday May 25, 2023 @09:01AM (#36070181)

We’ll of course it’s a power law, but that doesn’t tell you anything about whether 5000 karma is the 20th or the 33th percentile.

[ Parent | on HN ]

Re:Ask HN: For users with 10k+ karma, how much time do you s... by zimpenfish on Friday May 26, 2023 @06:18AM (#36082250)

If I'm querying 'abetusk's SQLite data correctly, 5000 karma would be the 99.64th percentile.

    sqlite> select count(*), sum(karma > 5000), sum(karma <= 5000) from users;
    558905|2018|556887

2018 from 558905 is 0.36%. Using the stats extension from sqlean confirms it.

    sqlite> select percentile(0+karma, 99.64) from users;
    4952.0
    sqlite> select percentile(0+karma, 99.65) from users;
    5070.50800000003

[ Parent | on HN ]