Category Archives: NFL

A rules question about Super Bowl squares

I just came across the article “A Statistician Shares How To Pick Your Super Bowl Pool Like A Champ” at businessinsider.com.  The author of the article, Jill Krasny, asked edgehogs.com statistician, William Briggs, for some advice:

“You want to pick the scores that are most likely to happen, and look at historical information about how score differentials (i.e., pairings) are most realized,” Briggs said. “You shouldn’t pick squares out of the blue that happen infrequently.”

Then she offers this note:

Note: Some people pick the labels on the rows and columns only after all the boxes have been bought, making the game more random. If your office does it this way, and not all do, these statistics will still help you figure your chance of winning.

I would argue that a fundamental rule of the Super Bowl squares game is that you pick a square BEFORE the numbers have been placed on the grid.  Instead of saying “Some people” in her note, she should say “Almost all people.”  (Am I wrong about this?  I’ve never, ever seen the numbers on the board before the squares are filled in.)

The article is still of some use, though, as you get some idea of what your chances of winning are after you get your numbers.  Of course, the whole premise that the article was written on (you get to choose your numbers) is almost never true.

Finally, they looked at the last 2,822 NFL games, but if you’re interested in complete results for over 14,000 games in a pretty heat map grid format, I’ve compiled that here.

Go Pats.

Cheers.

 

A Tale of Two Bradys: It was the best of his games; it was the worst of his games

Here is an article I wrote for Significance Magazine about Tom Brady and the Super Bowl called “A Tale of Two Bradys: It was the best of his games; it was the worst of his games.”

Go Pats.

Cheers.

 

Super Bowl Squares

I received an email this morning from a friend: “Is there any sort of a statistical breakdown for which are the best numbers to have in a Super Bowl squares pool (for entertainment purposes only)?”

Now, if my friend were going to use this information to gamble, it would be highly unethical.  However, since he clearly stated that it was for “entertainment purposes only,” I feel that I can conduct a study with a clear conscience.

If he had wanted to gamble on it, here is a quick explanation of how that usually takes place.  (According to that website: “Basically, if you are at a party where you don’t have betting squares you are a Communist.”)

Anyway, using data from football-reference.com I created a ten by ten frequency table (using R, of course) of exactly how many times each outcome has occurred in the history of the NFL.  You can find the graph here.

Somethings to note:

  • 2-2 is the worst square by far.  It’s only happened 5 times in the history of the league.  The fair odds for this square are over 2800-to-1.
  • The best squares are, no surprise, 7-0 and 0-7, occurring 581 and 577 times, respectively.
  • The other great squares to have are in order, 0-3, 0-4, 4-7, and 7-4.  All of these have occurred over 480 times each.
  • These 6 outcomes (7-0, 0-7, 0-3, 0-4, 4-7, and 7-4) account for almost 23% of all the NFL games ever played.

Cheers.

NFL Conference Championship Games

I didn’t post picks form last weekend, but I would have chosen New England, Baltimore, New Orleans, and Green Bay for a record of 2-2 this past week.

-I’m going to quote myself and re-post this point (from here) because it seems very relevant:

“Last year there were 2 teams that averaged over 23 points on offense and under 18 points on defense.  They were the Green Bay Packers and the Pittsburgh Steelers who ultimately met in the Super Bowl.  This year there are three teams that meet this criteria: San Francisco 49ers, Baltimore Ravens, and Houston Texans.  So, I guess I’m taking the 49ers over the Ravens in the Super Bowl.”

Of course, based on my rankings, right now, I’m picking San Francisco over New England in the Super Bowl.

-My super bowl picks based on my rankings at the beginning of the season was New England over Atlanta.  And my pick based on my “gut” was Tampa Bay over Baltimore.

Record: 4-4

✓=Correct Pick; =Incorrect Pick


Round Teams Predicted Winner Outcome

Con NYG at SF San Francisco (55.1%)

Con Bal at NE New England (52.1%)

Div NYG at GB Green Bay (61.3%)

