# Distribute Percentages across weighted categories.

• Nov 8th 2012, 10:28 AM
dashiellx
Distribute Percentages across weighted categories.
I have the following percentages for aging categories:

http://mathhelpforum.com/image/png;b...BJRU5ErkJggg==

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?
• Nov 8th 2012, 08:45 PM
chiro
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.
• Nov 9th 2012, 04:00 AM
dashiellx
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.
• Nov 9th 2012, 03:09 PM
chiro
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.
• Nov 12th 2012, 05:04 AM
dashiellx
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.