Recalculating percentages after some entries are removed

[jasoncdu]

Hi all,

I have a probem right now where I have a list of percentages that add to 100%. Now I need to remove some items within the list and recalculate the new list so it equalizes to 100% again and I am not too sure how to do this.

Please note I have made up the numbers so feel free to correct any of these numbers.


Example (original):
------------------------------------
Apple Market Share: 25%;
Windows Market Share: 50%;
Linux Market Share: 25%;

Total: 100%
-------------------------------------


Example (after removing Linux,
equalize apple market share and
windows market share to 100%):
-------------------------------------
Apple Market Share: 33%
Window Market Share: 66%

Total: 100%;
-------------------------------------

If anyone has any questions feel free to ask and I will gladly try my best to clarify.

Thanks
Jason

 

[stapel]

One method can be to convert the percentages into counts, and then work backward to percentages again.

For instance, if A is 20%, B is 35%, and C is 45%, then A + B + C = 100%. Convert that to counts, so A is 20, B is 35, and C is 45. Then A + B + C = 100. Remove, say, B, so you're left with A = 20 and C = 45, and A + C = 65. Working backwards, the percent for A is 20/65 = ...

...and so forth.

 

[Deleted member 4993]

Hi all,

I have a probem right now where I have a list of percentages that add to 100%. Now I need to remove some items within the list and recalculate the new list so it equalizes to 100% again and I am not too sure how to do this.

Please note I have made up the numbers so feel free to correct any of these numbers.


Example (original):
------------------------------------
Apple Market Share: 25%;
Windows Market Share: 50%;
Linux Market Share: 25%;

Total: 100%
-------------------------------------


Example (after removing Linux,
equalize apple market share and
windows market share to 100%):
-------------------------------------
Apple Market Share: 33%
Window Market Share: 66%

Total: 100%;
-------------------------------------

If anyone has any questions feel free to ask and I will gladly try my best to clarify.

Thanks
Jason

Since these are %, working with 100 will be easiest.

If there were 100 computers, we started with

Apple - 25

Windows - 50

Linux - 25

After removing Linux - only 75 computers left of which 25 are Apple and 50 are Windows

So

Apple's new market share = 25/75 * 100% = 33.33%

Window's new market share = 50/75 * 100% = 66.67%

 

[jasoncdu]

Thank you both for your answer!