I first posted this spreadsheet weeks ago in a post reply on the Barking Carnival, and I have been updating it weekly, but not posting it. Basically, I'm trying to capture the probabilities of different outcomes for the Big 12 South seasons. I use the Sagarin ratings to predict point spreads, and then use the point spreads to predict odds of winning each game. I then come up with a geometric mean chance of winning each game (I call it the "root" odds) to be used in binomial statistic analysis. This shortcut allows me to avoid writing macros for Monte Carlo modeling. I think Huck's models and the ones on Atomic Teeth are great; this is just another way to look at it.
The Sagarin Predictor model (the one that the bookies use, and that takes into account point differential) rewarded Texas much more this week than the Sagarin ELO-Chess (the model the BCS uses that doesn't take into account point differential). Texas Tech also jumped in the Sagarins. All the other Big 12 South teams dropped a little. BTW, this is the first week that the Sagarin model has enough game data to be unbiased.
Where do the odds of winning each game come from? I have years of data from Phil Steele on Big 12 south games and point spreads, so I actually made a spreadsheet from past games and outcomes, and have used that in the model.
Takeaways: Texas has played its two toughest games on the schedule. Numbers 3 and 4 come up the next two weeks. Texas will be double digit favorites in each. Obviously, Texas is bowl-eligible now.
OU is a very good team that has a real chance of going 7 - 5 or worse. At NU actually looks tougher for them, on paper, than Texas at a neutral site. It will be interesting to see how their players respond. They laid it all out last Saturday, and almost pulled an upset for the ages. Will all the drama of this season start to wear them down?
Sagarin is unimpressed with OSU. They will be favorites in three of their remaining six games. The Georgia win doesn't look as impressive now.
Tech is looking to put together a nice season. Our win over them looks less ugly every week. They will be favored in every game they have left except OU. Remember that OU hasn't won in Lubbock since 2003. Leach seems to have fixed his locker room.
Was TAMU really taking KSU for granted? They really blew it, and Sagarin hammered them for it. Right now, the Ags do not look like they will be favorites in any of their remaining games. ISU and BU are must wins, but that won't get them to bowl-eligibility.
This week is the season for Baylor. They have a shot with OSU visiting, just not a very good one. A few weeks ago, the BU/TAMU game looked like it would determine which team went to a bowl. Now it looks like it will only determine who gets to 5 wins. Why does Baylor have a greater chance of reaching bowl eligibility (6 wins) than TAMU, despite having fewer expected wins (i.e. the sum of each games odds of winning)? Because TAMU has two games with almost no chance of winning, which kills its "root" odds. TAMU probably has a higher chance than shown. They just have to win all three of the games they have a legit chance in- at CU, ISU, and BU. Thoughts?
|@Wyo||10||58.73||-27.53||W||Exp. B12 rec||7.29|
|CU||8||69.68||-23.58||W||Bowl Eligible Odds||100.00%|
|OU||1||88.65||-1.11||W||10 win odds||16.74%|
|@Mizzou||4||74.95||-11.31||0.78||11 win odds||38.50%|
|@OSU||3||75.78||-10.48||0.77||12 win odds||44.76%|
|Idaho St||12||41.87||-50.28||W||Exp. B12 rec||5.495|
|BU||9||68.87||-23.28||W||Bowl Eligible Odds||93.57%|
|Texas||2||89.76||1.11||L||10 win odds||0.00%|
|@KU||5||78.24||-6.91||0.74||11 win odds||0.00%|
|KSU||10||68.73||-23.42||0.98||12 win odds||0.00%|
|Hou||7||75.25||-4.03||L||Exp. B12 rec||4.505|
|@TAMU||5||64.68||-7.60||W||Bowl Eligible Odds||97.80%|
|Mizzou||9||74.95||-4.33||W||10 win odds||1.83%|
|@BU||6||68.87||-3.41||0.61||11 win odds||0.16%|