Heard about the Developer Shed December Giveaway? Peter has a method useful for all things statistical. In this article, Peter shows us how you can make use of some quick methods to generate statistics for your sites or projects in as little time as possible. Using MS Access and a little SQL code, Peter is able to devise an algorithm useful for determining this month's winner.
Lies, Damn Lies, Statistics, and SQL (Page 1 of 6 )
When I read about the Developer Shed December Giveaway Contest in the most recent newsletter a thought occurred to me; given the nature of the Developer Shed Network of sites, there should be an objective, computer-driven way of determining the winner. To remove all question of subjective bias in determining the winner I would like to suggest an algorithm to do just this. I will use the data provided by the hits statistics on the Dev Articles site. This should prove to be an ideal way to achieve an unprejudiced solution.
This article will show how these hit statistics can quickly be imported into an Access database and manipulated using SQL to objectively determine a winner. If you wish, you may perform the steps yourself or just read along.