Yet more data to get your chops around. The following is the vote distributions for the 5 images which have been voted on the most times (there was a bug early on that meant some images got rated a lot - turns out to have been very useful bug).
What I think is important to see in these is that: 1) They're single peaked 2) They're not all averaging around 5 - the first couple clearly show people largely agree on what's ugly. To me this is pleasing as it suggests that whatever problems this experiment may have, generating essentially random noise results doesn't look like being one of them. Tom +--------+---------------+ | rating | count(rating) | +--------+---------------+ | 1 | 3 | | 2 | 12 | | 3 | 8 | | 4 | 6 | | 5 | 5 | | 6 | 4 | | 7 | 1 | | 10 | 1 | +--------+---------------+ 8 rows in set (0.01 sec) mysql> select rating, count(rating) from vote where place=210279 group by rating; +--------+---------------+ | rating | count(rating) | +--------+---------------+ | 1 | 9 | | 2 | 10 | | 3 | 8 | | 4 | 4 | | 5 | 3 | | 6 | 1 | | 7 | 2 | | 10 | 1 | +--------+---------------+ 8 rows in set (0.00 sec) mysql> select rating, count(rating) from vote where place=172693 group by rating; +--------+---------------+ | rating | count(rating) | +--------+---------------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | | 4 | 3 | | 5 | 13 | | 6 | 5 | | 7 | 8 | | 8 | 2 | | 9 | 1 | +--------+---------------+ 9 rows in set (0.01 sec) mysql> select rating, count(rating) from vote where place=171381 group by rating; +--------+---------------+ | rating | count(rating) | +--------+---------------+ | 1 | 1 | | 3 | 6 | | 4 | 9 | | 5 | 8 | | 6 | 6 | | 7 | 7 | | 8 | 1 | +--------+---------------+ 7 rows in set (0.00 sec) mysql> select rating, count(rating) from vote where place=143605 group by rating; +--------+---------------+ | rating | count(rating) | +--------+---------------+ | 1 | 1 | | 2 | 1 | | 4 | 9 | | 5 | 7 | | 6 | 7 | | 7 | 6 | | 8 | 3 | | 9 | 3 | | 10 | 1 | +--------+---------------+ 9 rows in set (0.00 sec) _______________________________________________ Mailing list [email protected] Archive, settings, or unsubscribe: https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public
