Showing posts with label Miami Dolphins. Show all posts
Showing posts with label Miami Dolphins. Show all posts

Saturday, January 24, 2009

Super Bowl Squares

It's that time of the year, when seemingly uninterested people run around feigning interest in what is now a true American celebration - the Super Bowl.  This year's Super Bowl features the Pittsburgh Steelers and the Arizona Cardinals.  Not that anyone outside of Phoenix and Pittsburgh actually cares who is in it.  That however won't prevent Super Bowl parties from cropping up across the nation on Sunday, February 1st.  And, at most of those parties, someone will usually run around trying to get the last few stragglers to participate in the second greatest tradition of the Super Bowl - the "Super Bowl Squares" (the first has to be watching the Super Bowl commercials).  

Basically, for a small donation, you get to place your name in a 10x10 square grid.  For multiple donations, you may be able to place your name on multiple squares.  Before the actual game starts, #s from 0-9 are drawn randomly and placed across each of the 10 columns.  The same process is repeated to the left of each row.  Then the name of team 1 is drawn and placed at the top, and the second team is placed on the left.  Now you have a grid that has each of the possible last-digits of the scores of each team.  When the game ends, you look at the score, then look at the last digits of each team's score, and see whose name corresponds to that permutation and that individual wins a pre-determined amount of the accumulated donations.  This process doesn't have to be limited to the game-ending score.  Many variations exist.  For example, frequently some smaller amounts could be won based on the digit permutations at the end of each quarter.

This year, as I almost always do, I participated in one of these Super Bowl Squares.  I donated for 2 squares.  After all the squares were filled out, the #s were randomly drawn, the team's assigned, the coordinator of the game handed me my sheet.  I had drawn the following 2 permutations:

Arizona 2 - Pittsburgh 5
Arizona 8 - Pittsburgh 2

I promptly tossed the sheet in the recycling bin.

Later on, I decided to see for myself the likelihood of my winning.  

The analysis below shows the aggregated game-ending digit permutations and combinations for every NFL game played in the Super Bowl era, including playoff games.  That's 9,509 games!  That also means that there's a reasonable likelihood that the probabilities shown are close to the true probabilities.  As a matter of fact, every single permutation has been "hit" at least once.  A game ending in the 2 2 permutation has only happened once - on Sunday, December 5th, 2004 the Buffalo Bills beat the Miami Dolphins in Miami 42-32.

First, a little math.  I refer to both permutations and combinations.  There is a difference between the two.  A combination refers to a sequence or collection without regard to order.  A permutation is a combination with a specific order.  Here's an example.  Take what we commonly (and mistakenly) refer to as a "combination" lock.  We say to unlock the lock, "use combination 472".  Well, that's actually only mildly helpful.  Knowing those three #s alone we wouldn't be able to open the lock.  We need to know the specific order of that combination of #s.  In other words, is it 274, 247, 427, 472, 724, or 742.  So in this example, there is one combination.  There are six permutations.

Ok, now on to the tables and charts below.

In TABLE 1, I show all 100 permutations of game-ending scores.  So for example, one can see that the likelihood of the game ending with the winning team's score ending in a 4, and the losing team's score ending in a 3 is 2.94% (to see this, in TABLE 1, go down to the row with the digit 4, then across to the column with the digit 3).  So, this specific permutation has a 2.94% likelihood.  

If you didn't care about whether it was the winning or losing team that had the 3 or the 4 in the last digit, as long as there was a 3 and a 4, then look to TABLE 3.  TABLE 3 shows the probabilities of each combination.  As such, the 3 4 or 4 3 combination has about a 3.67% likelihood of occurring.  CHART 2 graphically illustrates what's in TABLE 3.

TABLE 2 is not meaningful in and of itself, but simply shows the probability of any given digit occurring (note that in this table, the percentages add up to greater than 100.00% since "any 7" will include for example, the "1 7" combination, that will also show up under "any 1").  CHART 1 simply illustrates what's in TABLE 2.

Let's take a look at what my chances are.  It's a little complicated so bear with me.  Remember, I have 2 specific permutations.  Ari 2/Pit 5 and Ari 8/Pit 2.  However, since I don't know ahead of time who will win the game, I need to average the 2 permutations that yield the 2 5 combination for the first scenario and the two that yield the 8 2 combination for the second.  I can do this by either going to TABLE 1, and adding the respective likelihoods of each of those permutations, or I can simply go to TABLE 3.  From TABLE 3 I can easily see that the 2 5 combination shows a likelihood of 0.36% (this is made up by the 5 2 permutation likelihood of 0.23% and adding it to the 2 5 permutation likelihood of 0.13%).  Therefore, the average expectation for the specific 2 5 permutation is 0.18%*.  For the second scenario, from TABLE 3, I can see that the likelihood of this combination is 0.28%, and hence the average expectation for the specific permutation is 0.14%.

* (Technically, I shouldn't be averaging the permutations expectations.  What I should be doing is weighing each permutation by the likelihood of Arizona (or Pittsburgh) winning or losing the game.  So for example, if the likelihood of Pittsburgh winning the game is estimated to be 70%, then a truer expectation for my specific 2 5 permutation might be 0.7*0.23% +0.3*0.13% = 0.20%.  However, if you assume that each team's likelihood of winning the game is close to 50%, then averaging is fine).

So there you have it, the combined likelihood that I would win ANYTHING is about 0.32% (0.18%+0.14%).  

Hence why I tossed the sheet.  Hope you have better permutations!  Good Luck!

