We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel / Maths problem - please help!

13»

Comments

  • getmore4less
    getmore4less Posts: 46,882 Forumite
    Part of the Furniture 10,000 Posts Name Dropper I've helped Parliament
    This is an integer problem so the inputs should be the integers not a pre calculated rounded %.

    Your second post has 322 games with a win rate of 59.36% that does not match the potential wins of 191(59.32%) or 192(59.63%)

    you also have the issue that each time you add a game it could be a win or a lose that moves the % a bit
    That means the target may be hit over a range of games depending on the win/loss of the next game

    if we allow you could have a winning streak over short number of games say upto 20  while up to that point you have been playing to the rate of those those 322 games never going below that rate 
    you could go over 54% by 1450 games  by 1500 you only need a win run of 15 and by 1550 8 in a row.

    Using 191/322 as the input never going below that ratio of wins,
    you hit 54% for the first time at 1600 but you need to have played 1611 games to stay over 54% with that win rate.
     
    new games new wins total % wins
    1595 947 53.9995%
    1596 947 53.9948%
    1597 948 53.9988%
    1598 948 53.9941%
    1599 949 53.9981%
    1600 950 54.0021%
    1601 950 53.9974%
    1602 951 54.0014%
    1603 951 53.9967%
    1604 952 54.0007%
    1605 953 54.0047%
    1606 953 54.0000%
    1607 954 54.0040%
    1608 954 53.9993%
    1609 955 54.0033%
    1610 955 53.9986%
    1611 956 54.0026%
    1612 957 54.0066%
    1613 957 54.0019%
    1614 958 54.0059%
    1615 958 54.0012%


  • WaywardDriver
    WaywardDriver Posts: 546 Forumite
    Seventh Anniversary 500 Posts
    edited 3 July 2020 at 9:38AM
    Leaving aside the maths, who are the OP's opponents? Other players online or a computer program? I'd guess the OP would want to improve his game by playing against more skilful opponents which would affect his win %'s.  Are the online players random, does the computer opponent have a skill level?
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 352.1K Banking & Borrowing
  • 253.5K Reduce Debt & Boost Income
  • 454.2K Spending & Discounts
  • 245.1K Work, Benefits & Business
  • 600.7K Mortgages, Homes & Bills
  • 177.4K Life & Family
  • 258.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.