10th November 2008, 07:32 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by jfc
A: 4.00 25% Save
B: 4.60 22% Save
C: 5.00 20% Plunge
D: 6.50 15% Plunge
Outlays on Savers:
A: 12.50 = 50 * 25%
B: 11.00 = 50 * 22%
leaving 26.50 to be outlaid on plungers.
C: 15.1 = 26.50*20/(20+15)
D: 11.4 = 26.50*15/(20+15)
So win 25.30 on Plungers
|
The formula for outlays on the A & B Savers is easy.
But there is a general formula for the proportions to outlay on the plungers.
Enter their odds in column A.
And get the proportions with this expression:
=HARMEAN(A:A)/COUNT(A:A)/A1 |