What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 140 Stack Exchange communities.

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?

share|improve this question
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

5 Answers 5

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!

share|improve this answer
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

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.

share|improve this 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

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.

Link to the query: http://data.stackexchange.com/stackoverflow/query/153748/average-reputation

share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .