Plans for Wait Wait Statistics Site

A bit over three years ago, I published the initial version of the Wait Wait… Don’t Tell Me! Statistics site. Since the site went live, I have made some changes and bug fixes over the years, but the general functionality hasn’t really changed. Another Wait Wait fan has taken some of the published statistics and ran and posted some analysis.

In the post, the fan mentioned the lack of any notes on which panelist had the correct bluff and which one bluffed well enough to fool the listener, as well as displaying the points breakdown for the Lightning Fill-in-the-Blank round. I have some good news and some bad news: I have collected a good number of which panelist had the correct bluff, but not for all shows nor do have I collected which panelist’s bluff was chosen. I also have the points breakdown for the Lightning Fill-in-the-Blank round for most of the shows, but not all of them.

I have been pondering a complete re-work of the statistics site for a while, including using some well-known frameworks (including: Django and CodeIgniter) to reduce the amount of writing and tweaking code, functions and/or stored procedures. Right now, it the site contains the index page with a boat-load of PHP markup, two other includes, and another script that handles the manual generation of the panelist score graphs. All of the data entry is manually done with a GUI database access tool (SQL Manager Lite for MySQL), which has been working; but, it is just not optimal or user friendly (the tables are dang close to 3NF, or third normal form).Continue reading“Plans for Wait Wait Statistics Site”

Another shout out for Wait Wait Don’t Tell Me! Stats

Another night, another perusal of website statistics collected by Google, and another mention of my Wait Wait… Don’t Tell Me! Statistics page by Peter Sagal. This time, it was a Twitter reply to another user (granted, I don’t usually frequent Twitter unless something is of interest):

@ward_hegedus An obsessive concordance of our show:

As a Wait Wait fan… w00t! I’m glad that my obsession is paying off and it is useful to all of the other Wait Wait fans out there.

Super Belated Wait Wait Woot!

It has been a while since I’ve checked out how well my site has faired on Google using their Webmaster Tools webapp. So it was surprising to see a link back to my Wait Wait… Don’t Tell Me!¬†statistics page from a blog post by the host of Wait Wait… Don’t Tell Me!, Peter Sagal… from two years ago!

In his blog post, Peter wrote:

However, such casual hostility does leave a bad taste in my mouth, so to wash it out, I take a look at this remarkable site, maintained by a fan who I shall not call obsessive, but merely devoted. Thank you, sir!

All I can say about this is:¬†“woot!”. This is enough to make up for not getting Carl Kasell’s message on my voicemail last year (as noted in an earlier post).

No Carl Kasell on My Voicemail

Being a fan of the NPR program, Wait Wait… Don’t Tell Me!, and knowing that one of their live tapings would fall on my birthday (this past Thursday), I sent an e-mail to NPR trying to be picked as a listener that could get Carl Kasell’s voice on my voice mail.

Well, I was one of the listeners that was selected, but instead of answering at least two of three news questions or limericks correctly, or to try to find the true story in the Bluff the Listener round… I was selected for the Not My Job segment (of which the chances of winning isn’t very good) with tennis legend Monica Seles. Unfortunately, Monica came up with goose eggs when trying to answer questions about the Guinness Brewing Company.

So… I won’t be getting Carl Kasell’s voice on my voice mail this time (which would have been great as a birthday present, of sorts). Instead, for the consolation prize, I get my name mentioned on the show by both Carl and Monica.

WWDTM Statistics: Updates

Over the past two weeks, I have finished entering panelist and guest scores for all of the 2005 “Wait Wait… Don’t Tell Me!” shows. Also, bar graphs have been added in the “Panelist Statistics” section to show the distribution of scores for each panelist. The updates are available at the WWDTM: Show Details and Statistics page.

I am now in the process of filling out show breakdown and notes for the 2005 shows. Once that I have finished with that, I will start to add information about the 2004 shows.

[2007-09-12] Update: show descriptions have been entered for all but a few of the 2005 shows and I am now moving on to 2004. The basic data structures for 2003 has already been put into place, with 2000-2002 to follow in the next couple of weeks.

WWDTM Statistics

As previously noted, I am an avid fan of NPR’s weekly quiz show Wait, Wait… Don’t Tell Me! (although some may call it a mini-obsession).

With that mini-obsession, I have built a database of various information and statistics about the each show, panelists and guests, and built a web page that presents the collected information and generated statistics.

So far, I have entered in some information for shows since the beginning of 2005 and am continually adding more panelist and guest scores as time allows. I am also including quick summaries and notes for each show and my rating of each show (on a scale of 10, 1 being meh, not my thing and 10 being freaking rocks!!!).

Feel free to peruse and submit any questions, corrections and comments to this blog post.