Div Hou at Bal Baltimore (54.1%)

Div NO at SF New Orleans (51.0%)

Div Den at NE New England (56.8%)

WC Cin at Hou Houston (51.3%)

WC Det at NO New Orleans (57.9%)

WC Atl at NYG Atlanta (55.2%)

WC Pit at Den Pittsburgh (65.6%)

Cheers.

Tebow Mania and Passer Rating

Now that the college season is over, football fans can concentrate on what really matters: Tebow-mania!  Timmy Terrific has led the Denver Broncos to the AFC Divisional Round of the NFL playoffs.  The Broncos, who started the season 1-4, turned their season around by winning 7 of their last 11 games, many in dramatic fashion, with Mr. Tebow at the helm — good enough to squeak into the playoffs at 8-8 and even earn a home playoff game.  In that game, played Sunday, January 8th, they drew the heavily favored defending AFC champs the Pittsburgh Steelers, who took an early 6-0 lead.  Denver battled back with a big second quarter, but the Steelers made their own charge and ultimately the game went to overtime.  This was the first time a playoff game had gone to overtime since the inception of new NFL overtime rules.  Previously, overtime was sudden death, with the first team to score, either a touchdown or field goal (or safety), winning the game.  Under the new rules, only a touchdown on the first possession will end the game immediately; a field goal allows the other team a chance to possess the ball.  Needless to say, Denver won the coin toss (Pittsburgh called tails) and needed only one play to score a touchdown.  The play was an 80 yard pass over the middle that went the distance.One reason this occurred was because the Steelers had been bringing a lot of defenders close to the line of scrimmage, as they did not believe Tebow could beat them with his passing ability.  It was widely believed among the “experts” that Tebow, who is one of the greatest college football players of all time, and his style of play would not translate to success in the NFL.  Many people still believe this.

I hadn’t really thought much about Tebow one way or the other until one of his stats caught my eye.  In Denver’s week 10 win over the Kansas City Chiefs, Tebow’s passer rating was 102.6 based on 2 completions in 8 attempts, good for 69 yards, 1 touchdown, and no interceptions.  For some context, 102.6 was good enough for 7th best rating among starting quarterbacks that week.  This seemed odd to me since 2 for 8, 69 yards, and 1 touchdown seems like a terrible game.

So this got me wondering: What exactly is passer rating?  This website describes the formula in detail along with some of its history, but the basics are as follows.

1. Compute completions divided by passing attempts, subtract 0.3, and multiply by 5.
2. Compute yards divided by passing attempts, subtract 3, and multiple by 0.25
3. Compute touchdowns divided by passing attempts and multiply by 20.
4. Compute interceptions divided by passing attempts, multiply this by 25, and subtract this from 2.375

If any of the results of the four parts is less than 0 or greater than 2.375, that component is rounded up or down to the respective bound.  Now, add the four, possibly rounded, components together, multiply by 100, and divide by 6.  This yields a maximum score of 158.3.  (I swear I didn’t just make all of that up; the NFL actually uses this.)

Now since I like football and I love R, I decided to do some graphical exploring with passer rating.  Since the only topic anyone wants to talk about in the NFL right now is Tim Tebow, I figured I had to look at him.  And who better to compare him to than his opponent next week, three time Super Bowl champion Patriots quarterback Tom Brady.  Using the data from their regular season games (Tebow started 11 games and came in at half time in week 5; Brady started all 16), I created these graphs for Tom Brady and Tim Tebow.  Each individual graph shows how quarterback rating would vary based on number of completions and total passing yards for a fixed number of passing attempts, touchdowns, and interceptions. The green dot in each plot represents where each quarterback actually fell that week in their game.

What stands out to me in looking at these graphs is Brady’s consistency.  The green Brady dot seems to be always in the right, upper half of the graph.  Week in and week out he puts up around 300 yards (with the occasional 517 yard game thrown in) and a completion percentage in the mid to high 60s.  In fact, Brady had a completion percentage of over 50% in every single game this season.

