amateur spreadsheetingby: kiteFri Nov 21, 2008 at 20:08:15 PM EST |
(kite beat me to it! - promoted by Dean Barker) Inspired by all the election analysis, and unable to leave a spreadsheet alone, I made a quick comparison of something I had been wondering about. I had no good reason to wonder, and I'm not sure what the results mean. I can't really even swear they're accurate, although I tried to be careful. I pasted the NHPR town-by-town data for Carol Shea-Porter and Jeanne Shaheen, manually removing the towns in which CSP was not running. But in the towns where they were both on the ballot, it looks like CSP received a total of 2700 more votes than Shaheen. I was surprised. I had actually thought Shaheen had better name recognition, and in the "Democratic tsunami" that recognition would have gotten her more votes than Shea-Porter. Guess I was wrong. Shea-Porter had higher vote totals in 52 of 79 towns. The full spreadsheet is 80 or so lines, so I don't want to post it, but I would be happy to email it. Apologies in advance if I made mistakes on this. In case anyone wants to look for patterns, here are the towns of Strafford County, and the vote differential (CSP vote minus Shaheen vote):
|