Sunday, January 4, 2009

Jets-Dolphins - You Could See it Coming

I wanted to post this the day before the Jets-Dolphins season ending game.  However, I was not able to, but, the analysis still has merit.  Going into the game, looking at the way the 2008 NFL season had progressed for both the New York Jets and Miami Dolphins, you could see this coming.  The actual result was not much of a shocker as you might otherwise had been led to believe.  Take a look at the table below - in particular, look at both Brett Favre's and Chad Pennington's last 4 games, and then look at the projected performance.  I really wasn't too far off.  There's no projection that would have suggested that Favre was going to throw 3 picks.  However, you could see at least 2 picks fairly easily, given that in 80% of the games this season he had thrown at least 1 pick, and in those games, he was about 50-50 to throw more than 1 pick.

Happy New Year!

Happy 2009 Everyone!

It's been awhile since I last posted.  I was on vacation.  It made me realize how much I missed my computer, and my EXCEL database.  Anyways, I'm back, and I'll have a post tonight.  I was going to post something before the Jets-Dolphins game the last week of the season, showing how I had 'projected' a bad game for Brett Favre and a good game for Chad Pennington.  Well, my 'prediction' did come true, although my posting tonight on the subject will seem a bit hollow.  That's ok, it's the analysis that matters anyway.

Cheers.

Sunday, December 7, 2008

Crazy, Debatable and Lucky

Today, the Green Bay Packers lost at home to the Houston Texans, 24-21 on a last-second field goal.  This dropped the Packers to 5-8 for the season, and, for all practical purposes, knocked them out of the playoffs.  I'm sure the Packer faithful will start to think what might have been....

The Packers were coming off a 13-3 season, having won their division handily, and were one win away from the Super Bowl, a loss to the eventual winner, the New York Giants at home.  

Then the soap opera started.  First, Brett Favre, the Packers QB for the past 16 seasons, decided it was time to retire.  The Packers, who had drafted Aaron Rodgers in 2005, were prepared.  During the offseason, the Packers named Aaron Rodgers the starting QB for the 2008 season.  Second, Brett Favre decided he wanted to play in 2008.  Nothing wrong with that.  Only that he had "lost" his starting job to Aaron Rodgers.  No way a future hall of famer is going to be carrying a clipboard for an untested, essentially rookie QB.  Not after the season Favre just had had.  After much ballyhoo, the Packers traded Favre to the New York Jets.  In return, the Packers received a conditional draft pick.  For now, it's a fairly safe bet that it will be at least a second rounder.  The Jets, who finished a lousy 4-12 season, now having found their "saviour", then released Chad Pennington.  Of course, the woeful Miami Dolphins, having just completed a miserable 1-15 season, and desperately needing some talent, promptly picked him up.

So there we have it.  The Packers make a "crazy" move, going with untested Aaron Rodgers, over Hall of Famer Favre.  The Jets, in need of a new direction, trade for Favre and release Pennington in a debatable move.  And the Dolphins, well, got lucky.  Pennington is a dramatic improvement over any Dolphin QB.

Ok, so that's how we all thought about it back in the beginning of the season.  So, let's take a look at how the decisions panned out, in terms of their actual performances.

The table at the top of this article shows each player's stats for the 2008 season, the 2007 season, and their career #s.

First, let's start with Rodgers.

He is having a very good year, despite the team's troubles.  His QB Rating is a robust 92.1 (league average is 85.3), and his CMI is 0.560, about 0.4 standard deviations above the mean of 0.538.  Not bad for being a first-year starter.  Compare him to three other first-year starters here.

Now, let's take a look at Favre.

He had a career year in 2007.  His QB Rating of 95.7 was only exceeded in his MVP years of 1995 (99.5) and 1996 (95.8).  His third MVP year, 1997, his QB rating was 92.6.  Favre's career QB Rating (leading up to the 2007 season) was 85.0.  It has since improved to 85.9 through 13 games of the 2008 season.  In terms of his CMI, 2007 was by far and away, his best year (0.581), eclipsing his previous best of 0.561 in 1995.  Given that it had been a long time since he had put up that kind of #s, it would be reasonable to assume that it wouldn't necessarily continue into 2008.  Well, he's having a (surprisingly) outstanding year in 2008.  His QB Rating is a healthy 88.2, and his CMI is 0.577 (almost as good as last year).  Is he why the Jets have improved?  Hard to say.  Especially, when you take a look at what Pennington has done this year.

Pennington's #s:

Chad is easily having his best year since his first full year in the league, in 1992.  Back then, he produced a QB Rating of 104.2 and a CMI of 0.644.  Only Tom Brady in 2007 (0.647), and Hall of Famer Troy Aikman, back in 2003 (0.645), have had better seasons.  This year, Chad's #s are a QB Rating of 93.7, and a CMI of 0.618.  Compare these to his career #s of 89.7 and 0.578.  By the way, Pennington's career CMI of 0.578 is the all-time career NFL mark.  Next is Steve Young at 0.565.  Pennington's #s are also, needless to say, a dramatic improvement compared to those of the 2007 Dolphins (QB Rating of 67.4, and CMI of 0.484).

So, what does this all mean?  It means that the Packers weren't crazy when they decided to put their faith in Rodgers, the Jets decision is debatable in giving up a 2nd round pick in 2009, and exchanging a QB who, while having an outstanding year, is not doing as well as the QB they gave up on, and the Dolphins got awfully lucky to end up with Pennington.