Hello There, Guest! (LoginRegister)

Post Reply 
Using ELO ranking to find number of upset loss for each P5 team
Author Message
jhasting Offline
Bench Warmer
*

Posts: 102
Joined: May 2015
Reputation: 38
I Root For: .
Location:
Post: #1
Using ELO ranking to find number of upset loss for each P5 team
Wanted to find which teams have the most upset loses in history. Used ELO ranking (Chess formula) and counted every P5 team loss to an opponent with an ELO score more than 100 points less when the game was played. A few interesting results:

* Texas has been upset the most times (147)
* Indiana has been upset the fewest time (44)
* Teams with most overall wins tend to have the most upset losses

https://docs.google.com/spreadsheets/d/1...sp=sharing
(This post was last modified: 05-30-2019 11:18 AM by jhasting.)
05-30-2019 07:24 AM
Find all posts by this user Quote this message in a reply
Advertisement


ChrisLords Offline
Heisman
*

Posts: 8,684
Joined: Jun 2007
Reputation: 339
I Root For: Virginia Tech
Location: Earth
Post: #2
RE: Using ELO ranking to find number of upset loss for each P5 team
Of the teams in the top 15 in all time wins, WVU is lowest in the upset losses tied for 31st place. I guess that means as a whole over time they were the most disciplined or that all the years they were in the Southern Conference they weren't favored over 100 ELO points over many teams.

It makes sense the best all time teams have the most upset wins. You have to be good to be favored by over 100 ELO points so many times.

It puts into perspective how big JMU's win over VT in 2010, Purdue's win over Ohio State last year and Syracuse's win over Clemson 2 years ago to see them as the biggest upset losses in the history of the programs.
(This post was last modified: 05-30-2019 08:38 AM by ChrisLords.)
05-30-2019 08:35 AM
Find all posts by this user Quote this message in a reply
ken d Offline
Hall of Famer
*

Posts: 17,453
Joined: Dec 2013
Reputation: 1226
I Root For: college sports
Location: Raleigh
Post: #3
RE: Using ELO ranking to find number of upset loss for each P5 team
It would seem logical that the better teams would be upset more often than weaker teams, if for no other reason than that they are the favorites more often. You can't be upset if you are the underdog (as Indiana often is).
05-30-2019 08:36 AM
Find all posts by this user Quote this message in a reply
Advertisement


jhasting Offline
Bench Warmer
*

Posts: 102
Joined: May 2015
Reputation: 38
I Root For: .
Location:
Post: #4
RE: Using ELO ranking to find number of upset loss for each P5 team
biggest upset of any game all time found using this methodology:
<7> Brigham Young 16 @ Texas-El Paso 23 Oct 26 1985 825.75pts

Top 5 biggest P5 team upsets of all time using this methodology:
<13> Virginia Tech 16 vs James Madison 21 Sep 11 2010 746.92pts
<5> Michigan 32 vs Appalachian State 34 Sep 1 2007 685.54pts
Minnesota 6 vs Iowa Pre-Flight 7 Oct 3 1942 663.31pts
Florida 20 vs Georgia Southern 26 Nov 23 2013 658.96pts
Texas 7 vs Southwestern TX 14 Oct 2 1943 653.71pts
(This post was last modified: 05-30-2019 08:55 AM by jhasting.)
05-30-2019 08:53 AM
Find all posts by this user Quote this message in a reply
jhasting Offline
Bench Warmer
*

Posts: 102
Joined: May 2015
Reputation: 38
I Root For: .
Location:
Post: #5
RE: Using ELO ranking to find number of upset loss for each P5 team
full w/l/t record for every P5 team in games where team is +100 elo and games where team is -100 elo vs opponent

https://docs.google.com/spreadsheets/d/1...sp=sharing
05-30-2019 11:22 AM
Find all posts by this user Quote this message in a reply
Advertisement


JRsec Offline
Super Moderator
*

Posts: 38,251
Joined: Mar 2012
Reputation: 7956
I Root For: SEC
Location:
Post: #6
RE: Using ELO ranking to find number of upset loss for each P5 team
(05-30-2019 07:24 AM)jhasting Wrote:  Wanted to find which teams have the most upset loses in history. Used ELO ranking (Chess formula) and counted every P5 team loss to an opponent with an ELO score more than 100 points less when the game was played. A few interesting results:

