Extreme Upvoters (95% confidence)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Electrical Engineering

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

select top 100

  [User Link],
  upvotes,
  downvotes,
  n as [Total Votes],
  cast(100* (p-pinv) as integer) as [upvote rate (min)],
  cast(100* (p+pinv) as integer) as [upvote rate (max)],
  cast(100*pinv as integer) as [plus/minus]

from (
  select
  id as [User Link],
  upvotes,
  downvotes,
  upvotes+downvotes as n,

  1.0 * upvotes / (upvotes+downvotes) as p,
  
  1.96 * sqrt(
  1.0/(upvotes+downvotes)
  * (1.0*upvotes/(upvotes+downvotes))
  * (1.0*downvotes/(upvotes+downvotes))) as pinv
  
  from users

  where
  downvotes > 10
  and upvotes > 10
) as votes

order by [upvote rate (min)] desc

Enter Parameters

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