Tebow, on the other hand, is, to put it politely, all over the place.  In week 13, Tebow put up a nearly perfect passer rating of 149.3, which is almost 14 points higher than Brady’s best passer rating of the season.  On the other hand, Tebow had a lower passer rating than Brady’s worst passer rating, 75.4, in 5 out of the 12 games Tebow started.  So you could say that almost half of the time this season, Tebow was worse than Brady’s worst.

This all adds up to the fact that the Broncos should lose to the Patriots.  Based on the stats, Brady is too good and Tebow is too inconsistent to amount to a Denver victory.  Of course, while you may find all of this interesting, in the end none of these numbers or pretty pictures mean anything at all to Tim Tebow, who, as they say, only cares about one stat and that’s winning.

Stats In the Wild Card Weekend – SITW’s picks

Games start in a few hours minutes, and I wanted to post my picks before the games started.  So here they are.

Some Notes:

-My preseason pick for the Super Bowl base on numbers was New England over Atlanta.  That’s not crazy at all right now.  My Super Bowl pick based on my gut was Tampa Bay over Baltimore.  Well, half of that makes sense.

-Last year there were 2 teams that averaged over 23 points on offense and under 18 points on defense.  They were the Green Bay Packers and the Pittsburgh Steelers who ultimately met in the Super Bowl.  This year there are three teams that meet this criteria: San Francisco 49ers, Baltimore Ravens, and Houston Texans.  So, I guess I’m taking the 49ers over the Ravens in the Super Bowl.

Record: 2-2

✓=Correct Pick; =Incorrect Pick


Round Teams Predicted Winner Outcome

WC Cin at Hou Houston (51.3%)

WC Det at NO New Orleans (57.9%)

WC Atl at NYG Atlanta (55.2%)

WC Pit at Den Pittsburgh (65.6%)

Cheers.

NFL Rankings – After Week 17

Rankings updated as of 1/1/2012; Records updated as of  1/1/2012; CHFF rankings as of 12/28/2011

AFC NFC

Playoff team

Division Champ

Eliminated from Playoffs

 Team Rank Change Record CHFF Rank
New England 1 13-3 3
Pittsburgh 2 12-4 1
Green Bay 3 15-1 6
Baltimore 4 12-4 5
Atlanta 5 10-6 11
NY Jets 6 8-8 2
New Orleans 7 13-3 15
Chicago 8 8-8 23
Detroit 9 10-6 10
San Francisco 10 13-3 4
NY Giants 11 9-7 8
Philadelphia 12 8-8 12
San Diego 13 8-8 18
Tampa Bay 14 4-12 14
Kansas City 15 7-9 30
Seattle 16 ↑↑↑↑ 7-9 9
Oakland 17 8-8 26
Cincinnati 18 9-7 22
Dallas 19 8-8 7
Tennessee 20 9-7 19
Miami 21 6-10 13
Houston 22 10-6 20
Buffalo 23 6-10 24
Indianapolis 24 2-14 16
Denver 25 8-8 30
Washington 26 ↑↑↑↑ 5-11 28
Minnesota 27 3-13 27
Cleveland 28 4-12 21
Arizona 29 8-8 29
Jacksonville 30 5-11 25
Carolina 31 6-10 17
StLouis 32 2-14 32

BCS: My offer still stands…….if you want to contact me you can send me a tweet @StatsInTheWild.

Cheers.

NFL Rankings – After week 17 (using only games from 2011 season)

These are the NFL rankings using only data from the 2011 season.  My NFL rankings all season have used games from 2010 in my rankings.  I wanted to see how they would look if I dropped the 2010 data points.

Rankings updated as of 1/1/2012; Records updated as of  1/1/2012; CHFF rankings as of 12/28/2011.

AFC NFC

Playoff team

Division Champ

Eliminated from Playoffs

 Team Rank Seed Record CHFF Rank
