Finding Decile Values

Giganews Newsgroups
Subject: Finding Decile Values
Posted by:  Marston (marston_gou…@mac.com)
Date: Mon, 7 Jul 2008

I have two columns of data. The first represent a running count of
weeks, the second the number of people in that group.

Example:

0    100,000
1      40,000
2      38,000
3      76,000
4      45,000
5      92,000

etc.

I'd like to find out the weighted value across each decile. For
instance, in the above example, there are 391,000 people

0 - 39,100: 0.0
39,101 - 78,200: 0.0
78,201 - 117,300 = ((100,000-78200) * 0 + (117,300-100000)*1)/39100
117,301- 156,400 = ((156400-140000)*2+(140000-117301)*1))/39100

Does this make sense. Doing this by hand is way to time consuming
because the breakpoints move around.

Replies