# Thread: Distribute Percentages across weighted categories.

1. ## 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?

2. ## 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.

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.

4. ## 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.

5. ## 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.