Calculate Normal Distribution Probability

[Grunter31]

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.

[TABLE="width: 259"]
<tbody>[TR]
[TD][/TD]
[TD]Player A[/TD]
[TD]vs[/TD]
[TD]Player B[/TD]
[/TR]
[TR]
[TD]Prediction[/TD]
[TD]29.59[/TD]
[TD][/TD]
[TD]27.64[/TD]
[/TR]
[TR]
[TD]StDev[/TD]
[TD]8.82[/TD]
[TD][/TD]
[TD]8.53[/TD]
[/TR]
[TR]
[TD]Mean[/TD]
[TD]1.95[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Variance[/TD]
[TD]151[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Z score[/TD]
[TD]0.16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Probability[/TD]
[TD]56%[/TD]
[TD][/TD]
[TD]44%[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 518"]
<tbody>[TR]
[TD][/TD]
[TD]Player A[/TD]
[TD]vs[/TD]
[TD]Player B[/TD]
[/TR]
[TR]
[TD]Prediction[/TD]
[TD]29.59[/TD]
[TD][/TD]
[TD]27.64[/TD]
[/TR]
[TR]
[TD]StDev[/TD]
[TD]=SQRT(B10*2.63)[/TD]
[TD][/TD]
[TD]=SQRT(D10*2.63)[/TD]
[/TR]
[TR]
[TD]Mean[/TD]
[TD]=B10-D10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Variance[/TD]
[TD]=B11^2+D11^2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Z score[/TD]
[TD]=B12/SQRT(B13)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Probability[/TD]
[TD]=NORMSDIST(B14)[/TD]
[TD][/TD]
[TD]=1-B15[/TD]
[/TR]
</tbody>[/TABLE]

 

[Grunter31]

If anyone could point me in the right direction to get this solved would be brillant.