1. Hey Guest, looking for Virtua Fighter 5: Ultimate Showdown content? Rest assured that the game is identical to Virtua Fighter 5: Final Showdown so all current resources on here such as Command Lists with frame data, Combo Lists and the Wiki still apply. However, you can expect some VF5US specific changes to come soon!
    Dismiss Notice

Calculating a win ratio as a percentage - help

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

  1. Genzen

    Genzen Well-Known Member

    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?

  2. Son_of_lau

    Son_of_lau Active Member

    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. Genzen

    Genzen Well-Known Member

    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.

  4. Son_of_lau

    Son_of_lau Active Member

    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...


    then solve for x so...

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

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

    Genzen Well-Known Member

    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. Son_of_lau

    Son_of_lau Active Member

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

    Genzen Well-Known Member

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

    vanity Well-Known Member

    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. Genzen

    Genzen Well-Known Member

    Thanks V, it is more accurate now.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice