Remove the curve throwers
Posted: Thu May 18, 2006 10:37 am
I'm trying to calculate a time average. I have a start time and end time. I'm trying to calculate how long it took to take a quiz for a group of quiz takers. The problem is that there are couple people "throwing the curve".
How do you do it? Is there a Mysql function I should be using other than avg? Here's my exsisting query.
I would like to programatically remove the "curve throwers" before calculating the average.time (in seconds)
1
2
100
300
200
343
233
3400
340000
How do you do it? Is there a Mysql function I should be using other than avg? Here's my exsisting query.
Code: Select all
"SELECT ROUND(AVG(endtime - starttime) ) AS total FROM respondents"