First of I'm not sure if this is the place for such a question
I have a set of 8 Players (could be any number from 2 players to 8 players in the group) I would like an excel formula to workout the percentage chance of each player to score the most points.
I have managed to workout on Excel how to do a Player Head to Head Match up. But for the life of me I can't workout how to do a Group of 3,4,5,6,7,or 8 or More Players.
As you can see the First example is just the numbers the 2nd example is the formulas I have used to get those numbers.
<tbody>
</tbody>
<tbody>
</tbody>
I have a set of 8 Players (could be any number from 2 players to 8 players in the group) I would like an excel formula to workout the percentage chance of each player to score the most points.
I have managed to workout on Excel how to do a Player Head to Head Match up. But for the life of me I can't workout how to do a Group of 3,4,5,6,7,or 8 or More Players.
As you can see the First example is just the numbers the 2nd example is the formulas I have used to get those numbers.
Player A | vs | Player B | |
Prediction | 29.59 | 27.64 | |
StDev | 8.82 | 8.53 | |
Mean | 1.95 | ||
Variance | 151 | ||
Z score | 0.16 | ||
Probability | 56% | 44% |
<tbody>
</tbody>
Player A | vs | Player B | |
Prediction | 29.59 | 27.64 | |
StDev | =SQRT(B10*2.63) | =SQRT(D10*2.63) | |
Mean | =B10-D10 | ||
Variance | =B11^2+D11^2 | ||
Z score | =B12/SQRT(B13) | ||
Probability | =NORMSDIST(B14) | =1-B15 |
<tbody>
</tbody>