Welcome to WebmasterWorld Guest from 54.159.179.132

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Detect random answers

Rows of suscpiciously similar questionnaire answers

   
10:10 pm on Mar 29, 2006 (gmt 0)

10+ Year Member



Hi

I have a PHP/MySQL quiz/questionnaire and want to detect random or missing responses.

Something like "SELECT IF {MORE THAN 3 ZEROS IN A ROW} OR {MORE THAN 5 'YES' IN A ROW}"

Any suggestions? Would doing this at the SQL query be most efficient?

Many thanks in advance,

Ed

2:12 am on Apr 1, 2006 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Well, an SQL query means that you have to write the data to the table before you query it. Do you care that the user has supplied these random answers before or after the fact?
8:58 am on Apr 1, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You have to write an SQL Query entertaining the requirements.
9:23 am on Apr 2, 2006 (gmt 0)

10+ Year Member



Sorry yes, I want to detect them *after* they have been put in the table.
9:35 am on Apr 2, 2006 (gmt 0)

10+ Year Member



Forget SQL and get down to some basic statistics. You can never be sure whether someone is or isn't filling in your form in good faith, even if they put down five 0s in a row (or some other such 'indicator'). If you get enough respondents all the outliers will fade into background noise.
2:41 pm on Apr 2, 2006 (gmt 0)

10+ Year Member



In fact there are statistical analyses of random responding, which I am referring to for this purpose. I would still like to know how to detect strings of the same number - the interpretation is a seperate issue.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month