Why isn’t Purdue in the Sugar Bowl? A study in graph theory

Why isn’t Purdue in the Sugar Bowl? Yes, 1-11 Purdue, with their big time win over Indiana State. It sounds absurd, doesn’t it? But like 118 other teams in the NCAA Division I BCS, they have an indirect win over Alabama (and Auburn for that matter). This is one of the reasons I love college football. You hear all of the talk about how on any given day, TEAM A can beat TEAM B. But we don’t believe it, until some Saturday in the fall, Georgia Southern beats Florida or Appalachian State beats Michigan. ...

January 3, 2014 · 13 min · granger

Texas Football Fan Sentiment Analysis During Valero Alamo Bowl

With Monday night’s Alamo Bowl being Coach Mack Brown’s final game as coach of the Texas Longhorns, it seemed like a good opportunity to test fan sentiment on the occasion via Twitter. I captured tweets containing certain words in an attempt to follow sentiment towards Mack Brown and Texas over time, leading up to the game, during the game and afterwards for a brief period. I began collecting data around 2:25 PM CST and stopped just after 10:00 PM. The search terms I used were: Mack Brown, mackbrown, Texas Football, Texas Longhorn, hookem and hook em. During that time period, over 51,000 tweets were collected using these search terms. Please not that these terms could be used as regular words, a part of words as well as hashtags. ...

January 1, 2014 · 5 min · granger

College Bowl Season Predictions Based on Least Squared Non-Linear Programming Model

There’s no shortage of data out there when it comes to college football, so I decided to take the time to create a least squares model, based on the same principals I have been using for the NFL, and outlined here. The idea was to take all 752 schools that played college football, cross that with all 4138 games that were played (up to last weekend) and see how they predict the games (especially versus the Vegas lines). ...

December 22, 2013 · 4 min · granger

Converting College Football Data for a Simple Website, using PHP, SQL and MySQL

The pages discussed here can be found at: http://www.sixmanguru.com/ncaa13.php The idea of this project came from a thought that there does not exist a single place where you can see NCAA college football teams’ records and schedules easily, without having to make a bunch of clicks on very ‘graphically full’ websites. The first step was to see if the data could be found easily. This was done easily, as Peter Wolfe keeps this information updated daily. (http://prwolfe.bol.ucla.edu/cfootball/scores.htm). Wolfe is a member of the official BCS rankings and also includes a comprehensive listing of conferences as well. ...

December 2, 2013 · 5 min · granger