5

What is the average comments length on Stack Overflow?

I'm working on my Thesis about Short Message Topic Detection (on Twitter, to be more specific) and I would like to know that for research purposes.

13

146 characters.

To get the precise value, one should use floating-point arithmetic. The query is:

SELECT AVG(CAST(LEN(Text) AS FLOAT)) FROM Comments

This gives 145.98293005330171, or very close to 146. Beware of integer division when your result is not an integer!

Interesting features in the graph of the distribution include:

  • Very few comments less than 15 chars (the UI now prevents such short comments)
  • An upturn for the longest comments, at or just below the 600-char maximum
  • A smaller upturn around 300 (I assume there used to be a 300-char limit, now removed)
6

As of now, 145.

The distribution is probably more useful, though.

4

145 characters.

http://data.stackexchange.com/stackoverflow/query/97690/average-comment-length

3

Here it is

SELECT SUM(CAST(LEN(Text) as bigint))/COUNT(*) FROM Comments;

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .