# Calculating a win ratio as a percentage - help

Discussion in 'General' started by Genzen, Feb 9, 2007.

1. The title says it all really.
I just need help with some basic Maths.

I'm running a spreadsheet to keep a record of wins and losses, and I want the sheet to display the results as a percentage, but I don't remember the algebra.

I basically want to have it look like this:

Wins Loses Ratio
(cell 1) (cell 2) (cell 3)

Can anyone tell me what to type into cell three to make it work?

Thanks.

2. well i forget how to do it by calculator, but you should be able to do it this way

Wins x
-----*-----
Total 100

cross multiply and solve for x.

Edit. i forgot how to do html tabs, so the formatting is a bit wonky, but you should be able to understand it

3. Thanks.
I must be slower than I thought.
To find x you say to cross multiply; I'm ashamed to ask but can you explain how I would do this.

Thanks.

4. ok no prob. ill repost the formula to give the examples

Wins x
----_*-----
Total 100

ok you multiply wins*100. you also do this with total * x

ok now i will give an example:
lets say you have 15 wins and 5 losses...

the diagram would look something like this

15 x
-----*-----
20 100

now we cross multiply so it looks like this...

15*100=20*x
1500=20x

then solve for x so...

20x 1500
---- = ------ So you get x=75 (75 being the percentage)
20 20

Edit h wow i just remembered how you do it on a calc ...
it is just:wins/total /forums/images/%%GRAEMLIN_URL%%/frown.gif

5. Brilliant, this has helped a lot, I must give you my thanks, however I have another problem which, to be honest, I have no clue how it is done.

I have two ratios, and I want to combine them to give an overall ratio.
Here is an example.

Kage v Jacky = 25%
Kage v Jeff = 50%

Kage v Jacky and Jeff =?

It seems to be like you could just do:

Kage v Jacky + Kage v Jeff divided by 2.

Is this right, or am I talking out of my rear?

Thanks again.

6. yeah that is how you do it if i am getting what you want to do. for future reference, this is called averaging.

7. Ok, I've got my table sorted now.
Thanks for all your help, most appreciated.

8. This doesn't work unless you've played against both an equal number of times.

Instead you need to add up individual frequencies. so it should just be (wins over jacky + wins over jeff) divided by (games played vs jacky + games played vs jeff).

(at least this is what sounds intuitive to me)

9. Thanks V, it is more accurate now.