Reputation-Views Pearson Coefficient

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT (AVG(CAST(Reputation AS FLOAT) * CAST(Views AS FLOAT)) - 
        AVG(Reputation) * AVG(Views)) / 
       (STDEVP(Reputation) * STDEVP(Views)) AS 
       [Reputation-Views Pearson Coefficient]
FROM   users

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results