* Texas has been upset the most times (147)
* Indiana has been upset the fewest time (44)
* Teams with most overall wins tend to have the most upset losses

https://docs.google.com/spreadsheets/d/1...sp=sharing

Dang! I thought the Electric Light Orchestra had a new album out!
05-30-2019 03:55 PM
Find all posts by this user Quote this message in a reply
ChrisLords Offline
Heisman
*

Posts: 8,684
Joined: Jun 2007
Reputation: 339
I Root For: Virginia Tech
Location: Earth
Post: #7
RE: Using ELO ranking to find number of upset loss for each P5 team
(05-30-2019 08:53 AM)jhasting Wrote:  biggest upset of any game all time found using this methodology:
<7> Brigham Young 16 @ Texas-El Paso 23 Oct 26 1985 825.75pts

Top 5 biggest P5 team upsets of all time using this methodology:
<13> Virginia Tech 16 vs James Madison 21 Sep 11 2010 746.92pts
<5> Michigan 32 vs Appalachian State 34 Sep 1 2007 685.54pts
Minnesota 6 vs Iowa Pre-Flight 7 Oct 3 1942 663.31pts
Florida 20 vs Georgia Southern 26 Nov 23 2013 658.96pts
Texas 7 vs Southwestern TX 14 Oct 2 1943 653.71pts

So the JMU @ VT game is the second biggest upset in college football history? Great. I guess I'll have to stop bringing up Chamenade and UMBC to my UVA friends.
05-30-2019 04:16 PM
Find all posts by this user Quote this message in a reply
Advertisement


Hokie Mark Offline
Hall of Famer
*

Posts: 23,817
Joined: Sep 2011
Reputation: 1405
I Root For: VT, ACC teams
Location: Greensboro, NC
Post: #8
RE: Using ELO ranking to find number of upset loss for each P5 team
(05-30-2019 03:55 PM)JRsec Wrote:  
(05-30-2019 07:24 AM)jhasting Wrote:  Wanted to find which teams have the most upset loses in history. Used ELO ranking (Chess formula) and counted every P5 team loss to an opponent with an ELO score more than 100 points less when the game was played. A few interesting results:

* Texas has been upset the most times (147)
* Indiana has been upset the fewest time (44)
* Teams with most overall wins tend to have the most upset losses

https://docs.google.com/spreadsheets/d/1...sp=sharing

Dang! I thought the Electric Light Orchestra had a new album out!

It's a Living Thing.
05-30-2019 06:20 PM
Visit this user's website Find all posts by this user Quote this message in a reply
JRsec Offline
Super Moderator
*

Posts: 38,251
Joined: Mar 2012
Reputation: 7956
I Root For: SEC
Location:
Post: #9
RE: Using ELO ranking to find number of upset loss for each P5 team
(05-30-2019 06:20 PM)Hokie Mark Wrote:  
(05-30-2019 03:55 PM)JRsec Wrote:  
(05-30-2019 07:24 AM)jhasting Wrote:  Wanted to find which teams have the most upset loses in history. Used ELO ranking (Chess formula) and counted every P5 team loss to an opponent with an ELO score more than 100 points less when the game was played. A few interesting results:

* Texas has been upset the most times (147)
* Indiana has been upset the fewest time (44)
* Teams with most overall wins tend to have the most upset losses

https://docs.google.com/spreadsheets/d/1...sp=sharing

Dang! I thought the Electric Light Orchestra had a new album out!

It's a Living Thing.

Yeah, if you aren't looking at Mr. Blue Sky while stuck on a Telephone Line talking to an Evil Woman who's two timing you with Horace Wimp because he has a Strange Magic!
05-30-2019 07:21 PM
Find all posts by this user Quote this message in a reply
Advertisement


bullet Offline
Legend
*

