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