last day (15 days later) » 

6:46 PM
0
Q: Has StackOverflow saved billions of dollars in programmer productivity?

SklivvzIn occasion of our 5th anniversary, John Carmack quipped: @chx @jzy @StackExchange @codinghorror SO has probably added billions of dollars of value to the world in increased programmer productivity. I believe it's a reasonable estimate: Our visit counter recently overflowed Int32: 2,147,4...

 
According to our Privileges section, you should only use comments to request clarification from the author or leave constructive criticism that guides the author in improving this post. Please review the When shouldn't I comment? section: I've cleaned up the pseudoanswers.
 
user35386
@Paul He's skeptical of the claim that billions of dollars in programmer productivity have been saved. Look at the quote.
 
user35386
@ChrisW How do you know that? It wasn't clear to me that it was made up on the spot, or that nobody would believe it is true.
 
user35386
@ChrisW That test was related to movies, and it was not the most popular answer in that meta question. Also, if we required all claims to be such that "a reasonable viewer has reason to believe it's true", we would never accept a false claim.
 
user35386
@Paul Then, ignore that and just focus on examination/verification/falsification of the claim.
 
user35386
6:46 PM
@Sklivvz The claim is that SO "probably" added billions. That seems to be a claim about a Bayesian probability. Because outside of a Bayesian interpretation, either SO did or didn't add billions of dollars. Thus, analyzing this claim requires us to assess the likelihood that SO added billions of dollars, and check if that likelihood is above 50%. That requires injection of prior probabilities, which are necessarily subjective.
 
@ChrisW I believe it's true, and as me, many others. Am I not reasonable?
@Paul It's a notable claim and I ask for evidence. It's not unanswerable or philosophical: it's a real quantity that can be measured. There is no need to be skeptical about anything. The site is about scientific skepticism which is very different from being skeptical.
@Articuno the claim is not about a bayesian probability. It's reasonable to believe that many people (including me) think that the amount of money saved by Stack Overflow is in the billions. I want to see if the evidence supports it.
As a side note: there are many scientific studies regarding specificaly stack overflow, so it's not impossible that this value has been studied.
 
user35386
Who claims that it is in the billions? The quoted claim doesn't. It claims that it is probably in the billions. That isn't just a detail. It changes substantially wha is being claimed.
 
@Articuno the claim is that a billions estimate is a realistic estimate. "Probably" supports that. I am not quite sure what the point of contention is.
 
user35386
No, the claim is that "SO probably has saved billions...". Not that billions is a realistic estimate. If the point estimate of the maximum likelihood is billions, but the variance of the posterior is non-symmetric and skewed towards lower values, that is a case in which "probably billions" is not the same thing as a "realistic estimate".
 
Oh please
your comments are completely out of place and are not helpful.
 
user35386
6:47 PM
I was trying to give a concrete example of how "probably" doesn't mean something as strong as you're assuming it does.
 
user35386
You asked what the point of contention was, so I wanted to give a hypothetical
 
"Lemon juice probably cures cancer"
^ is it a claim?
"My left shoe is probably worth billions"
 
user35386
It is, and so is "SO probably added billions..."
 
user35386
Yes these are all claims
 
user35386
So ask directly about the claim "SO probably added billions". Ask if that is true.
 
6:50 PM
Which is what I did
 
user35386
No, you ask if SO added billions, not whether it probably added billions.
 
user35386
It changes the standard of evidence
 
I didn't mention a standard of evidence. And I am not interested if Carmack is justified in saying probably
I want to know if the statement he made is sustained by evidence
 
user35386
Asking about whether it probably added billions involves beliefs and priors. Asking if it did add billions doesn't include those
 
user35386
Th statement he made included the word "probably" which changes the type of claim that is being made
 
6:52 PM
I don't think we are getting anywhere.. :-)
 
user35386
I know.
 
Then if you have a concrete suggestion I'm happy to hear it
if you don't and you think the question can't be saved, vote to close and move on :-)
 
