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 it max is 50kb, and it's 100kb.

If anyone wants to host it (or just wants a copy of it) PM me your email address   Reply With Quote  Reply With Quote

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.  Reply With Quote