Was talking with a coworker about the correlation between in-state recruiting and the success of M v. MSU. I used the 247 composite and noted the top 10 Michigan recruits between '08 and '17 (the beginning of the sad times to the present). The data does show some relationship that Michigan has played their best football 3 or so years after major in-state recruiting success. There does not seem to be much of a relationship between MSU's recruiting and their on the field success. They were getting somewhere between 2-4 of the best in-state kids for most of their gilded age. It is amazing just how well MSU did over the last decade. What this has reinforced is the importance of Xs and Os over Jims (not that Jim) and Joes.
I would be interested in running a regression on this sort of data but I am not confident enough in my excel prowess to make a public attempt.
|Year||M Recruits||MSU Recruits||M Record||MSU Record|
|2018||3||1||*Speculative and not in total|