# What is the average rep on Stack Overflow?

Just the other day I happened to notice that Jon Skeet has more badges than I have rep. Ouch.

So how much rep does the average SO user have?

-
Also, what is the median & standard deviation? – Pete Jul 23 '09 at 3:57
@Pete: The standard deviation will be large (probably quite a bit larger than the mean) because the distribution of rep scores is highly skewed, and anything but 'Normal' (which is what mean and standard deviation are most useful for characterizing). – Jonathan Leffler Dec 15 '13 at 20:14
There are roughly 1.5 M users with rep of 1; there are roughly 1.2 M users with a larger rep. ...Is it just me, or is there a problem accessing statoverflow.com? I'm getting blblm.ly pages in various forms... – Jonathan Leffler Dec 31 '13 at 0:44
...which means the median rep is 1! – AndrewC Feb 21 '14 at 16:01
Currently he is on 9,714 badges (254 + 4011 + 5449) to save people the bother of looking. – Martin Smith Feb 21 '14 at 17:06

Using the query from Shadow Wizard slightly modified as of this writing returns an average of 125 over about 4M users:

``````select avg(reputation), count(*) from users
``````

The score at the top of the third quartile is 11:

``````with tmp as (
select reputation, qt=NTILE(4) over (order by reputation),
rn=ROW_NUMBER() over (order by reputation)
from users)
select reputation
from tmp
where rn in (select max(rn) from tmp group by qt)
``````

Looking at just the top ~1M users with scores higher than 11, the quartile maxima are 23, 51, 164, and 759633:

``````with tmp as (
select reputation, qt=NTILE(4) over (order by reputation),
rn=ROW_NUMBER() over (order by reputation)
from users where reputation > 11)
select reputation
from tmp
where rn in (select max(rn) from tmp group by qt)
``````

So, if you have a score higher than 164 you are in the top 1/16 of all users, a select group of about 250K people.

-

The median is 1 which makes sense as more than half of the registered users have a reputation of 1.

Excluding users with reputation of 1 or less, the median was 21 which seemed skewed. Then, I checked the median between 100 and 100,000 which is 351. Click here to see the median query in action.

-

Using Data Explorer (which was created some time after this question was posted), I executed Shog9 query to get result of: 132

Looks like the average reputation in ever decreasing, with more and more new users added.

-

I think the Median rep would tell you more than the mean.

(There are many types of averages to choose from.)

You may wish to exclude users with only 1 rep, or to exclude all users that have never ask a question or given an answer.

-
As Jonathan Leffler said, "There are roughly 1.5 M users with rep of 1; there are roughly 1.2 M users with a larger rep.", which makes the median rep 1, so I think we definitely want to exclude users with only 1 rep. – AndrewC Feb 21 '14 at 16:04

According to the June data dump...

``````Select Avg(reputation) From users
``````

...it's 182.93 (using Kyle's sqlite import of the dump).

Ian's excellent statoverflow tool OTOH, produces 194.0018

Ian also suggests excluding users with a reputation of 1. With that done, you could say that the average reputation, for users who have reputation, is 358.9613!

-
Is that registered users only? – phenry Jul 23 '09 at 3:24
Did you use statoverflow? – jjnguy Jul 23 '09 at 3:25
statoverflow gives me 194.0018. WTH? – Shog9 Jul 23 '09 at 3:27
of course, this would be heavily weighted by the large number of users with a reputation of 1 – a_m0d Jul 23 '09 at 3:29
I come up with a different answer for June, statoverflow.com/sandbox/… . Not sure whose side the error lies on. Also, a somewhat more accurate portrait of the average, statoverflow.com/sandbox/… – Ian Elliott Jul 23 '09 at 3:29
Oh - and i used Kyle's sqlite import to get the result in the answer. – Shog9 Jul 23 '09 at 3:31
@Ian: ah - so that's how you make a link to it! – Shog9 Jul 23 '09 at 3:32
`Select Avg(reputation) FROM users WHERE reputation > 100` - 923.7 – jjnguy Jul 23 '09 at 3:34
Those are the people I consider to be active users. – jjnguy Jul 23 '09 at 3:35
The error could be in my side, I'll be re-factoring everything in a few days. Also the linking is kind of a hack ATM, I've integrated it along with some other things which I'll upload after I'm done midterms since I'm not completely done and the two versions are incompatible. /offtopic – Ian Elliott Jul 23 '09 at 3:38
@Ian: I haven't released a SQLite version of the latest dump, so it's a difference of old data/new data. However, this post has given me the push I needed to get back to work on it ;-) – Kyle Cronin Jul 23 '09 at 4:06
Good point on the 'active users' jinguy. But the rep value where people are considered to be active is always going to be difficult to agree on ; ) – David HAust Jul 23 '09 at 4:24
I get 182.9326 from june dump – Stu Thompson Jul 23 '09 at 10:06
if you exclude users with 1 rep - or less than 100 rep - as outliers, then you must also exclude outliers like Jon Skeet! – Steven A. Lowe Jul 23 '09 at 13:15
Select Avg(reputation) FROM users WHERE reputation between 100 and 30000 = ~886 – Dave Jarvis Jul 30 '09 at 16:27