Wednesday 4/2/2009
Formulae, functions and simple calcucations. This information is adapted from Children's Defense Fund
A Rate is simply the number of things per some other number, usually 100 or 1,000 or some other multiple of 10. A percentage is a rate per 100. Infant mortality rates are calculated per 1,000. To calculate a rate, you need three pieces of information:
The formula for calculating a rate is:
(Number in subgroup ÷ Number in total group) × multiplier
In 2003, 135,979 babies were born in Planet-X. In that same year, 1,151 infants died. The infant mortality rate is the number of infant deaths per 1,000 births. Calculate Planet-X's 2003 infant mortality rate this way:
(1,151 ÷ 135,979) × 1,000 = 0.00846 (rounded) × 1,000 = 8.46
To calculate the rate, be sure to work with numbers that are large enough to be meaningful. A general rule is: if the number of people or events or things is less than 30, do not calculate a rate. Rates based on very small numbers can vary hugely from year to year and are not stable.
A ratio is one number divided by another. A ratio tells you how much bigger or smaller one number is compared to the other. For example, in 2003 the infant mortality rate among group-A was 14.01; the rate among group-B was 5.72. The ratio of the group-A rate to the group-B rate is:
14.01 ÷ 5.72 = 2.449
Any two numbers can be compared in this way, provided there exists the same mreasure for the two groups in the same year (as in the infant mortality example above) or, for one group in two different years (such as the unemployment rate in 2004 compared with the rate in 2000).
If data are known for two or more points in time, then it's possible to calculate how much change there was between the first and second points. Typically, knowing the size of the change (the percent by which the number changed) is important. Two pieces of information are required to calculate a rate of change over time:
The rate of change is:
[(Number at later time ÷ Number at earlier time) - 1] × 100
If the resulting number is positive, then this means there was an increase over time. Conversely, if the result is negative, then this means there was a decrease. For example, if an infant mortality rate was 8.4 in 1993 and 5.8 in 2003, then calculate the rate of change this way:
5.8 ÷ 8.4 = 0.69048 0.69048 - 1 = -0.30952 -0.30952 × 100 = -30.95%
Which means that the infant mortality rate decreased by 31.0% between 1993 and 2003
Ranking allows you to say whether one state's children are faring better than another state's, or to say that there are, for example, 17 states with lower infant mortality rates than yours. Ranking should be done only when you can compare the same measure of data for each of the geographic areas or groups you are studying.
Ranking permits observations between objects or groups. E.g., the statement "There are 17 other Planet's with lower infant mortality than Planet-X" expresses a ranking. Ranking should only be done when it is possible to compare the same measure of data for each of the groups being observed.
Ranking involves:
Numbers can be ordered from largest to smallest or from smallest to largest. To rank numbers, order them from best to worst. The best number can be assigned Rank 1, with Rank 2 going to the second best, and so forth down the list. The worst number are assigned the lowest rank. Best and worst are determined by the specific number. The largest value would be best for median income, whereas the smallest value would be best for infant mortality. When two or more numbers in the list are the same, it does not make sense to give them different ranks. Give them the same rank and skip the next rank. If three numbers are the same, give them the same rank and skip the next two rank.
Stuart Moorfoot 4 Feb 2009 foo@bund.com.au