+ Reply to Thread
Results 1 to 3 of 3

Hybrid View

  1. #1
    Slow in, Fast out ThePinStripes's Avatar
    Join Date
    Jun 2008
    Location
    Dallas, Tejas

    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 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
    A fool and his money can throw one heck of a party!

  2. #2
    NYYF Legend


    Join Date
    May 2005
    Location
    Nassau County

    Re: I made an excel spreadsheet to calculate odds


  3. #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)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts