I find all the math kinda interesting. I see how one gets 45.1% for 12-0 by multiplying all the probabilities together, but how do they get the other percentages?
Sent from my SM-T230NU using Tapatalk
I find all the math kinda interesting. I see how one gets 45.1% for 12-0 by multiplying all the probabilities together, but how do they get the other percentages?
Sent from my SM-T230NU using Tapatalk
Since the probability of winning any game is the percentage given, the probability of losing is 100 minus that percentage. Therefore, to get, for example, the probability of going 11-1, you need to add up all the combinations of multiplied percentages that include exactly one loss from remaining games.
Audit can correct me if I'm wrong but I worked it out for the 11-1, 8-4, and 7-5 scenarios and nailed 40.1%, 0.1%, and 0.002%. Would take a little longer for 10-2 & 9-3 since there are quite a few more combinations and I'm just using my phone calculator.
I have the honor to be Your Obedient Servant - B.Aud
We all live in stories... It seems to me that a definition of any living vibrant society is that you constantly question those stories... The argument itself is freedom. It's not that you come to a conclusion about it. Through that argument you change your mind sometimes... That's how societies grow. When you can't retell for yourself the stories of your life then you live in a prison... Somebody else controls the story. - S. Rushdie
When it's third and ten, you can take the milk drinkers and I'll take the whiskey drinkers every time. -Max McGee
“I really thought you had to run the football to control the game,” Erhardt once said. “You had to throw the football to score but had to run the football to win.” - Ron Erhardt
A methodology that is relatively straight forward is discussed in Mathletics, but getting the data and the computing power to do it right is an issue.
If you had all the scores for all the games you could compute an offensive and defensive rating for each team and understand how much the model's predictions vary from reality which would then give you an idea of how likely a particular defense would be to pitch a shutout against a particular offense.
In college football you've got like 250 teams x 2 variables per team (off & def) + 1 for home field + whatever else you want to throw in, so 501 variables or more. Excel's solver can't handle that many variables. It can do a single conference or even the whole NFL (65 variables) but not 500+.
If we just use the MVFC conference games played to date (which is only 3 or 4 games per team so, sample size issues!, plus you're willfully ignoring a bunch of information you know is relevant!) such a model suggests that NDSU's defense is 13 points better than the conference average while USDs offense is 9 points poorer than the conference average. Those are top and bottom of the table respectively. The predicted game score: NDSU 39 USD 4 (which is way more than the 25 point margin suggested by Sagarin even though the conference only model's home field advantage is almost x2 Sagarin's). Comparing the model's predictions to actual results to date, the standard deviation of predicted points allowed compared to actual is 5.58 and the errors are normally distributed around the mean so we can use the normal distribution curve to estimate roughly a 20% chance of a shut out on Saturday.
Again, that's just based on performance in the 3 or 4 conference games played to date and it's completely ignorant of everything except the final scores and who's field the game was played on. But's that's a way you could get at it.
I have the honor to be Your Obedient Servant - B.Aud
We all live in stories... It seems to me that a definition of any living vibrant society is that you constantly question those stories... The argument itself is freedom. It's not that you come to a conclusion about it. Through that argument you change your mind sometimes... That's how societies grow. When you can't retell for yourself the stories of your life then you live in a prison... Somebody else controls the story. - S. Rushdie
Excel solver can't handle it! OMG. What will we do.
Many thousands are in want of common necessaries; hundreds of thousands are in want of common comforts, sir."
Scrooge-"Are there no prisons?". "Plenty of prisons..."
Scrooge-"And the Union workhouses." . "Are they still in operation?". "Both very busy, sir..."
"Those who are badly off must go there."
"Many can't go there; and many would rather die."
Scrooge- "If they would rather die," "they had better do it, and decrease the surplus population."
LAKESBISON 3/4/2006-4/15/2011 Forever in our heartsStu Whitney @stuwhitney4mSurprised Harvard missed out. MT @AllHailTank: Well I guess I got watt I wonted I will take my talents and higher my education at UND.
Former representative of 3rd Floor Johnson
Current representative of 12 St. N Fargo
OFFICIAL BISONVILLE SPONSOR OF:Tatanka™ brand humor. Gary Bettman's incompetence. The process of recommending a task force to recommend a process to be suggested to another task force, and of meetings called to discuss future meetings. The 21.3% of teh university students that, unlike Tatanka, are online-only, and the 15+% that never step foot in North Dakota. And hating Detroit...Proud member of TOHBTC and NDSU Team Makers.