It has been a while since I checked up on the adjusted net yards per passing attempt differential stat so I decided to research it and post the results. adjusted net yards per passing attempt differential is the difference of the adjusted yards per passing attempt on offense versus that allowed on defense. To get a true adjusted yards per passing attempt stat, we use the formula explained in a book called The Hidden Game of Football. That formula, as explained on Pro Football Reference, is: (pass yards + 20*(pass TD) – 45*(interceptions thrown) – sack yards)/(passing attempts + sacks). We do this for both offense and defense for each team and then find the differential of the two to arrive at the stats you see below.
I wanted a large history to look at so I went back and compiled from 2002 through week 12 of this season. In the sortable table below I also denoted the teams that made the playoffs each year. Yellow won the Super Bowl that year, blue the loser in the Super Bowl and brown denotes that team made the playoffs.
Looking at the results so far this season, you see that the Green Bay Packers lead the way with a 4.10 differential. This easily explains their 11-0 record right now and they are certainly the team to beat at this rate. It is also second highest right now of the researched years to 2007 New England Patriots, who ended the regular season with a 4.16 differential. That Patriots team also went undefeated that season and it makes the loss to the New York Giants in the Super Bowl that year much more amazing. That game showed the true meaning of “Any Given Sunday”.
Second so far this season is the Houston Texans with an impressive 3.90 differential. They put this up without Andre Johnson for most of the season, but the loss of Matt Schaub, and now Matt Leinart, will surely see this differential come down over the remaining 5 weeks of the season unless T.J. Yates or Jake Delhomme prove me wrong. Their defense though might save the AFC South crown for them.
The Patriots and Detroit Lions are 3rd and 4th respectively. Despite the play of their secondary this year, the Patriots offense has more than made up for it. The Lions have fallen off a bit after their hot start and will have to make the playoffs as a Wild Card thanks to being in the division with the Packers, who they have to play in week 17.
The Dallas Cowboys and Pittsburgh Steelers are next respectively and very close in differential. The Steelers have put up their 1.75 stat with a 4.95 adjusted net yards per passing attempt defensive stat which is pretty amazing as they only have 7 interceptions on the season. The Cowboys are right where they need to be to win the NFC East in my opinion.
So what does this stat mean playoff wise, and more importantly about chances to win it all? Since 2002 a team that has finished in the top 5 in adjusted net yards per passing attempt differential has one the Super Bowl all but one time. The Giants being the lone defector against the Patriots in 2007, as they finished 18th that year. A team that has finished 1st or 2nd in the stat has won the Super Bowl 5 times over the last 9 seasons, with the Steelers doing that once back in 2008.
If you sort the table by years to see the playoff teams, you will see that the Steelers really look good to make the playoffs. It would likely take 3 losses in their last 5 games to not make it and you would likely be able to point to the adjusted net yards per passing attempt differential stat over the course of the last 5 games to tell the story about those losses. The San Francisco 49ers are the only team left on their schedule that has a positive differential right now with the Cincinnati Bengals being close to the dead even mark.
I will try to update these numbers over the next few weeks as I am curious to see if the Texans and Lions slide down and if the Steelers can climb near the 1.90 or greater mark. This stat truly shows how important the passing game relates to success on both the offensive and defensive side of the ball.
Let me know if you find any errors.
| TEAM | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 |
|---|---|---|---|---|---|---|---|---|---|---|
| Green Bay | 1.59 | 1.45 | -0.05 | -1.43 | 0.17 | 1.92 | 1.64 | 3.08 | 3.09 | 4.10 |
| Houston | -2.38 | -2.29 | -0.25 | -3.51 | -1.64 | -0.43 | -0.33 | 1.63 | -0.81 | 3.90 |
| Detroit | -3.03 | -2.58 | -1.04 | -0.86 | -1.39 | -1.17 | -4.14 | -4.70 | -0.45 | 1.98 |
| New England | 0.51 | 2.55 | 2.02 | 0.06 | 1.75 | 4.16 | -0.20 | 1.62 | 2.77 | 1.90 |
| Dallas | -0.92 | 0.08 | -1.65 | 0.32 | 0.42 | 2.46 | 0.67 | 1.85 | -0.15 | 1.78 |
| Pittsburgh | 0.96 | -0.33 | 2.13 | 1.92 | 0.39 | 1.54 | 2.25 | 1.33 | 2.63 | 1.75 |
| NY Giants | 1.33 | -1.89 | -1.15 | 0.44 | -0.54 | -0.68 | 1.16 | 0.35 | 0.77 | 1.67 |
| Baltimore | 0.44 | 0.12 | -0.40 | -0.87 | 2.32 | -1.91 | 1.91 | 1.16 | 1.26 | 1.31 |
| New Orleans | 0.36 | 0.92 | -0.86 | -2.00 | 1.77 | -1.07 | 1.53 | 3.21 | 0.37 | 1.12 |
| San Francisco | 0.52 | 1.14 | -2.88 | -4.52 | -1.46 | -2.98 | -0.71 | 0.04 | -0.38 | 0.99 |
| Oakland | 2.04 | -2.39 | -2.23 | -1.17 | -1.71 | -1.50 | -1.13 | -3.22 | -0.66 | 0.66 |
| Chicago | -1.63 | -1.66 | -2.44 | 0.07 | 1.28 | -1.25 | 0.02 | -1.29 | 0.10 | 0.63 |
| NY Jets | 1.28 | 0.12 | 0.87 | -0.18 | 0.23 | -1.34 | -1.00 | 0.48 | -0.07 | 0.48 |
| Tennessee | 0.49 | 2.49 | -1.22 | -1.41 | -1.76 | 0.34 | 1.65 | -0.62 | 0.21 | 0.37 |
| Atlanta | 1.05 | -3.25 | -0.92 | 0.12 | -1.82 | -1.24 | 1.05 | -0.97 | 0.97 | 0.21 |
| Cincinnati | -2.73 | -0.29 | -0.25 | 2.11 | 0.98 | 0.06 | -2.67 | 0.65 | -0.38 | -0.05 |
| Cleveland | -0.32 | -0.22 | -0.43 | -0.45 | -1.71 | 0.27 | -2.33 | -3.76 | -1.22 | -0.61 |
| Miami | 0.85 | 0.22 | -1.36 | -0.06 | -1.32 | -2.47 | 1.79 | -2.12 | -1.18 | -0.66 |
| Buffalo | -0.18 | -0.93 | 1.29 | -1.08 | 0.11 | -0.94 | -0.89 | 0.54 | -1.40 | -0.72 |
| Philadelphia | 1.38 | 0.43 | 2.43 | -0.88 | 3.06 | 0.00 | 1.24 | 2.23 | 1.05 | -0.88 |
| St. Louis | -0.93 | 0.82 | -0.52 | -0.83 | 0.82 | -2.18 | -2.94 | -4.07 | -0.76 | -1.22 |
| San Diego | -1.27 | -1.67 | 2.25 | 0.16 | 1.96 | 1.38 | 2.06 | 2.61 | 3.15 | -1.26 |
| Washington | -0.13 | -0.92 | -0.48 | 1.41 | -1.52 | 0.98 | 0.25 | -0.30 | -1.28 | -1.28 |
| Carolina | -0.56 | 0.84 | 1.36 | 2.34 | -0.15 | -1.41 | 1.29 | 0.00 | -2.55 | -1.34 |
| Seattle | 0.92 | 0.81 | 0.53 | 1.85 | -1.22 | 1.62 | -2.55 | -1.82 | -1.85 | -1.36 |
| Denver | 0.24 | -0.17 | 1.53 | 1.80 | -0.14 | 0.05 | -0.68 | 1.16 | -0.88 | -1.45 |
| Arizona | -3.05 | -2.89 | -0.90 | 0.21 | -0.48 | 0.25 | 0.31 | 0.96 | -2.17 | -1.57 |
| Jacksonville | -0.04 | -0.42 | -0.10 | 1.65 | 1.11 | 2.03 | -1.82 | -1.29 | -2.27 | -1.85 |
| Minnesota | -2.11 | 2.63 | 1.09 | 0.16 | -0.79 | -0.82 | -0.27 | 1.67 | -1.62 | -2.14 |
| Tampa Bay | 3.34 | 1.29 | 0.92 | 0.11 | -2.53 | 1.85 | 0.82 | -2.29 | 1.73 | -2.28 |
| Kansas City | 1.09 | 2.68 | -0.51 | 0.98 | 0.13 | -1.23 | -1.77 | -2.32 | 0.81 | -2.39 |
| Indianapolis | 0.44 | 2.09 | 3.69 | 3.06 | 2.92 | 3.06 | 2.03 | 2.10 | 0.42 | -3.50 |
