College football teams are defined by the company they keep

Ezra Shaw

A look at what you can learn about your team by the teams ranked around you.

In many ways, we are defined by the company we keep. So is your college football team. I was having a conversation with a friend of mine who happens to be a fan of a rival school. He was struggling to come up with a program that my team was roughly equivalent to.

That got me to thinking. Brian Fremeau has a great page on his site listing the 5-year Program Ratings for each team from 2007 to 2012 (or more accurately, for the 5 years ended in 2007 through the 5 years ended in 2012). For example, for the five years ended 2012, Fremeau's system says the top 5 programs in college football were:

  1. Alabama
  2. Oklahoma
  3. Oregon
  4. LSU
  5. Florida

I thought it would be interesting to check out the "neighbors" for each team for each team covered in Fremeau's study. In other words, in each of the 5-year periods, what other programs were most similar to yours?

As an example, let's look at two teams. One on the rise, one on the decline (click on the images to make them bigger):

First, on the rise: Stanford. In the 5-year period ended in 2007, they were neighbors with Tulsa, Hawaii, Ole Miss, and Illinois. By the 5-year period ended in 2012, they had moved into a much nicer neighborhood: Florida, Oklahoma State, Florida State, and Ohio State.

Screenshot251_medium

Now, on the decline: Cal. The Bears used their NFL talent in early to mid 2000s to rub elbows with Michigan, Clemson, and Wisconsin. Now, they downsized into a smaller home down the street from the likes of Iowa State and Temple.

Screenshot253_medium

Okay, I think you a) get it by now and b) are sick of my 'neighbor' references. Have some fun on your own. You can use this Google spreadsheet to find out who your team's neighbors are. Enjoy:*

*One quick note: I had to protect certain parts of the spreadsheet so that you don't accidentally disrupt the formulas. That is easy, but it makes your view look like this:

Screenshot255_medium

To remove the annoying gray lines, you must uncheck  View -> Protected Ranges. It should be that easy.

Screenshot254_medium

Trending Discussions

X
Log In Sign Up

forgot?
Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

Join Football Study Hall

You must be a member of Football Study Hall to participate.

We have our own Community Guidelines at Football Study Hall. You should read them.

Join Football Study Hall

You must be a member of Football Study Hall to participate.

We have our own Community Guidelines at Football Study Hall. You should read them.

Spinner

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9341_tracker