Hi Mrexcelians.
I have this formula
Pi = Ni^k (power k)
Applied to this Odds example:
1.51 3.69 5.30 (in columns D, E, F respectively)
Where
Ni represents 1.51, 3.69, 5.30 individually - There are 2 competitors, n, &
N=Sum of the 3 Ni(s)
k is derived as:
Log n / Log(n/N) - k is the SUBJECT OF ITERATION to ENSURE SUMMATION OF THE 3 Pi=1.00 (always).
How can an Iterator for this look like given a large data set, say 12,000
I have this formula
Pi = Ni^k (power k)
Applied to this Odds example:
1.51 3.69 5.30 (in columns D, E, F respectively)
Where
Ni represents 1.51, 3.69, 5.30 individually - There are 2 competitors, n, &
N=Sum of the 3 Ni(s)
k is derived as:
Log n / Log(n/N) - k is the SUBJECT OF ITERATION to ENSURE SUMMATION OF THE 3 Pi=1.00 (always).
How can an Iterator for this look like given a large data set, say 12,000
Last edited: