How Accurate Was the Obama Delegate Prediction Spreadsheet?

| Mon Jun. 9, 2008 6:12 PM PDT

On February 7, an internal Obama campaign spreadsheet leaked in the press. It contained the campaign's predictions for all of the remaining primaries. Now that the primaries are over, we have the opportunity to judge the accuracy of Obama's prognosticators, who, as everyone knows by now, showed remarkable prescience in their planning this campaign season.

Below are the spreadsheet's popular vote and delegate predictions compared to actual results. The numbers show that the Obama campaign strategists were routinely too conservative: they underpredicted both the margins of their victories and their losses. They often anticipated a close to 50-50 split in a state that turned out to seriously favor one of the two candidates.

Of the states they predicted correctly, they underpredicted their margin of victory (aka were too pessimistic) in 16 states and underpredicted their margin of loss (aka were too optimistic) in six. They only overpredicted their margin of victory in two states, and never overpredicted a loss. In total, they got 24 of the 27 primaries after February 5th correct.

Of the ones the campaign got wrong, they were too hopeful in South Dakota and Indiana, where they predicted victories but suffered losses, and were too pessimistic in Maine, where they predicted a close loss but actually saw a substantial victory.

They nailed the delegate count exactly in five states, and were within one delegate in five more. They predicted their delegate count to within five delegates in 23 of the 27 primaries.

Continues Below

Continued From Above

LouisianaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction54%44%3125Results57%36%3422Difference+3%-8%+3-3

NebraskaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction60%40%159Results68%32%168Difference+8%-8%+1-1

Virgin IslandsObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction60%40%21Results90% 8%30Difference+30%-32%+1-1

WashingtonObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction60%40%4929Results50%47%5226Difference-10%+7%+4-3
Washington's numbers are complicated by the fact that the state held both a primary and a caucus.

MaineObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction49%51%1014Results59%40%159Difference+10%-11%+5-5

Democrats AbroadObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction60%40%52Results67%33%4.52.5Difference+7%-7%-0.5+0.5

Washington DCObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction58%42%96Results75%24%123Difference+17%-18%+3-3

MarylandObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction53%46%3733Results61%36%4228Difference+8%-10%+5-5

VirginiaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction50%48%4340Results64%36%5429Difference+14%-12%+11-11

HawaiiObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction52%47%119Results76%24%146Difference+24%-23%+3-3

WisconsinObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction53%46%4034Results58%41%4232Difference+5%-5%+2-2

OhioObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction46%53%6873Results44%54%6675Difference-2%+2%-2+2

Rhode IslandObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction42%57%813Results40%58%813Difference-2%+1%00

Texas primaryObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction47%51%92101Results47%51%9994Difference0%0%+7-7
Texas's numbers are complicated by the fact that the state held both a primary and a caucus.

VermontObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction55%44%96Results59%39%96Difference+4%-5%00

WyomingObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction60%40%75Results61%38%75Difference+1%-2%00

MississippiObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction62%38%2013Results61%37%1914Difference-1%-1%-1+1

PennsylvaniaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction47%52%7583Results45%55%7385Difference-2%+3%-2+2

GuamObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction55%44%22Results50%50%22Difference-5%+6%00

IndianaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction53%46%3933
Results49%51%3438Difference-4%+5%-5+5

North CarolinaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction53%45%6154Results56%41%6649Difference+3%-4%+5-5

West VirginiaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction43%55%1315Results25%67%820Difference-18%+12%-5+5

KentuckyObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction42%56%2328Results30%66%1437Difference-12%+10%-7+9

OregonObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction52%47%2824Results59%41%3121Difference+7%-6%+3-3

Puerto RicoObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction45%54%2530Results32%68%1738Difference-13%+13%-8+8

MontanaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction55%44%97Results56%41%97Difference+1%-3%00

South DakotaObama Pop. VoteClinton Pop. VoteObama Del.Clinton Del.Prediction57%42%87Results45%55%78Difference-12%+13%-1+1

All results numbers, both popular vote percentages and delegate counts, come from the New York Times.

Get Mother Jones by Email - Free. Like what you're reading? Get the best of MoJo three times a week.

Comments

Hmm. Seems like he was especially off in the late states of West Virginia and Kentucky, and in Puerto Rico. Any theories as to why?

Considering these were predicted back in February, Team Obama probably assumed they would have enough momentum so that Democrats in general would go with the flow. Alternatively, they might have assumed that Team HRC wouldn't be able to make a "last stand" on financial fumes.

Come on!!! And this is important why? I don't see any headlines that have significance this morning. How about reporting about the issues. Rediculous!

This was only one prediction -- there was undoubtedly updates on his original predictions as he went along. No one knows everything. The one thing we do know for certain is that whether Obama predicted it exactly, or not, no longer matters -- Obama has what it takes to stay with the plan, which he and his crew managed to predicted well enough that Obama is now the Democratic Party's nominee; instead of Hillary Clinton.

I have a small quibble. The Washington numbers are not complicated by the primary, because the primary did not matter with respect to the delegate count. So you should only include the predictions & results of the caucus, because that is the contest that mattered.

wow. when you look at this, it becomes fairly obvious that hillary never really stood a chance.

these guys were a crack team and they were on a mission from day one. the clintons never knew what hit them until way too late in the game. and it didn't help that their squad was staffed by hacks and washed up established has-beens.

So, did the Clinton campaign even bother with predictions like this? My guess is, not in this kind of detail and not with this level of research. Otherwise, they might have realized sooner that they needed to end the campaign.

Very interesting.

Kind of undercuts the scary story about how Obama "limped" to the finish line. How can it be a limp if you saw it coming months ahead of time and planned accordingly? It was all about picking your spots and sticking to your gameplan. Works in the NFL. Works in the Marines. And lookee here, it works in American politics.

You are somewhat incorrect on Washington State. The caucus was the only method that counted. The primary meant nothing and was only a test, as those of us who reside in the state know. The Obama campaign made it's prediction on the caucus, from where the delegates came. In that case, Obama won 69-31, actually overperforming.

My personal theory is he stopped campaigning against Mrs Clinton after the North Carolina victory. Much was made about her not attacking him, but little attention was paid to how he didn't attack her. He all but conceded the late states to her and stopped just short of campaigning for her. MSNBC's Chuck Todd once hinted that we might be drawing false positives from her victories because the race was basically over and there was strong turnout to show support, but not necessarily to vote against the winner. Also he is still relatively unknown and its possible the good people of West Virginia and Kentucky voted off name recognition (and for the candidate who actually came to talk to them) than for the other less ideal motives that have been attributed to them. Mayhap team Obama thought the best they could do is what they did in Pennsylvania...spend a lot of money to come within 5 pts. If that was the strategy, wouldn't make sense to not squander resources needlessly? Mr Obama has already stated he's not interested in propaganda victories and clearly the only people who were alarmed at Mrs Clinton's late victoriesor close losses were the members of the media. Just a thought, what say you?

Post new comment

Alternately, you may login to or register an account
The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <ul> <ol> <li> <blockquote> <img>
  • Lines and paragraphs break automatically.

More information about formatting options

Photo Essays

When you dial a 1-900 number, who picks up the phone?
Meet the KKK's seamstress of hate couture.
The other side of Gitmo.
A photographer’s year at Angola Prison.