View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default how do I create a per capita formula in excel

Hi,

To the best of my knowledge per capita anything is just the number of
occurances of the thing divided by the total number of people. So in your
case it would be 76/29774. I can find no reference to a calculation of a per
capita percent calculation onless it is the percent change in per capita
something. But it would seem that you would simply format the cell to
Percent notation.

Cheers,
Shane Devenshire



" wrote:

I have poulation number and number of crimes reported. How do i determine
the percentage per capita
Example: 29,774 people in a city, 76 violent crimes reported. What is the
percentage per capita of violent crime in that city