Posts: 66,834
Joined: Apr 2012
Reputation: 3315
I Root For: Texas, UK, UGA
Location:
Post: #10
RE: Using ELO ranking to find number of upset loss for each P5 team
(05-30-2019 07:21 PM)JRsec Wrote:  
(05-30-2019 06:20 PM)Hokie Mark Wrote:  
(05-30-2019 03:55 PM)JRsec Wrote:  
(05-30-2019 07:24 AM)jhasting Wrote:  Wanted to find which teams have the most upset loses in history. Used ELO ranking (Chess formula) and counted every P5 team loss to an opponent with an ELO score more than 100 points less when the game was played. A few interesting results:

* Texas has been upset the most times (147)
* Indiana has been upset the fewest time (44)
* Teams with most overall wins tend to have the most upset losses

https://docs.google.com/spreadsheets/d/1...sp=sharing

Dang! I thought the Electric Light Orchestra had a new album out!

It's a Living Thing.

Yeah, if you aren't looking at Mr. Blue Sky while stuck on a Telephone Line talking to an Evil Woman who's two timing you with Horace Wimp because he has a Strange Magic!

I remember a friend in college saying if he heard Telephone Line one more time, he would shoot himself. I liked the song. His name was Tom, but not one of the ones on the board.
05-30-2019 11:16 PM
Find all posts by this user Quote this message in a reply
JRsec Offline
Super Moderator
*

Posts: 38,251
Joined: Mar 2012
Reputation: 7956
I Root For: SEC
Location:
Post: #11
RE: Using ELO ranking to find number of upset loss for each P5 team
(05-30-2019 11:16 PM)bullet Wrote:  
(05-30-2019 07:21 PM)JRsec Wrote:  
(05-30-2019 06:20 PM)Hokie Mark Wrote:  
(05-30-2019 03:55 PM)JRsec Wrote:  
(05-30-2019 07:24 AM)jhasting Wrote:  Wanted to find which teams have the most upset loses in history. Used ELO ranking (Chess formula) and counted every P5 team loss to an opponent with an ELO score more than 100 points less when the game was played. A few interesting results:

* Texas has been upset the most times (147)
* Indiana has been upset the fewest time (44)
* Teams with most overall wins tend to have the most upset losses

https://docs.google.com/spreadsheets/d/1...sp=sharing

Dang! I thought the Electric Light Orchestra had a new album out!

It's a Living Thing.

Yeah, if you aren't looking at Mr. Blue Sky while stuck on a Telephone Line talking to an Evil Woman who's two timing you with Horace Wimp because he has a Strange Magic!

I remember a friend in college saying if he heard Telephone Line one more time, he would shoot himself. I liked the song. His name was Tom, but not one of the ones on the board.

Yeah that's one thing my wife and I agreed on musically. We both loved ELO. My tastes were a bit more eclectic and my wife loved R&B and Earth Wind and Fire which were alright. But I still loved my 60's Folk, the Stones, Credence, and later Fleetwood Mac to go with ELO.
05-30-2019 11:25 PM
Find all posts by this user Quote this message in a reply
Fighting Muskie Offline
Senior Chief Realignmentologist
*

Posts: 11,930
Joined: Sep 2016
Reputation: 818
I Root For: Ohio St, UC,MAC
Location: Biden Cesspool
Post: #12
RE: Using ELO ranking to find number of upset loss for each P5 team
The traditional powerhouses are naturally going to have more upsets because they go into far more games as the favorite.
05-31-2019 12:42 PM
Find all posts by this user Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)


Copyright © 2002-2024 Collegiate Sports Nation Bulletin Board System (CSNbbs), All Rights Reserved.
CSNbbs is an independent fan site and is in no way affiliated to the NCAA or any of the schools and conferences it represents.
This site monetizes links. FTC Disclosure.
We allow third-party companies to serve ads and/or collect certain anonymous information when you visit our web site. These companies may use non-personally identifiable information (e.g., click stream information, browser type, time and date, subject of advertisements clicked or scrolled over) during your visits to this and other Web sites in order to provide advertisements about goods and services likely to be of greater interest to you. These companies typically use a cookie or third party web beacon to collect this information. To learn more about this behavioral advertising practice or to opt-out of this type of advertising, you can visit http://www.networkadvertising.org.
Powered By MyBB, © 2002-2024 MyBB Group.