Please excuse me if you're currently exercising any of these practices...
While looking at the Sprint index its obviously apparent at one point in time someone with a crazy connection (out of the norm) posted some series numbers. Well that is skewing the results IMO. You should omit the highest and lowest scores then average. To that point it would also be nice to see some sort of normal distribution (bell curve) as well as standard deviation in order to give users a much more in depth / accurate look at their results and comparisons to the index.
I sincerely appreciate the effort put forth. This site has been invaluable to me to prove my side of the "he said she said" battle with my ISP to the fact their service is sub par at best.
Welcome to the site! I love the suggestion. I need to think about how to turn that into a mySQL query now... that's actually a very complex statement to program. But it makes sense for sure. I would have to drop the top 5% and bottom 5% (for instance) then average the remainder. I doubt that mySQL has command to do that... but if it does an addition like this would only take me a few seconds to work in. Although, if the query is too heavy then I'll have to cache the results otherwise people will be waiting ... ... ... if I can do it, practically, I will.
One thing I really need to do is narrow the hosts down to their region instead of as a whole. Currently you're comparing to everyone on the host... nationwide. I have allot to do before I can work that level of complexity into the database... but I am working towards that. With this addition will come better host detection which will help with the large number of hosts being detected as 'Unknown'.
It's allot of work and I rarely look forward to database work. But it will make this site a much more powerful tool.
So many layers to this site that I have to continually update and improve on... I think need 10 more keyboards and 100 more fingers.
Kinda sad where Sprint is on the list...