- Posts: 437
- Joined: Mon Nov 11, 2013 11:21 am
paul8210 wrote:Spider67,
Is this the formula parameters for the Excel Binominal Distribution?
=BINOM.DIST(3,27,1/216,TRUE) (I am using 216 for simplicity, although 270 might be more accurate as suggested earlier)
excel calc = 0.999992596 that Steven Drew won't get injured 3 times in 27 plate appearances.
(1 - .999992596) * 100 = 0.00074039999 percent probability of event (i.e., injured 3 times in 27 plate appearances) occurring
Odds = 1000000: 7.4
or, expressed another way....
Odds = 135100: 1
The odds of Stephen Drew getting injured in exactly 3 of 27 plate appearances as compared to the expected result of 1 of 216 plate appearances is 135,100: 1
So, if you fill University of Michigan football stadium and basketball arena with Strat-o-matic players and they all play three games per evening (assuming server is working and they all have the game on their laptop), after several weeks (allowing for player to return from injury), someone is expected to go, "What is going on? How could one of my players be injured three times in the last 27 games?"
I can tell you've never tried to use WiFi at UM Stadium