Stack Overflow gets an A+ in adding value for C# programmers

The popular Q&A site saves developers of some languages more time and money than others

Last week, a post on Skeptics Stack Exchange tried to back up a claim put out there a couple of months ago by John Carmack (co-founder of id Software) that Stack Overflow (SO) “has probably added billions of dollars of value to the world in increased programmer productivity.” Using some back-of-the-envelope calculations, site moderator Sklivvz estimated that over the course of its five-year history, the popular question-and-answer site for programmers has added about $30 billion dollars worth of value. Based on this very quick estimate, Carmack’s claim seems to be supported.

As you might expect, this has generated quite a bit of discussion and debate all over the Internet. Many people think this estimate is way too simple. It makes some pretty big assumptions (e.g., each page view of an answered question saves a programmer 1 hour of time; each hour of time saved equals $20 of value added) and ignores some things such an analysis would ideally take into account (e.g., the cost of time spent answering questions). But, to be fair, Sklivvz is really providing this simple analysis to get the discussion going and to see if anyone can come up with a more rigorous answer. 

Nevertheless, this sort of quick analysis is fun to debate. So, in the spirit of that, I decided to take it a step further and add my own quickie calculations to try and see just how much value Stack Overflow adds on a per-programming-language basis. Prepare yourself for more non-rigorous statistical analysis!

Before presenting my own methods, here are the results:

Value-Added-by-Stack-Overflow-600x450_1.jpgImage credit: ITworld/Phil Johnson

Now, my methodology:

  • I looked at the top 20 programming languages as ranked by the TIOBE Programming Community Index for December 2013. Those languages, from 1 to 20, were: C, Java, Objective-C, C++, C#, PHP, (Visual) Basic, Python, Transact-SQL, JavaScript, Visual Basic .NET, Perl, Ruby, Matlab, Delphi/Object Pascal, Lisp, PL/SQL, Pascal, Assembly, F#.

  • For each of the 20 languages, I estimated the percentage of the total SO pageviews for answers to questions tagged with that language. Since I don’t have (easy) access to the actual page views per question tag, I proxied for it by multiplying the total number of page views of all questions answered by the portion of total questions answered which were tagged with that language.

  • Given the number of pageviews of questions answered per language, I then simply multiplied that by the valued added per pageview ($20, using the same value as Sklivvz).

What does this all tell us? The value added by questions answered on SO for these 20 languages accounts for slightly more than half of the total value added as found by Sklivvz ($16 billion out of $30 billion). Also, developers answering questions on Stack Overflow about C#, Java, JavaScript and PHP are providing the most added value (about $2.5 billion or more for each). Not surprisingly, SO is providing the most value for the most widely used languages. Generally, answers to questions about languages ranked higher in the TIOBE Index are providing more value than answers to questions about languages lower on the list. Of course, this is basically because more popular languages will have more questions asked (and answered) about them.

Now matter how you measure it, I think we can all agree that Stack Overflow is a big help to developers. Exactly how much is probably impossible to quantify. But, again, these back-of-the-envelope approaches are fun to discuss, if nothing else - as long as we don’t spend too much time on them, taking away from more important tasks, like reading and answering questions on Stack Overflow.

Read more of Phil Johnson's #Tech blog and follow the latest IT news at ITworld. Follow Phil on Twitter at @itwphiljohnson. For the latest IT news, analysis and how-tos, follow ITworld on Twitter and Facebook.

ITWorld DealPost: The best in tech deals and discounts.
Shop Tech Products at Amazon