One way...
'--
INCOME FACTOR PERCENT
-------------------------------------
$10000 6.1 22.86%
$15000 4.1 15.24%
$12000 5.1 19.05%
$8000 7.6 28.57%
$16000 3.8 14.29%
------------------------------------
$61000 26.7 100.00%

Factor is total group income divided by individual income.
Percent is Factor divided by Factor total.
'--
Jim Cone
Portland, Oregon USA




"Dan Cotts"

wrote in message
I am trying to figure out how to do a weighted average using a reverse ratio
- that is, I have members of a group, each with Income, that I need to
allocate items among the group - but the members with lower income should
have MORE allocation made to them.