Results 1 to 5 of 5

Math Help - Minimum at bats for specific batting average

  1. #1
    Newbie
    Joined
    Jul 2012
    From
    Missouri
    Posts
    3

    Minimum at bats for specific batting average

    I got to wondering what would be the minimum number of at bats needed to have a specific batting average in baseball. For this purpose, consider batting average to be hits divided by at bats and rounded to 3 places. For example, a .271 average would be anything greater than or equal to .2705 but less than .2715. So what I would like to know is how many times would a player have to bat before it would be possible for him to have a .271 average. I need a general formula to calculate this minumum for any batting average. Something I could use in Excel would be a bonus. Thanks for any help.

    Note: I have been able to get some answers to this problem using historical baseball statistics. As an example, since 1901, there have been over 200 instances of a player hitting .228. Seventeen of those had exactly 57 at bats, but none had fewer. So 57 appears to be the fewest at bats one can have to get a .228 batting average. Some others: .237 is 38 AB, .215 is 65 AB. This method is tedious and doesn't guarantee accuracy.

    Ken
    Follow Math Help Forum on Facebook and Google+

  2. #2
    mfb
    mfb is offline
    Junior Member
    Joined
    Jun 2012
    From
    Germany
    Posts
    72
    Thanks
    5

    Re: Minimum at bats for specific batting average

    I discussed this a while ago here. We did not derive a general formula, but it might be possible to get one. It is certainly possible to calculate those values with a macro (and implement this macro as function in excel). Brute force, if you do not find anything better.

    As alternative, you can generate a lookup table for all 1001 possible batting averages once.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Jul 2012
    From
    Missouri
    Posts
    3

    Re: Minimum at bats for specific batting average

    Thanks for the quick reply and link to the interesting discussion. On May 23rd, Boesch achieved his .249 BA at 181 AB and Scutaro at 177. It looks like the minimum AB required for this average is 169. Also appreciate the suggestion to create a lookup table. At this point, I plan to continue to get these values using an excellent baseball database program called National Pastime Almanac. I've already got all of them from .137 to .152 and from .199 to .251.

    Ken
    Follow Math Help Forum on Facebook and Google+

  4. #4
    mfb
    mfb is offline
    Junior Member
    Joined
    Jun 2012
    From
    Germany
    Posts
    72
    Thanks
    5

    Re: Minimum at bats for specific batting average

    This should do the job. Each line is "batavg,requiredbats", generated with 10 lines of code and brute force.
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Jul 2012
    From
    Missouri
    Posts
    3

    Re: Minimum at bats for specific batting average

    Thank you! I created an Excel file to calculate these (also using brute force), but it does only one at a time, and I had quite a ways to go. I appreciate you doing this.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Finding minimum of average cost
    Posted in the Calculus Forum
    Replies: 2
    Last Post: January 7th 2011, 03:50 PM
  2. Average Absolute Deviation (find the minimum)
    Posted in the Statistics Forum
    Replies: 1
    Last Post: June 3rd 2010, 07:24 AM
  3. Replies: 2
    Last Post: March 13th 2010, 04:49 AM
  4. [SOLVED] Average minimum cost?
    Posted in the Calculus Forum
    Replies: 2
    Last Post: December 11th 2008, 07:35 PM
  5. Bats emit sounds...
    Posted in the Advanced Applied Math Forum
    Replies: 5
    Last Post: August 7th 2006, 06:20 PM

Search Tags


/mathhelpforum @mathhelpforum