News for hackers. Stuff that matters.
Re:Results of the SQL Performance Quiz by troels on Thursday February 20, 2014 @10:24AM (#7271179)
Maybe I'm just a bit slow, but what's going on with the 50/50 "guessing score" reasoning? Surely, you should half the wrong answers as well, rather than just subtracting it from the right answers?!?
Re:Results of the SQL Performance Quiz by Robin_Message on Thursday February 20, 2014 @11:27AM (#7271645)
If proportion X (between 0 and 1) of the population knows the right answer (we'll call A, and the wrong answer B), and the other half guesses evenly, you would expect:

    A = X + (1 - X) / 2
So to calculate X, given A,

    2A = 2X + 1 - X = X + 1
    X = 2A - 1
The author implied the formula

    X = A - 0.5
which is not correct. In particular, assume everyone got the answer right (X=A=1). Then the assertion that half of the answers are correct guesses is absurd.

The correct lucky guess fraction (amount of the right answers to discard) is:

    A - X = A - (2A - 1) = 1 - A
If A is near to 0.5 (which we would expect if our model is accurate and few people know the answer, the 50% approximation the author used is about right.)
Re:Results of the SQL Performance Quiz by troels on Thursday February 20, 2014 @04:19PM (#7273684)
Thanks - Not just me then.
Re:Results of the SQL Performance Quiz by chrisoverzero on Thursday February 20, 2014 @03:35PM (#7273373)
There are two choices. If everyone guessed, the expected value is 50% correct and 50% incorrect. This is why it's 25/75 for the question with four choices.
Re:Results of the SQL Performance Quiz by civild on Thursday February 20, 2014 @10:58AM (#7271427)
If someone guessed incorrectly, they still didn't know the answer.