amateur spreadsheeting

by: kite

Fri 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):


Barrington 67
Dover -18
Durham 36
Farmington -37
Lee 66
Madbury -6
Middleton 1
Milton -56
NwDurham -32
Rochester 82
Rolnsfrd 10
Somrwrth -33
Strafford 21
Close Window