Have you every wondered which songs are played most frequently? The play count is misleading because it is also a function of how long the song has been in your library.
I've written two scripts which compute the frequency with which played songs have been played, and then sorts them into three playlists and reports the results in corresponding text files which it puts on your desktop. One script sorts into these thirds using frequency bounds which you input yourself. The other script sorts all the songs from most frequently played to least frequently played, and then puts the top 25% in one text file (and playlist), the middle 50% in another text file (and playlist), and the bottom 25% in a third text file (and playlist).
The disadvantage of the latter method (although the lists are interesting) is that it might take awhile to run (6.25 hours on a 700 MHz eMac on a 2,200 song library). Songs which have only recently been added to your library have misleading frequencies and can tend to overpopulate your most frequent playlist, so they may be left out; a text file lists those which have been removed from the listing because of their youth. A fifth text file lists the basic age and frequency statistics of the library. You define how youthful the file is before it is left out of consideration.
I've also written a script which sums the product (play count) x (song length) to determine just how much music you've listened to...your total listening time. I've listened to 56 days worth over four years!
The scripts are interesting and fun, but perhaps a bit frivolous. They may all be found in this post of mine. Note that the first two scripts are covered in this hint; this hint covers the last three.
[robg adds: I've mirrored these three scripts [44KB] here on hints. I tested the total listening length script, but not the others. The total listening time script took a while to run -- five minutes or so on my Mac Pro for 3,800ish songs. When done, the result showed a total of 27 days. However, I reset my play counts quite often, as I use a "not often played" playlist for most of my listening. So the real figure is probably substantially higher :).]
Mac OS X Hints
http://hints.macworld.com/article.php?story=20071011212633200