user35386
7:04 PM
The quote claims "SO probably added billions..."; You're asking about whether SO did add billions. My suggestion would be to match your question to the claim (by asking whether SO probably added billions), or by finding an example of somebody making the stronger claim that you're asking about - that SO did add billions.
 
user35386
I don't think it's reasonable to assume that John Carmack meant to claim that "SO added billions". Why would he use the word "probably" if his intention was to make the stronger claim that SO did add billions.
 
user35386
I just really don't like it when we examine claims that stronger than they exist in the wild. It's like fighting a strawman.
 
user35386
@Sklivvz I'll suggest an edit, but not out of malice.. only to show what I would consider ideal. Feel free to revert or edit.
 
The reason why I added the rest of the blurb is because I don't want someone making a calculation off a hankerchief like I did. To get it out of the way
Now I am quite sure I'll get poor answers by would be economists (which is why I started nuking pseudo answers in comments).
 
user35386
Okay, the blurb wasn't my main issue anyway. I removed it at the same time because it seemed to be Paul's point of contention.
 
7:12 PM
Laugh, Sklivvz. I have an actual PhD in Econ from Caltech, and have had a teaching career.
 
user35386
At worst, the blurb is just a distraction. It doesn't change the claim to be examined.
 
user35386
@user33903 What does that have to do with anything?
 
I am @Paul, the guy whose comments he nuked,
 
user35386
Well, if your comments were correct, they should have been answers, referenced, and open to community moderation via the voting process.
 
Yup.
 
user35386
7:14 PM
Anyone who writes an answer in a comment is risking that they be nuked.
 
user35386
It's the nature of comments: they're not the place for answers.
 
That's fine. Your printing press, not mine.
 
user35386
@Sklivvz I deleted my comments at the post because they're obsolete given this discussion.
 
user35386
@Sklivvz Ah, I like explicitly calling that "what have I tried".
 
@user33903 I explicitly linked to the policy where pseudo answers in comments are forbidden.
Was the policy not clear to you?
 
7:22 PM
The good thing about back-of-the-envelope is that they can open discussion or serve as a draft for an elevator pitch. The bad thing is that the assumptions must be extreme in their simplifications. And, if allowed to proceed unchecked, can turn into something controversial like "contingent valuation" where saving a dolphin ends up being worth millions of dollars (would you pay $0.10 to save a dolphin?).
@Sklivvz Is this an inquisition, or a real question?
 
it's a honest question
 
It is clear.
 
user35386
The only issue remaining is whether or not John Carmack's tweet is evidence of notability (I think that's @ChrisW's issue). I don't know that we could have set-in-stone rule about how many followers make a tweet evidence of notability, but I think 112,658 is above the bar.
 
I think that Carmack is also very influential, not only notable
like CodingHorror, which I used as a notability example before: also around 100k followers
also, what he said is not very controversial (among programmers). I disagree completely with the statement that "reasonable people don't believe it" as @ChrisW said
 
user35386
Right. Also, we don't require that reasonable people believe claims in order for them to be examined.
 
7:27 PM
It is only correct by ignoring substitution effects and the law of diminishing returns.
 
user35386
That was a quote from the claim-from-a-movie test
 
@user33903 what is it that you are referring by "It"?
the claim or my calculation?
 
Both I'm afraid. SO is great, but if there were no stack overflow people would go to usenet, yahoo groups, quora, their coworker, etc.
 
yes and no
 
