I made an excel spreadsheet to calculate odds

[ThePinStripes]

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:

[EvanJ]

Re: I made an excel spreadsheet to calculate odds

http://stattrek.com/online-calculator/binomial.aspx can do that.

[grizy]

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.