I've been working on preparing some lectures for my upcoming semester of Business Intelligence Systems at University of Canberra, and I wanted to add in some teaching on Social Network Analysis (SNA). This is the social influence mathematical models, not looking for keywords on Facebook posts (Social Media Analysis).

I was looking through some old lecture slides from previous professors who've taught this class, and I came across an interesting statistic that kind of 'feels' right, but I was curious as to whether or not it holds true and then I realised; we have a 'social network' of sorts right here.

So the slide shown talks about the 90/9/1 rule; Business Intelligence Slide

and I was wondering; do we have any figures that show what Worldbuilding's participation model looks like? What about other stack exchange sites? It would be interesting to see if these 'real world' networks of people, all tasked with common goals, conform to this statistical assessment. From a scientific perspective, I'd even be willing to put the figures into the lecture as an objective assessment of the rule, either for or against.

I believe we have a stats and query engine of some kind, and I have to admit I've never taken the time to learn how it works or what the query language even looks like, but I just thought that from a group perspective this was an interesting idea to share in any event.

So to the question: Does Worldbuilding conform to a 90/9/1 contribution model?

  • 3
    $\begingroup$ The query engine is SEDE (Stack Exchange Data Explorer), which uses SQL. There's a tutorial. $\endgroup$ Jan 23 '19 at 0:32
  • $\begingroup$ @MonicaCellio this looks great, but is there a data dictionary lying around? I already know SQL quite well, but what I don't know is the names of all the tables and fields I want to interrogate. Ideally, even a simplified data model or ER diagram would be useful for those who want to jump right in... $\endgroup$
    – Tim B II
    Jan 23 '19 at 1:22
  • $\begingroup$ meta.stackexchange.com/questions/2677/… $\endgroup$
    – LinkBerest
    Jan 23 '19 at 3:59
  • 2
    $\begingroup$ Very coarse interpretation (since reputation is somewhat related to contribution): stackexchange.com/leagues/579/alltime/worldbuilding : out of 58227 registered users, there are 50410 users (86%) who have less than 200 rep. Of course, this doesn't include lurkers who don't have accounts at all. $\endgroup$
    – Andrew T.
    Jan 23 '19 at 6:41
  • 1
    $\begingroup$ 10% of people cause 90% of the work is a standard metric in any environment :) $\endgroup$
    – Separatrix
    Jan 23 '19 at 11:12

You must log in to answer this question.

Browse other questions tagged .