Box of Data

UPDATE 11/7/2008: The Federal Election Commission has lowered it’s preliminary estimate of people who voted in the 2008 election to 122,253,622.  That’s only 61.9% of all eligible voters, which hasn’t been bested since 1964 (Lyndon Johnson over Barry Goldwater).  But the numbers remain preliminary, so I’ll revisit everything when it is finalized.  Thanks!  –frets

***

Yesterday’s election drew voters out in record numbers, if you couldn’t tell by the lines some of you experienced at your polling places.  I voted early and had to wait about 40 minutes, which isn’t so bad…but I’m not in a swing state!

Based on preliminary results, 148,218,161 million people voted.  That’s 64.1% of all eligible voters.  It may not seem like much, but that’s one for the record books, especially in these times.  That percentage has not been exceeded in our lifetime (unless you’re a hundred years old)!  You have to go back to the election of 1908 to beat it!  Back then, William Howard Taft (R-Ohio) beat William Jennings Bryan (D-Nebraska) with 321 electoral votes, and 65.4% of eligible voters cast a ballot.  Incidentally, the all-time record goes to the hotly-contested race between Rutherford B. Hayes (R-Ohio) and Samuel J. Tilden (D-New York).  Hayes eeked out a 1-point electoral victory, and 81.8% of eligible voters cast a ballot!  Talk about long lines!

Here’s a look at the voter turnout since 1960 (select the image for full-size):  Read the rest of this entry »

I woke up this morning to the joyful sound of my 3 kids sorting and trading their Halloween loot.  They had meticulously sorted their candy by type (even my 6 year-old), and gave me the idea for what you see here.  We talked about the various ways we could analyze this “data,” and the kids were pretty into it.  Of course, now that I’ve been banging away at Excel for a couple of hours, they’re nowhere to be found… Read the rest of this entry »

Ever since my last post, I’ve watched the gas price at local stations keep coming down!  What a welcome relief.  It seems like the only thing coming down faster is the stock market (ba dum bum).  But seriously folks, I wanted to see how this year stacks up against prior years, so here it is:

U.S. Gas Prices Leading up to the 2008 Election

Now THAT’s a clear downward trend prior to the elections!  There are some plausible explanations for this dramatic (possibly record-setting) drop in gas prices (other than manipulation by the powers that be).  And without corroborating evidence from prior years, I’m inclined to believe them.  Besides, President Bush already demonstrated his office’s inability to influence crude prices & supply.

Are gas prices manipulated to go down prior to a Presidential election?  My research led me to look at the national level because the data for states is difficult to ascertain, and probably irrelevant.  According to the EIA, in particular their Oil Market Basics publication, the largest variance in gas prices would occur at the regional level, largely due to supply issues.  Looking at the breakdown of what makes up the price of gas, we get the following:

Distribution and marketing are mostly the profit the local station makes.  Taxes, then, are the only portion of cost over which a state has control.  Taxes are relatively steady and typically don’t change month-to-month.  So what made sense was to look at the national level, to see if there were trends there (select the image to see it bigger):

Gas Prices and Presidential Elections, 1992 - 2007

No smoking gun here.  If anything, there seems to be a trend in recent non-Presidential election years for gas to drop prior to November (2001, 2003, 2005, and 2006).  But in contrast, gas prices in the Presidential election years have remained relatively flat or, in the case of 2004, have increased prior to Election Day.  If there were some manipulation going on, I would have expected to see a stark contrast in the trends of election and non-election years.

I have to admit, I wasn’t sure how this one would turn out; but it appears that this myth is busted.

Source: Energy Information Administration

Note: I edited this 9/29, to add the # of seconds and equate it all with $.  Amazing how much better my brain works in the morning vs. the evening.

I recently got an email forwarded to me titled The Economic Plan I Endorse, which argued that the $85B buyout of AIG should instead be given back to us taxpayers, because it would equate to $425,000 for each adult American (the email estimates 200 million adult Americans).  The argument was that, with that much money, many could payoff our mortgages and thus ease the mortgage crisis by putting actual money back into the financial system.

It’s a great thought, but the numbers don’t add up.  It would take 85 trillion –not billion–dollars ($85,000,000,000,000) to get us each a payment of $425,000.  Using the 200M US adult estimate in the email would net each of us only $425 before taxes.  A better number to use for the number of taxpayers is 130M (based on the IRS 2008 tax rebates).  That nets us each a whopping $654.

But that got me thinking…what about the $700 Billion for the economic bailout plan that just almost got passed?  Well, it works out to $5385 per taxpayer (using the 130M number).  It’s a more substancial amount of money, but not enough to pay off a large percentage of mortgages.

So, how much IS $700B?  Well, according to CNN (and thanks to the Daily Show), we now know it would buy 2000 McDonalds Apple Pies for each American.  I find that nauseating.  What about other comparisons?  How about breaths we take in a lifetime?  Not even close (nearly 615 million).  How about heartbeats in a lifetime?  Surely that must be close to or more than 700B, right?

Jamie and Rich v’s comments on another post got me looking at gas price trends before Presidential elections.  I’ve heard comments that gas prices go down prior to an election, and even suspected there may be some manipulation at work.

But as I was looking into data for THAT story, I found it fascinating to analyze the difference between the lowest and highest gas price in a given year (fluctuations).  Take a look, and remember, the data in this chart represents just the difference in gas prices each year:

Truly fascinating.  In 1993, the difference between the lowest & highest price was less than 11¢!  In 2005 we had a difference of $1.29!  It is interesting to note is that the 2001 spike was not due to the events of 9/11 affecting the market; the late Spring seasonal price was the culprit that year.  Also of note is the fact that the fluctuations really began to skyrocket after the US invasion of Iraq in 2003.

More on my research into gas prices and Presidential elections to come.

Last year, I sold my sports car for a Honda Fit.  I wanted to do something with all this mileage data I collect, so I thought comparing a full year of ownership for each car would be fun.  Little did I know how much money I’m saving since I sold that car (I guess I had a little luck with the timing).  Not surprisingly, the Fit gets ridiculously better mileage.  (I’ve also learned some hypermiling techniques which have helped in that regard.)  Click for the full size image.

Comparing mileage data and gas $ spent on two different cars

Now that the Democratic and Republican National Conventions are over, I grabbed all of the (available) speech texts from the DNC and RNC Web sites and threw them into wordle.net just for fun (yep, I’m sadistic that way sometimes).  It is hard to compare word occurrences because the Republicans don’t have nearly as many speeches available (52) as the Democrats (168).  The Reps lost a day to Gustav, but they also seem to only have the major speeches available online, whereas the Dems have everything available.

Some interesting findings in the data (hover for definitions):

The Obama-to-McCain ratio (DNC): 2.9:1
The McCain-to-Obama ratio (RNC): 8:1
The Obama-to-Bush ratio (DNC): 4.9:1
The McCain-to-Bush ratio (RNC): 88:1 Bush was only mentioned 4 times in speeches available at the RNC.
The Obama-to-Biden ratio (DNC): 9.9:1
The McCain-to-Palin ratio (RNC): 8:1

Here are the word clouds:

All DNC 2008 speeches word cloud

All RNC 2008 speeches word cloud

Here’s the top 15 words:

Here are links to the word clouds at wordle.net:

And if you haven’t had enough, I’ve linked both the DNC speech word counts and RNC speech word counts as text (csv) files.  Enjoy!