7

We now have a way of determining the most valuable tags! Okay, okay, so it's all a bit subjective...

The query 'Most Valuable Questions' displays the top 500 questions, sorted by votes/views, with the option to limit results to questions over a certain amount of votes.

This can be helpful in determining tags that have a high ratio of votes to views, for example, the tag shows up a lot in this list, even for higher-voted questions (much of the list at votes >= 50 is story-identification, while at votes >=70 it takes up 3 of the top 4 results, and no others).

Enjoy! and please, post anything interesting you notice as an answer.

http://data.stackexchange.com/scifi/revision/478127/613291/most-valuable-questions

A lot of people have mentioned how the data returned with this query is not representative of the majority of questions on the site, as the trend is skewed by low view-counts.

With this in mind, I edited the query to limit the results by view count, instead of vote count.

Here it is: Most Valuable Questions (Limited By Views)

4

At votes >= 0

At votes >= 20

At votes >= 100


Conclusions

  • Story identification figures strongly in the lower-voted questions
  • Star Trek and Star Wars become more valuable among higher-voted questions
  • What order are those tags in? – ibid Apr 26 '16 at 15:58
  • @ibid no order, they're just tags that I happened to notice (so yeah, it's not the most objective way of drawing conclusions...) – user32390 Apr 26 '16 at 22:42
  • Shouldn't they be put in order of most valuable to least valuable? – ibid Apr 26 '16 at 22:47
  • @ibid sure, but I really need to go through the data again and actually select the top tags, then write it up. You'll notice there's not even lord-of-the-rings in there... – user32390 Apr 26 '16 at 22:49
  • I modified the query slightly to get the total views for the questions in the results and all the questions. When setting the min score to 0, the result is 47879 views out of 75925514 total views. This is about 0.063% of all views. I'm not sure that's a representative sample. The maximum score in that category is only 21, and the maximum number of views is only 328 (very small in StackExchange terms). A question with 16 views and a score of 1 even makes it into that set! That hardly seems like one of the "most useful questions". The small number of views dominates more than anything. – jpmc26 Apr 29 '16 at 4:51
  • @jpmc26 good point. I did make a query where one could specify the number of views instead of votes, but decided against it because views aren't noticed as much as votes are. Maybe you could slightly modify mine to use views, to make it more valid? also, do you have a link to your query? – user32390 Apr 29 '16 at 5:16
  • I didn't save them, but all I did was make your query a subquery and put a SUM on the view count. (I removed the TOP and ORDER BY for the total.) – jpmc26 Apr 29 '16 at 6:22

You must log in to answer this question.