Excel Win Lose And Draw calculations?

Question

Hi

Please can someone help me out with this...

I have win row, lose row and draw row for a football league.

How do I calculate the win/lose/draw percentage?

Waht I have currently is wrong

Example

John 20 wins, 5 loses 2 draws

Win percentage is 78%

Lose percentage is 22%

But that's wrong?? Am I right..

Answer 1

The win/loss/draw percentages need to be calculated over all possible outcomes:

1. Win percentage = 20 / (20 + 5 + 2) = 20 / 27 = 74.1%
2. Loss percentage = 5 / (20 + 5 + 2) = 5 / 27 = 18.5%
3. Draw percentage = 2 / (20 + 5 + 2) = 2 / 27 = 7.4%