Results 1 to 3 of 3

Math Help - Looking for formula for curved distribution

  1. #1
    Newbie
    Joined
    Dec 2009
    Posts
    2

    Looking for formula for curved distribution

    I'm not sure what category this would fall under, but I'm assuming Applied Mathematics would fit. Apologies if it's not the correct forum.

    I'm trying to find a formula to plug into excel that I can use for a curved distribution (for prizes distributed to players), but for the life of me, I can't figure one out. I've tried playing with exponential curves & percentages, but can't get a universal formula that will work for any number of players.

    The known variables are as follows:
    Total Number of Winners [NW]
    Total Prizes [TP]
    Rank from top (1st, 2nd, 3rd, etc...)

    The prize distribution needs to resemble a 1/x curve where people ranked higher get a greater number of prizes then people ranked lower.

    Example Output with TNW = 5, TP = 20
    1st = 8, 2nd = 5, 3rd = 3, 4th = 2, 5th = 2

    Example Output with TNW = 7, TP = 30
    1st = 12, 2nd = 7, 3rd = 4, 4th = 3, 5th = 2, 6th = 1, 7th = 1

    TNW & TP can both vary, which is why they have to be variables in the equation and not fixed values.

    The only stipulation is that someone ranked in a tournament with a higher number of TNW, can't get less prizes than someone ranked in a tournament with a lower TNW. (Ex. someone placing 3rd in a tournament with 10 people should get at least as much as someone placing 3rd in a tournament with 6 people.)

    The other problem with the formula is that I need to be able to pull an individual number from the distribution for the prizes going to that rank. ie, if there are 10 players in a tournament, then i need to list the number of prizes going to each rank (1st, 2nd, 3rd, etc...) in their own cell, so the formula would need to find out how many prizes 1st would get, out of a total distribution curve for all the players.

    Any assistance on this would be appreciated as I've scoured the interwebs looking for guidance and I'm coming up empty.

    I've subscribed to this thread so if any more information is needed, I'll post here as soon as possible.

    Thank you in advance for any support!
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by Zxurian View Post
    I'm not sure what category this would fall under, but I'm assuming Applied Mathematics would fit. Apologies if it's not the correct forum.

    I'm trying to find a formula to plug into excel that I can use for a curved distribution (for prizes distributed to players), but for the life of me, I can't figure one out. I've tried playing with exponential curves & percentages, but can't get a universal formula that will work for any number of players.

    The known variables are as follows:
    Total Number of Winners [NW]
    Total Prizes [TP]
    Rank from top (1st, 2nd, 3rd, etc...)

    The prize distribution needs to resemble a 1/x curve where people ranked higher get a greater number of prizes then people ranked lower.

    Example Output with TNW = 5, TP = 20
    1st = 8, 2nd = 5, 3rd = 3, 4th = 2, 5th = 2

    Example Output with TNW = 7, TP = 30
    1st = 12, 2nd = 7, 3rd = 4, 4th = 3, 5th = 2, 6th = 1, 7th = 1

    TNW & TP can both vary, which is why they have to be variables in the equation and not fixed values.

    The only stipulation is that someone ranked in a tournament with a higher number of TNW, can't get less prizes than someone ranked in a tournament with a lower TNW. (Ex. someone placing 3rd in a tournament with 10 people should get at least as much as someone placing 3rd in a tournament with 6 people.)

    The other problem with the formula is that I need to be able to pull an individual number from the distribution for the prizes going to that rank. ie, if there are 10 players in a tournament, then i need to list the number of prizes going to each rank (1st, 2nd, 3rd, etc...) in their own cell, so the formula would need to find out how many prizes 1st would get, out of a total distribution curve for all the players.

    Any assistance on this would be appreciated as I've scoured the interwebs looking for guidance and I'm coming up empty.

    I've subscribed to this thread so if any more information is needed, I'll post here as soon as possible.

    Thank you in advance for any support!
    You want the first prize to be:

    p_1=\lfloor 0.4 \times \text{TP} \rfloor

    the k-th prize is:

    p_k=\lfloor 0.4 \times \text{TP} \times 0.625^{k-1}\rfloor

    Then the number of regular prizes is the smallest k such that:

    \sum_{i=1}^{k+1} p_k > \text{TP}

    There will be n_s additional supplementary prizes each of $1 to that:

    \sum_{i=1}^{k} p_k + n_s = \text{TP}

    Then the total number of winners is \text{TNW}=k+n_s

    CB
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Dec 2009
    Posts
    2
    Thank you for the reply!

    I tried testing your formula in my sheet but couldn't get a result set that I could work with. It looks like your on the right track though, closer than I got anyway. There's only two problems with it. First, is that the sum of prizes given to the winners doesn't equal the total number of prizes available. Second, when the number of winners start creeping up, at 9 winners, with TP = 36, 9th place is getting 0, when it should at least be getting 1.

    I'm going to try restating my stipulations using the math symbols that you used and hopefully that will help lead to a solution.

    The sum of prizes distributed to k players must equal a fixed value of the total prizes available, such that
    \sum_{i=1}^{k} p_k = \text{TP}

    also, the number of prizes given to place k must be greater than or equal to 1, such that
    p_k >= 1

    I believe I got those formulas right. The payout curve looked like it was exactly what I was looking for, except for the two problems stated above.

    Thank you for the reply and assistance!
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Slipping on Curved Road
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: January 7th 2012, 01:53 PM
  2. Intersection of a ray and a curved surface
    Posted in the Calculus Forum
    Replies: 2
    Last Post: August 30th 2010, 11:45 AM
  3. terminology to describe curved surface
    Posted in the Geometry Forum
    Replies: 1
    Last Post: December 1st 2009, 12:32 PM
  4. Find area of a 'curved triangle'
    Posted in the Geometry Forum
    Replies: 3
    Last Post: May 17th 2009, 06:59 AM
  5. Derivative function is curved?
    Posted in the Calculus Forum
    Replies: 1
    Last Post: March 16th 2008, 02:50 PM

Search Tags


/mathhelpforum @mathhelpforum