Excel 2007: how to work out percentages of groups (top 10% of...)
- by Mike
I've recently read the following paragraph, and wondered:
how you would organise the data (possibly Column A = country, Column B = salary, Column C = tax paid)
but what formulas/calculations are used to work out these types of % figures:
In country Y the top 0.5% of taxpayers pay 17% of total income tax. In country X the top 0.1% of taxpayers pay 8% of total income tax and in country Z, the top 1% pay about 40% of total federal income tax.
I've gone through the help files and searched within Excel websites but I'm struggling to find an answer. %'s interest and trouble me...
Any pointers or examples very welcome.
Thanks
Mike