user35386
Movies are ostensibly fiction, so claims from them have to pass a higher bar to be considered worthy of examination here (the reasonable person's belief test). We haven't established a higher bar like that for claims around the internet.
 
7:29 PM
The classical way to prove the value of SO's service is over a billion dollars is to get someone to pay you a billion dollars for it.
 
Ah, but we don't sell our service
 
And that's where things begin to get controversial. Because when someone pays for something willingly, we know that their value for the thing was at least what they paid for it. Without that kind of data, claims about the value of a thing to a person are knowable only by less reliable means like surveys and guessing.
 
user35386
Is it wrong to assume the time saved has a value equal to what the employee is being paid?
 
How do you know time was saved, and how much?
Can the programmer do something else when he is stuck?
Most workplaces involve multitasking....
 
user35386
I don't know. My question assumed that you know that time was saved. If you can isolate that, would it be correct to value it equal to the employee's pay?
 
7:46 PM
If the next best alternative to going to SO is for a particular employee who makes $X/hour to spend time T hours, then the marginal productivity of SO could be said to be T*X. Notice how many "weasel words" are there, though.
But if the next best alternative is to read the next entry down in Google, for 3 minutes, then....
 
user35386
Right, I wanted to isolate that case, though. Whether or not that way of valuing time made sense.
 
user35386
Like say, starbucks pays an employee to clean up for 30 minutes after work. But, one day, they commission a wizard magically cause their stores to self clean. Would it be correct to say that the value of that is 0.5 hours * employee hourly rate * number of employees that would have stayed to close stores?
 
user35386
I'm not making any claims about what the actual case is. I just wanted to know if time was saved, at what rate should it be valued.
 
Well, by "particular employee" I mean least cost. For instance, if a person who makes 1/2 the salary can do it in 1.5x the time, the task could be assigned to them at a savings of 25%. An accurate valuation is typically "bottom up" from studying lots of cases, and it is case by case, so one either has to make extreme simplifying assumptions, or do a lot of case research, and it starts becoming a subject matter issue rather than economics.
let me read what you wrote there...
 
user35386
(fyi: the wizard is free)
 
7:55 PM
Yes, that is a marginal value for the case where there is an absence of alternatives. However, if 50% of the cleanup could be saved by adding a garbage can that costs $10/store, then you have an interesting alternative there that you have to work out.
For example, if the employees are paid $10/hr, and 5 spend 0.5 hours cleaning the store with 1 garbage can but only 2 are needed when there are 2 cans, and the wizard does it for free, then the marginal value added by the wizard is only $20/store not $25/store.
 
user35386
Oh, so you would compare against the best alternative, even if the company hadn't implemented or thought of it?
 
Note that in practice, with inexpensive wizardry, people may have never thought of just adding a garbage can.
Yes, that's an issue with the methodology. Similarly, if hiring a witch as a barista and making magical cleanup part of her duties would cost $5/store, the value is even less.
 
user35386
so the fact that the company hadn't implemented or thought of the more efficient solution causes them to over-estimate the value of the wizard?
 
Remember Economics, as "dismal science", often explains why we are not all rich. Everyone likes to think they have a gold mine.
Yes, that can happen.
 
user35386
Do people say the value of the wizard was always $20/store and that it was only learned that it was $20/store after somebody pointed out the garbage can alternative? Or do people say that the value of the wizard became $20/store after the garbage can alternative was pointed out?
 
user35386
8:04 PM
basically, is value objective, or subjective
 
user35386
(maybe that objective/subject simplification of my question isn't accurate)
 
@Sklivvz "I disagree completely with the statement that "reasonable people don't believe it" -- The topic may be true (or not). But IMO the claim is so flippant that people are not led to or even meant to believe it just of that claim -- it's a joke or stab in the dark, a quip, a wild-ass guess.
... just because of ...
 
user35386
@ChrisW What is our standard of flippant-ness?
 
user35386
How flippant must something be before it's thought to be not intended to be believed?
 
Well, when a question like that starts with 'people', the answer often seems self-evident. Yes, values change, and seem to be subjective rather than objective. Trade occurs because of subjective values that are different.
 
user35386
8:09 PM
Do you not think that more than a handful of his 112000 followers would be led to believe it it true?
 
user35386
@user33903 That seems inconsistent. If value is based on a comparison with the best alternative (known-or not), how would value change upon getting new information?
 
user35386
Or is there objective value (the comparison against the best, even if unknown, alternative), and subjective estimate of value (which changes as new information is gained)?
 
Value of tangible and intangible goods change all the time.
The stock market and eBay are good examples of this change in action.
 
user35386
The wizard, though, in the context of the garbage bin alternative... was the wizard's value always $20 per store? Or did it become $20 per store?
 
user35386
Sorry, I shouldn't ask you to give me economics lessons here.. :P
 
8:19 PM
The wizard, in his self interest, wouldn't reveal he was only worth $20 to the store with one garbage can.
 
@Articuno If he were accused under some Truth in Advertising law of making a reasoned claim with intent to be believed, and if I were on the jury, I'd acquit him. I'm not arguing the question should be closed as off-topic; I've downvoting it because IMHO it's not a worthwhile question.
 
Even though he is doing it for free, he appreciates the extra $5 worth of praise.,
 
user35386
ah. worthwhile-ness. okay
 
user35386
That's clearer then.
 
user35386
And I understand your downvote now.
 
8:21 PM
@user33903 I just don't follow your reasoning: the SO community and body of knowledge provides great value to programmers: before SO it would take days before one would get an answer on forums (thus killing productivity) and also the value of an answer in a forum is much lower (because forums are terrible vessels for information). Surely other companies could have provided the same service, but it's irrelevant.
In other words the ways in which SO provides value are two: answers in minutes and not days, huge replay-ability (each question gets visitied on average 100x)
 
user35386
I guess value compared to what is an important point to consider
 
In practice it's a medium by which a person can help 100 others with the effort it takes to help one
Compared to previous systems, clearly
forums, usenet
 
user35386
expertsexchange
 
that too ;-)
 
user35386
i take his main point is that there are alternatives: other websites, internal wiki's, etc., so that a minute spent on stackoverflow doesn't equal a minute saved compared to the other alternatives
 
user35386
8:25 PM
there's a discount factor, and we don't know what that is
 
user35386
or rather, that would be part of what a good answer would consider
 
And for @ChrisW, I honestly think it's a reasonable claim. I think that the facts with demonstrate the huge value of SO. But -- of course facts win over hunches. :-)
That's why I made the two points above. There are no alternatives which are equal to it
 
A lot of the simpler questions have a few pages of results on google. What is the value of SO having the top spot? A great bulk of the questions are like that. Thats one end that is worth understanding. The other end is the questions for which SO has the only answer, and it is an important answer. That might be worth understanding too. My gut feeling, as an economist, is that the latter might matter more than the former.
 
As a hunch, I've only ever met a single developer who didn't know stack overflow (my guess: he was lying). Every single developer I know uses stack overflow as the preferred resource (even if not at the top spot in google) because of the quality of the information contained
 
user35386
I don't think its popularity is in question. I just don't have a good sense of how much more efficient stackoverflow is compared to the alternatives.
 
user35386
8:30 PM
Before stackoverflow, I used IRC.
 
you can measure how long it takes to get an answer on SO, in fact we do measure it routinely
 
user35386
And then compare it to what?
 
you could compare it to other different media: forums, etc.
 
user35386
In any case, before doing any of these comparisons, a study would have to define what the comparisons would be before peeking at any of the data.
 
that would be what an economist does, right?
 
user35386
8:33 PM
I assume so. An experimental economist, at least
 
user35386
An economist with domain knowledge
 
user35386
an experimental economist with domain knowledge :P
 
Thats not obvious. Often papers are written about phenomena that need to be seen before you know what questions you want to ask about them....
 
surely the value of internet sites is something that it's amply studied
 
user35386
In this case, I think we know what the question is: how much marginal value does SO provide? The question is what comparisons will we run to determine that? How will we measure time-to-answer on SO, on forums, on IRC, which forums, which IRC channels, etc. If all those questions aren't sorted out ahead of time, it's just asking for researcher bias to be injected after having peeked at the data.
 
8:37 PM
@Sklivvz IMO you underestimate the time (finding the answer on the internet saves more than one hour of trying to figure it out unaided), and underestimate the cost of programmer time ($10/hour); but over-estimate the answers found on StackOverflow (you should divide total page views by the number of page views per visit, because it takes more than one view to find the right answer; and subtract the views of people who go there to answer questions, and of people who don't find their answer).
 
since we are not asking anybody to do this research, I think "as compared to what" is not very important
 
user35386
It's important to put your statement into meaningful context
 
which one?
 
user35386
"In other words the ways in which SO provides value are two: answers in minutes and not days, huge replay-ability (each question gets visitied on average 100x)"
 
@ChrisW oh, yeah, my calculation is all over the place. I expect it to be right within a factor of ten at best
 
8:38 PM
This preoccupation with measuring something is not really what I did as an experimental economist, which related more to explaining the workings of specialized markets, auctions, etc.
 
user35386
No measurements?
 
Hayek, I think, also had cautions about measurements and averages in "The Use Of Knowledge in Society"
 
@Articuno as compared to previous alternatives, i think those are the biggest factors or where we provide unique value
 
user35386
Right, so that's what i mean by "compared to what" being important
 
I think that's what the statement means. Cf. "Apple has provided millions with jobs by introducing the iPhone"
as compared to what is not fundamental in the sense that it's a parameter one can set in the answer
 
8:42 PM
Is that a scientific statement, or rhetoric, advocacy, and marketing?
 
user35386
Ah, yes, it would be part of a good answer. But it's critical to an answer.
 
@user33903 again, it's irrelevant to a layman. it's relevant to an expert. it's up to the expert to qualify the answer, imo
 
I'd expect thousands to be employed working on iphone, and programs for iphone. How do you get to millions? A chauffer has an iphone, so we count him too?
 
@user33903 it's a statement i just made up
 
Ah, ok.
 
8:44 PM
but one could say "as compared to what? those people would have had another job"
 
or they could have used another phone
 
right. however the fact is that the iPhone is what actually happen. SO is what actually happened.
there was some value created by the innovation. I can't really estimate it! but by my calculation it's not outright impossible that it's billions
e.g. if we had 1000 answers, each seen by 10 people, the claim would be clearly false
but we have 6 millions, each seen by 100+ people, so the claim could have legs
 
user35386
I think you're saying it's plausible enough on its face to warrant being undecided about it.
 
It is plausible enough to be an elevator pitch for additional VC funding.
 
user35386
Sure...
 
user35386
8:48 PM
But that's kind of irrelevant
 
user35386
This is skeptics, and we look at whether or not propositions are true, not whether or not they are useful.
 
Heh, we are not pitching at the moment. We are fine, thank you :-)
I don't know. I suppose VCs do calculate the values of these markets, I suppose there might be some reputable reference -- but maybe no one has thought of it.
 
The thing is, without SO, if I wanted good answers quickly, with a high chance of being correct, I'd either go to a reference site on an open source language (which costs my lookup time, not an hour), or I'd go to Oreilley Safari, which is a book search for Oreilley books, at like a fixed cost of $100+/year, but no per-search cost except my few minutes of time.
Google is often pretty good at scanning important reference sites for programmers, e.g. google "mdn CSS background color" would tend to grab from mozilla developer network, a reference site.
I get points by my name now. Wowwee. How do I make it say Paul instead of user33903?
 
change your parent account to e.g. skeptics
user33... is the name of your account on serverfault
 
user35386
i think the points by your name only happens if you post a long-enough text block
 
user35386
8:57 PM
poitns
points
points
points
points
 
says parent user Paul.... lets see what pops up....
Ah thats better
Consider the allegations that napster helped robbed the music industry of billions. A known flaw in some of the back-of-the-envelope style estimates involved assuming that all copies would have been purchased, or that each copy caused some amount of damage. This attempt to comment on the value of programmer time saved involves similar risks.
 
agreed, but that's a negative value.
one could certainly calculate the value of the internet music business
 
The modern internet music business is often $1 a song, or even less, like free or ad-supported.
So the industry changed in a way that deprived some people an easy living off the work of others.
 
a good artist can sell maybe millions of copies and there hundreds of artists. so the value is in the hundreds of millions
 
user35386
 
9:15 PM
Intrinsic theories of value, like labor theory of value, are not a serious part of a modern mathematical economics curriculum. Generally, concepts like willingness to pay (buy) and willingness to accept (sell) are part of an underlying philosophy of rational choice in econ. Finance is a bit more interested in modelling values as though they were something in themselves, with random walks and such.
Anyway, the earlier point was that there are probably some usages of SO that occur because it is free and otherwise have no value in saving time, just like there were uses of napster because it was free and otherwise the user would not have bought a music CD. These cause issues in any simplified valuation. A person browsing SO for self-training may obtain value less than or greater than their wage rate. But we'll never know since they don't pay for it.
 
user35386
@Paul I think all of this comes down to "this is a hard problem". Maybe that means the question is unanswerable until somebody does the hard work, but that doesn't make it a bad question.
 
Yes.
 
user35386
"somebody" being an economist publishing in a peer-reviewed venue
 
agreed
 
Even then I'd worry.
 
user35386
9:23 PM
But until then, we're only swinging at hypothetical methodological failures
 
This isn't measuring e or pi or the distance to the stars. The things we can clearly measure the value of, fluctuate over time. So valuing intangibles is still voodoo to me.
It doesn't matter if you can get two referees and an editor to publish it.
 
user35386
But then you'd at least have concrete assumptions and methodology to criticize
 
user35386
we have no idea what assumptions or methodology such a study would use until we see it
 
i think there are objective ways to measure it, and a bunch of quite objective experiments that can be set up
 
user35386
Also, I think this is where the "probably" might save the claim. They could perform a Bayesian analysis, and come up with a posterior probability distribution over the amount of added value.
 
9:26 PM
for example take a group of programmers and split it in half, one half being denied the use of stack overflow. give them the same problems and measure KPIs
if you measure the gain (or loss!) this way, you can probably project it over a larger set
 
SO could sponsor such work. I don't want to do it, but it could be done like this: provide some money, and/or access to the data, to a researcher, or sponsor a prize for the best paper (even as little as $500 or $1000) in a special edition of a journal. It takes some academia networking to pull this off.
 
we do help academia and give access to data already
and there are many studies, mostly around machine learning though
 
user35386
Like, learning what questions will be good questions? Or auto tagging?
 
user35386
oh, yeah, i didn't click on that the first time
 
user35386
9:32 PM
Nice,

* "What makes a good code example?: A study of programming Q&A in StackOverflow"
* "Predicting Tags for StackOverflow Posts"
 
yep. we actually have our own predictor
 
user35386
oh, i don't remember seeing it.. does it suggest tags to the asker?
 
yes, we have a 76% success rate vs 67% of the article :-)
it's on a few sites, e.g. stack overflow
 
Yes you should be able to make it better
So whats the bounce rate from SO?
 
no idea
 
9:37 PM
And can you distinguish between a bad bounce and a good bounce?
Google Analytics reports a bounce as a single page, short lived visit.
 
not reliably
right but even then... is it a bad search result or bad content?
we look at other factors, like voting, feedback etc.
 
Membership is a good sign, too....
I had a similar problem. I have a single page app in www.armdisarm.com that makes a calculation. It was getting a very high bounce rate (like 80+%) that dropped to around 40% when I added an analytics tracker to track people pushing the "begin calculation" button. Without tracking people pushing the button, I had no idea if there was relevance or not.
 
some more data here: quantcast.com/p-c1rF4kxgLUzNc
 
cool; google analytics is only beginning to do user demographics.
Of course, if you are a skeptic it is difficult to know whether to believe any of that stuff.
The hit counts, sure. Knowing a visitor makes $100k/year. not so much.
Well, I need to be on my way. Good luck with this.... SO is a valuable service and I think you can find plenty of facts to advocate and support that without inventing anything new.
 
Oh sure, good day to you (I would accept also answers to the contrary though!)
 

last day (15 days later) »