score of posts as function of length of body-text

0

Please login or register to vote for this query.

(click on this box to dismiss)

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

select CAST(log(len(Body),10) AS DECIMAL(13,1)) AS LogPostLength, avg(CAST(p.Score AS DECIMAL(10,2))) AS MeanPostScore
from Posts p join Users q on p.OwnerUserId = q.Id
where q.Reputation > 10000 and len(Body)>0
group by CAST(log(len(Body),10) AS DECIMAL(13,1))
order by CAST(log(len(Body),10) AS DECIMAL(13,1)) Asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results