Results 1 to 5 of 5

Math Help - Distribute Percentages across weighted categories.

  1. #1
    Newbie
    Joined
    Nov 2012
    From
    Baltmore
    Posts
    3

    Distribute Percentages across weighted categories.

    I have the following percentages for aging categories:



    I need to apply the 0-30% figure of 54.75% to the other categories based on the percentages of those categories.

    Does this make sense?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,607
    Thanks
    591

    Re: Distribute Percentages across weighted categories.

    Hey dashiellx.

    Your question doesn't make sense: please outline your problem in a bit detail with specifics on data and the question itself.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Nov 2012
    From
    Baltmore
    Posts
    3

    Re: Distribute Percentages across weighted categories.

    Sorry, it doesn't look like the image came through properly.

    This is what I have:

    0-30% 31-60% 61-90% 91-120% 121-150% 151-180% >180%
    54.75% 19.40% 13.81% 5.93% 2.75% 0.62% 2.74%

    I need to drop the 0-30% category and redistribute that amount to the others based on their weights. Does that make better sense?

    William.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,607
    Thanks
    591

    Re: Distribute Percentages across weighted categories.

    Do do you want to re-weight the data based on censoring the 0-30% category?

    If this is the case then yeah just divide everything by (1 - 0.5475) = 0.4525 and you will get re-adjusted proportion data as if the 0-30% population wasn't included.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Nov 2012
    From
    Baltmore
    Posts
    3

    Re: Distribute Percentages across weighted categories.

    Thank you! That seems to be working exactly as I need it to. I knew it was a simple fix, just couldn't get my head around it.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Categories of Mathematics
    Posted in the Math Forum
    Replies: 5
    Last Post: August 23rd 2012, 08:16 PM
  2. Categories
    Posted in the Advanced Algebra Forum
    Replies: 1
    Last Post: July 30th 2010, 12:01 AM
  3. Distribute 71.12
    Posted in the Differential Geometry Forum
    Replies: 0
    Last Post: October 28th 2009, 10:32 AM
  4. How do you distribute AND and OR?
    Posted in the Discrete Math Forum
    Replies: 1
    Last Post: June 28th 2008, 03:58 PM

Search Tags


/mathhelpforum @mathhelpforum