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 it :lol: 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 :lol:

Re: I made an excel spreadsheet to calculate odds

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.