Stat Request: March Winning % by team from 2013-2019
I'd like to know how Michigan's March winning percentage has fared over the last 6-7 years when compared to other top teams.
Multiple conference tournaments crowns (with few byes, if memory serves), and some deep runs including 2 national championship appearances has to put Michigan up there.
I suspect someone out there already has data that covers this and may be able to whip this up.
This has me interested. Torvik has a nice time frame filtering tool so this shouldn't be too difficult.
A few things:
- Michigan's rough 2014-15 and 2015-16 seasons will hurt their numbers.
- National Championship and often Final Four games are played in April. I assume you want to include those as well.
Good call. Yep and yep.
March 20th, 2019 at 10:38 AM ^
Trying to work with the data on Torvik right now. Problem is that Torvik puts spaces behind the teams somewhat randomly which makes it hard to do vlookups. For example, "Michigan " and then later "Michigan". If anyone has an Excel formula that can remove that last space, let me know. I've already tried using the Trim and the Substitute formulas and they didn't work out.
March 20th, 2019 at 12:14 PM ^
The TRIM function should be what you're after, how did it not work?
Try a find " " and replace with "". If you do that for all fields, it should work for a vlookup even with multiple word schools. (i.e. "WakeForest" will be the same in each column.)
Lol I love these posts that are like "I request information please compile it for me" ???
March 20th, 2019 at 10:03 AM ^
Exactly.
Stat request: What does the future hold?
A quick memory count has us at 16-5 since 2013, I gotta Get to work, so everybody else figure out all the other teams, I'll check in later!
March 20th, 2019 at 10:11 AM ^
We're 16-5 in March Madness since the 2012-2013 season. .762 winning percentage.
We did not make the big dance 14-15.
March 20th, 2019 at 10:12 AM ^
Looked at the wikipedia page of each season 2013-19. Including all regular season games, big ten tourney games, and NCAA tourney games played in the months of March and April, we currently stand at 40-15. This includes this season's 3-2 record thus far in March.
Not sure if you were only looking for tourney records, I took "March" a bit literally.
March 20th, 2019 at 10:15 AM ^
I've been wanting a national overview of "wins over expected (seed)" to evaluate NCAAT coaching quality since Beilein brought us back (2009-2018) but will settle for 2013-2018, which will be less comprehensive but rosier.
538 did this for the last quarter century, but I want to better compare Beilein to active coaches during his time, right now, not to active coaches during their time, back when:
https://fivethirtyeight.com/features/jim-boeheim-is-the-new-king-of-march-madness/
Alas, I can't find a searchable repository of that data.
March 20th, 2019 at 10:50 AM ^
You can sort on Torvik to show only postseason games.
I assume by March you mean the Big Ten and NCAA Tournaments, so post season should get you what you are looking for.
A quick look has Michigan at 32-10 in post season games since 1/1/2013 - good for about a 76% win percentage. Villanova appears to be the best at 30-7, about 81% win percentage.
March 20th, 2019 at 11:26 AM ^
I didn't even notice the "type" of game filter, good call on that.
Starting with the '12-'13 season, Michigan has the most games played (42) and victories (32 - tied with Gonzaga). Villanova and Kentucky are tied with 30 postseason victories. North Carolina has played the second most postseason games (40). Gonzaga is next with 39 (Kentucky and Oregon also have played 39 postseason games in that span but one for UK and two for Oregon were NIT games).
For win percentages, looks like Gonzaga has the top win percentage in conference tournament and NCAA Tournament games with an 82% win clip (32-7). Villanova is next at 81% (30-7). Third place is Kentucky at 79% (30-8*). Michigan appears to be fourth with a 76% win percentage (32-10).
*Note that one of UK's postseason games was a 2013 NIT loss so I did not include it in this calculation.
March 20th, 2019 at 11:30 AM ^
Nice! That's exactly the sort of thing I was aiming for. Also glad to see that my guess of Michigan being at the top of that list is correct. Thanks for doing my homework ;)
March 20th, 2019 at 12:41 PM ^
But, but ... Where's Sharty?
MSU is 25-10 (71%) in BTT/NCAAT games in that span.
Gonzaga's record surprises me. I guess they've cleaned up on WCC tournaments.
Indeed they have. This year was the first time Gonzaga didn't win the WCC Tournament since 2012, when they also lost to Saint Mary's. Their 32-7 postseason record in the '13-'19 span goes like this:
- 18-1 in WCC Tournaments
- 14-6 in NCAA Tournaments
March 20th, 2019 at 11:37 AM ^
Also, I'm pretty sure that last year's B1G Tourney started in February (felt like January.) Can't recall if we played any tourney games in Feb or not but worth looking into.
March 20th, 2019 at 11:42 AM ^
It did start in February however for Michigan's purposes all their BTT and NCAA games occurred in March or April (the Iowa BTT game was on 3/1).