There was some chatter in our mod room about the answer rate, currently at 58%. I've made the argument before that such a low number is natural, and even good, for a site like this:
% Answered
I detest this statistic for this site. In fact, I like it rather low. Yes, if it was 40% I would be worrying. But if it was 90%, I would be suspicious that most of the questions here were too easy - not scoped well enough to be specific.
In my view, the reason this number is low compared to other sites is that we want very specific questions - and sometimes (often!) software simply doesn't exist that fulfills all the requirements people put in their question. This is a good thing, as it means our questions are very specific!
A few things have changed since 90 days into the beta, but I still stand behind the main point there: Our % answered will and should be lower than most sites, due to the quality requirements we have for questions.
That said, it'd still be nice if it was higher. 58% isn't a terribly good number. How do we make it higher? Get experts who know about the software.
I put together this query to understand where the problem lies. It gets all the tags with >50 questions, and calculated what percent is unanswered*:
I noticed something right away here - the top offenders seem to be software development type tags. I downloaded the data and put it in a spreadsheet, classifying each tag as either "Stack Overflow-type" or "Super User-type".
Notably, for SO-type tags, our unanswered rate is 42.71%. Compare that to the rate for SU-type tags, 33.6%.
Overall, this is the lowest rate on the network. As I said, I think at least part of this is inherent to the type of site we're running and the quality we require of questions. Still, we could do with more experts.
The difference between the unanswered rate for SO-type questions and SU-type questions seems to be significant. So, my question to you:
Is this number anything to worry about? If so, how can we better reach experts, especially in the software development field?
* Note that my definition of 'unanswered' here is "doesn't have any answers", which is different than the one used to calculate the Area 51 statistic. Also, this is counting closed questions.
ROUND(CAST(COUNT(*) as float)*100/CAST(total_count.total_count as float),1) as percent_unanswered
in line 4 of your query.*100
, that's the important part: e.g. for c#, it's not 0.58% unanswered, but 58% :)