January 2012

Wolfram Alpha is a web site and also a $3.00 Android app. I’ve been working with the app for a couple days now, and the web page some of yesterday. It’s a ‘scientific knowledge base‘, and also a powerful calculator and equation solving tool. It graphs, it integrates, it differentiates, it knows what a logit is, and can convert probabilities and logits in either direction.

Wolfram Alpha can save calculated results as PDF files.

Wolfram Alpha can solve equations analytically

Useful as a knowledge base into subjects not covered in high school.

It knows what osmium tetroxide is, gives you the Lewis structure and the toxicology of the compound. It can tell you the mass of Jupiter in earth units, and can map, say, Betelgeuse or Rigel into a Hertzsprung-Russell diagram. It’s not suited to answering many programming questions, though its answer to ‘shell sort’ is interesting enough. Right now, in conjunction with Stats Inc, they’ve loaded 5 years of NFL data into the engine, so the question ‘Tony Romo passer rating’ returns a result. No such luck for ‘Babe Ruth on base percentage’. And don’t ask for ‘Jim Brown yards per carry’ either. It’s not in the engine currently.

It has a nice understanding of genealogy, can convert from any numerical base you like (so useful as a ‘programmers calculator’). The bases to be converted aren’t fixed, though base conversions of any kind give you the number in binary, octal, and hex as a by-product. In theory, you could do Mayan (base 20) or Babylonian (base 60) math.

I have a cousin that owns a pretzel shop and not so long ago, while coming up with a variety of NFL themed pretzels, my cousin and her husband came up with this one, a tebowing pretzel

A tebowing pretzel

For a while, it was pretty crazy their way.

I’ve been looking for a calculator on my Kindle Fire I could program to do logits, and found out that Wolfram Alpha can do that, and probably more. The two pictures below should explain why, if you’re into logistic regressions and logistic formulas, why Wolfram Alpha is for you.

Calculating a logit from a probability

Calculating a probability from a logit

pretty cool, that.

After the Giants victory over the Packers, I finally got up the nerve to say what my system has been saying from the start, that my predictive system markedly favors the Giants throughout the entire playoffs.

Going all the way?

The deal, of course, is a heavily favored team can lose. A team seeded 1 or 2 and favored by 70% in every game only has a 34% chance of making it through 3 games. The nature of the playoffs make it difficult for any team, even a really good team, to win it all.

That said, the Giants are favored by 75% over the San Francisco 49ers. The only advantage the 49ers hold is home field advantage. The Giants have to be considered a playoff experienced team, and they have a massive strength of schedule advantage, the same advantage that will give them precendence over either New England or Baltimore. If you choose to treat the Giants as having no playoff experience, that lowers their odds to win to a mere 58%.

Favored in the Conference Championship Round:

Giants over 49ers: 75%
NE over Ravens: 59%

Favored in the Super Bowl:

Giants over NE: 66%
Giants over Ravens: 64%
NE over 49ers: 64%
Ravens over 49ers: 65%

Odds of winning the Super Bowl:

Giants: 49%
NE: 24%
Ravens: 18%
49ers: 9%

For contrast, we’ll calculate the Pythagorean odds for these teams as well, ignoring the effects of strength of schedule, and playoff experience.

49ers over Giants: 86%

NE over Ravens: 61%

49ers over NE: 61%

And the 49ers are favored to win the Super Bowl, via Pythagoreans, by 52%.

Of course, if you’re taking these kinds of offensive metrics seriously, please note the odds of the Giants having made it this far was only 7.4% (Originally calculated as 5.4%). Consider those odds, please, before writing my little predictive system off.

Both the Giants and Denver have won today, eliminating all wild cards and leading to two #4 seeds playing at the #1 seeds. In the case of the Giants, using my formula, we have the question of whether they truly have playoff experience. If they do not, then Green Bay is favored, on average, by 56%, though the relative error of strength of schedule results allow for Green Bay being favored by as much as 73% to the Giants being favored by 63%. If the Giants are treated as if they have playoff experience, then there is a wide range of results, from Green Bay being favored by 55% to the Giants being favored by 78%, with the average result being the Giants favored by 63%. Note that home field plus Pythagoreans would favor Green Bay by 83%.

In the Case of Denver versus New England, New England has playoff experience and home field in their favor, and Denver played a tougher schedule. New England is favored by my scheme by 69%. Home field plus Pythagoreans would favor New England by 88%.

The wins by Houston and New Orleans ensure that the #3 NFC and AFC seeds will be playing the #2 seeds, and that the #1 seeds will be playing the winner of the #4-#5 game. For now we’ll simply ask: if a team has playoff experience, but a rookie quarterback, does the rookie negate that experience advantage? Houston certainly looked good in their game.


In San Francisco-New Orleans, the Saints have the advantage of playoff experience, but San Francisco has home field and a tough schedule. My code suggests the odds in this game are 50-50. In Baltimore-Houston, Baltimore has all three advantages, and is favored to the tune of a 81% chance to win.

Playoff experience is a potent effect, enough to overcome Denver’s advantages in home field and tougher schedule.

Steelers: Super Bowl last year, Away, SOS = -0.84, Pythagorean = 71.8%

Broncos: Last in playoffs 2005, Home, SOS = -0.23, Pythagorean = 35.3%

Typically in playoff games, you don’t see huge differences in offensive stats, because the teams that make it in the modern NFL tend to be good offensive teams.But Denver is nearly as bad this year as Seattle was last year (Seattle actually was worse, with a Pythagorean of 32.7%).  Treating this as a regular season game, instead of a playoff game would give PIT a 76% edge. Instead, using the playoff formula, PIT would be favored by 54%.

This playoff game is one of the more unique battles, as Houston is lacking playoff experience, as well as Matt Shaub. But with this post we’re going to introduce mods to the code we presented in our previous article, to allow us to set relative bounds on strength of schedule. The SOS effect has a large relative error, about 80%, so what happens to the odds in this matchup when we do exactly that?

Bengals: Playoff Exp 2 yrs ago, Away, SOS = -0.85, Pythagorean = 54.1%

Texans: No Playoffs ever, Home, SOS = -1.90, Pythagorean = 69.5%

Plugging these numbers into my formula, you get CIN favored by 66%. On the low end of the SOS relative, you get CIN favored by 60% and at the high end, CIN favored by 71%.  Given that 68% is what you get from playoff experience proper, the effect of Houston’s better record (and thus HFA) is roughly cancelled out by CIN’s better SOS.

So why isn’t Houston  favored  more, given their powerful offense? As stated previously, offensive metrics aren’t predictive to p = 0.05, more like p = 0.15 or so. Further, Houston had the easiest schedule in all of football. Cinncinnati also had an easy one, but not the easiest one.

Next Page »