+ Reply to Thread
Results 1 to 2 of 2

probability to playoff game event

  1. #1
    Registered User
    Join Date
    02-14-2021
    Location
    Indonesia
    MS-Off Ver
    2006
    Posts
    2

    probability to playoff game event

    hello my name is toto, i want to ask about probability for game events

    this link for sheet :

    Example.xlsx

    i want to know how to calculate or use formula "probablity or chance team go to playoff"
    because im stucked
    Thanks

    *sry for bad english

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    18,524

    Re: probability to playoff game event

    I don't know how helpful this will be but I feel that you would need to know how many matches each team won 2-0 and 2-1 as well as how many they lost 1-2 and 0-2.
    In the attached I tried to work that out based on points.
    I also filled columns C:G using formulas so that the only numbers needing to be input are in columns H:K.
    Columns L:M show the best/worst the team could do points wise given the number of matches they have left to play out of 10.
    If the worst a team could do was better than the best two other teams could do then the chance of that team making the playoff is 100%.
    Conversely if the best a team could do was worse than the worst that six other teams could do then the chance is 0%.
    I feel that knowing how you would assign percentages in between is beyond the realm of Excel, although there may be some contributors here whom could help in that regard.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using HYPGEOMDIST to calculate probability in a card game
    By Kalamari in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2019, 07:57 AM
  2. Excel Probability Function - How to check and apply probability
    By StormerJack in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2019, 03:06 PM
  3. ** Fun ** NFL Playoff Pool - Outcome predition
    By Jimmyray007 in forum Excel General
    Replies: 2
    Last Post: 01-08-2014, 11:39 PM
  4. [SOLVED] Probability of winning the game with multiple variables
    By egemencoskun in forum Excel General
    Replies: 2
    Last Post: 02-11-2013, 06:10 PM
  5. Replies: 1
    Last Post: 06-04-2012, 08:34 AM
  6. How to calculate probability of an event will happen multipe times in a row
    By kokky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2009, 01:54 PM
  7. Game score without game being played
    By Sheila in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-17-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1