Posted: 10 February 07 9:43 pm
3679.55 miles (5921.67 kilometres)</p>
But this doesn't include the 70 odd GCA caches we have done.
But this doesn't include the 70 odd GCA caches we have done.
Free and Open Geocaching
https://forum.geocaching.com.au/
Your wish is my command.Bear_Left wrote:An average (km/cache) and a median would be interesting.caughtatwork wrote:Will be available in the next release. Slightly different numbers due to differences in the circumference of the earth in our two calculations. Close enough for what the number represents.CraigRat wrote:hey c@w, the cacher stats page looks lacking now
What do you think the computational load would be for a distance feature like that?
The median should take care of the skewing of the figures by the frequent flyer cachers.
I would too, but I don't that's going to be possible.Wingaap wrote:It'd also be interesting to see the most economical cacher ie most caches in the least distance.
Can we have standard deviation as well?An average (km/cache) and a median would be interesting.
The median should take care of the skewing of the figures by the frequent flyer cachers.
Sheesh! I only just learnt what a median was.Cached wrote:Can we have standard deviation as well?An average (km/cache) and a median would be interesting.
The median should take care of the skewing of the figures by the frequent flyer cachers.
People with a large standard deviation (SD) do more long distance trips than those with a smaller SD - there is less variation in their distances.Another way of seeing it is to consider sports teams. In any set of categories, there will be teams that rate highly at some things and poorly at others. Chances are, the teams that lead in the standings will not show such disparity, but will be pretty good in most categories. The lower the standard deviation of their ratings in each category, the more balanced and consistent they might be. So, a team that is consistently bad in most categories will have a low standard deviation indicating they will probably lose more often than win.
If none of this makes any sense, I'll have another attempt tomorrow!Dark blue is less than one standard deviation from the mean. For the normal distribution, this accounts for 68.27% of the set; while two standard deviations from the mean (blue and brown) account for 95.45%; and three standard deviations (blue, brown and green) account for 99.73%.
Code: Select all
#
STD(expr) STDDEV(expr)
Returns the population standard deviation of expr. This is an extension to standard SQL. The STDDEV() form of this function is provided for compatibility with Oracle. As of MySQL 5.0.3, the standard SQL function STDDEV_POP() can be used instead.
These functions return NULL if there were no matching rows.
#
STDDEV_POP(expr)
Returns the population standard deviation of expr (the square root of VAR_POP()). This function was added in MySQL 5.0.3. Before 5.0.3, you can use STD() or STDDEV(), which are equivalent but not standard SQL.
STDDEV_POP() returns NULL if there were no matching rows.
#
STDDEV_SAMP(expr)
Returns the sample standard deviation of expr (the square root of VAR_SAMP(). This function was added in MySQL 5.0.3.
STDDEV_SAMP() returns NULL if there were no matching rows.
Which means about 68% of your finds are within 180km.caughtatwork wrote:Hmmmmmmm.
Ahhhhhhhhhhh.
Gotcha.
I checked my result against an excel spreadsheet of all my individual distances and came out with the same number, so I'm happy that it works (even if I'm still unsure of exactly what I'm doing)
So this gets me:
40,560.54 total
6.54 median
37.18 average
180.64 std dev
within 180km of where?Cached wrote:
Which means about 68% of your finds are within 180km.
See, nice useful statistic.
caughtatwork wrote:Yeah, except that the distances aren't stored in the tables now are they. That would make life a lot easier.
It's OK, I've worked it out. If you want a sneak peek, it's up in the SVN now. See if it's right for you.
Code: Select all
Total distance between attempted caches: 27,954.12 km (44,987.80 mi)
Median distance between attempted caches: 19.95 km (32.11 mi)
Average distance between attempted caches: 58.36 km (93.92 mi)
Standard deviation distance between attempted caches: 134.53 km (216.50 mi)