+ Reply to Thread
Results 1 to 3 of 3
-
06-06-18 04:39 PM #1
I made an excel spreadsheet to calculate odds
For a given Batting average and number of at bats (you put that in, up to .270)
Over the course of those at bats, the:
odds of getting exactly X hits
odds of getting at least X hits
odds of X hits or more
Odds of batting Above X batting average
Odds of batting Above X batting average
I'm pretty sure I could do it for more than 170 AB my making multiple sheets and multiplying the odds, but I don't care enough to.
edit: well crap. I can't attach itmax is 50kb, and it's 100kb.
If anyone wants to host it (or just wants a copy of it) PM me your email addressA fool and his money can throw one heck of a party!
-
06-10-18 11:07 PM #2
- Join Date
- May 2005
- Location
- Nassau County
Re: I made an excel spreadsheet to calculate odds
http://stattrek.com/online-calculator/binomial.aspx can do that.
-
07-14-18 03:43 PM #3
Re: I made an excel spreadsheet to calculate odds
If it's just batting average to hits then just do the following lines in Excel or Google Spreadsheets
=1-binom.dist(X number of hits-1, number of Abs, batting average, 1) for at least X hits
=1-binom.dist(X number of hits, number of Abs, batting average, 0) for exactly X hits
=1-binom.dist(roundup(ABs * X batting average)-1, number of Abs, true batting average, 1) for batting above a certain average given a true BA.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)