Richard Warr (6/17/2013)
I wonder how 28 % got it wrong...
As only 6% selected the wrong answer it must be down to not selecting three options. If you don't read the question you won't get the point 😉
That's right. since you comment it's got worse.
Now we have 10% who selected the wrong option. As 30% got it wrong, that means 20% of people who answered selected the wrong number of options but not the wrong option, so selecting too few options was a much bigger cause of failure than selecting the wrong option. The number of answers selected is about 275% of the number of attempts, so on average people selected two and three quarter answers. About 9% of people selected both the 1st option and the third option (the incorrect option), so it seems likely that some of those 10% selected all four options, so the people not selecting the wrong option may have contributed more than two thirds of the 30% deficit in number of options selected; as option 4 had lot fewer ticks than the other correct options, I would guess that about 10% and 20% of people selected only 2 options and some more selected only 1 option.
It's a nice question, very simple and straightforward, and the number getting it wrong is rather surprising. 20% getting it wrong because they didn't bother to read the question properly is pretty sad, but not really surprising; 10% not knowing the syntax of an extremely simple select statement is amazing.