Thread: 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?

Hey dashiellx.

Your question doesn't make sense: please outline your problem in a bit detail with specifics on data and the question itself.

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.

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.

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.