Using the NORMDIST function to find probabilities

[SOBEted]

So, I have the per game average of four bowlers and their per game standard deviations:

John - Avg. 200; SD 15 (variance 225)
Paul - Avg. 180; SD 16 (variance 256)
George - Avg. 175; SD 18 (variance 324)
Ringo - Avg. 170; SD 18 (variance 324)

I want to know the probabilities of each one winning the match. Can I use the NORMDIST function in excel for this problem?

I can use it for two players: =1-NORMDIST(0, the mean difference between the two players averages, add the players total variance and take sqrt. to get the Stand deviation, TRUE)

I just don't know how to use this function for more than 2 players.

Thank You.

 

[dcardno]

Thanks shg - I was putzing around with a small example that I could do "by hand" (with each identified score in a separate line) so I assumed a game that ran to 30, and averages in the range of 15 to 21, and standard deviations of 3 to 5. In that case there was a fair number of scores > 30. I could work around by examining scores up to (say) 35 until the total probability got as close to 100% as I wanted. I didn't run into that on the low (<0) side, just because zero was four or five sd's away from the average, so the difference wasn't noticeable.