Green Bay 1 1 15-1 1
San Francisco 2 2 13-3 4
Detroit 3 6 10-6 8
Pittsburgh 4 5 12-4 6
Baltimore 5 2 12-4 5
New England 6 1 13-3 3
New Orleans 7 3 13-3 2
Chicago 8 8-8 23
Houston 9 3 10-6 7
Atlanta 10 5 10-6 11
Cincinnati 11 6 9-7 9
NY Jets 12 8-8 15
Denver 13 4 8-8 16
Dallas 14 8-8 13
San Diego 15 8-8 18
Oakland 16 8-8 14
Tennessee 17 9-7 20
NY Giants 18 4 9-7 10
Seattle 19 7-9 19
Kansas City 20 7-9 26
Buffalo 21 6-10 24
Carolina 22 6-10 17
Philadelphia 23 8-8 12
Arizona 24 8-8 21
Tampa Bay 25 4-12 31
Washington 26 5-11 25
Miami 27 6-10 22
Cleveland 28 4-12 27
Minnesota 29 3-13 28
Jacksonville 30 5-11 29
Indianapolis 31 2-14 30
St. Louis 32 2-14 32

BCS: My offer still stands…….if you want to contact me you can send me a tweet @StatsInTheWild.

Cheers.

NFL Rankings After week 16

Rankings updated as of 12/22/2011; Records updated as of 6:22pm 12/24/2011; CHFF rankings as of 12/28/2011

AFC NFC

Clinched Playoff Berth

Divison Leader Division Champ

Eliminated from Playoffs

 Team Rank Change Record CHFF Rank
New England 1 12-3 3
Green Bay 2 14-1 1
Pittsburgh 3 11-4 6
Baltimore 4 11-4 5
Atlanta 5 9-6 11
New Orleans 6 12-3 2
NY Jets 7 8-7 15
Chicago 8 7-8 23
NY Giants 9 8-7 10
San Francisco 10 12-3 4
Detroit 11 10-5 8
Philadelphia 12 7-8 12
San Diego 13 7-8 18
Oakland 14 ↑↑↑ 8-7 14
Tampa Bay 15 4-11 30
Cincinnati 16 ↑↑↑↑ 9-6 9
Kansas City 17 6-9 26
Miami 18 5-10 22
Houston 19 10-5 7
Seattle 20 7-8 19
Dallas 21 8-7 13
Tennessee 22 8-7 20
Buffalo 23 6-9 24
Denver 24 8-7 16
Indianapolis 25 ↑↑↑ 2-13 30
Minnesota 26 ↑↑↑↑ 3-12 28
Cleveland 27 4-11 27
Arizona 28 7-8 21
Jacksonville 29 4-11 29
Washington 30 5-10 25
Carolina 31 6-9 17
StLouis 32 2-13 32

BCS: My offer still stands…….if you want to contact me you can send me a tweet @StatsInTheWild.

Cheers.

NFL Chernoff faces

Here are some Chernoff faces through week 16 of the 2011 NFL season.  From the graph there seems to be two classes of elite NFL teams: 1) tall skinny faces with brownish hair and 2) short, wider faces with green hair.

The first group represents teams with mainly passing offenses who score a lot of points, but also get a lot of points scored against them.  These teams are Detroit, New England, New Orleans, and Green Bay.

The other group relies more heavily on running offenses and a stingy defense to earn their wins.  These teams are Houston, Baltimore, Pittsburgh, and San Francisco.

If you look at the 2010 Chernoff faces from last year at the end of the season, you’ll notice that Green Bay has moved from being a team that won with great defense to a team that is now winning with a highly productive offense.  You should also notice that the two super bowl teams from last year, Pittsburgh and Green Bay, are located in the area of the graph that I defined as group 2.

Finally, one of the things I find most amazing about both of these graphs from 2010 and 2011 is that they demonstrate very clearly just how many penalties the Raiders are committing.  You’d think they would try to improve upon this from one year to the next, but I guess it’s just part of their “style” where, here, “style” means being one of the worst franchises of the decade.

Cheers.