+ Reply to Thread
Results 1 to 2 of 2

Need help making a formula for % chance of all combinations of [set 1] + [set 2] > k

  1. #1
    Registered User
    Join Date
    02-10-2022
    Location
    United States
    MS-Off Ver
    Excel 2021
    Posts
    4

    Need help making a formula for % chance of all combinations of [set 1] + [set 2] > k

    To give an example situation of the formula I need:

    Golden State Warriors vs Utah Jazz's past matchups within the last 4 years show that GS scores between [79-132] and Utah between [92-126] (dataset 1 and 2, respectively). Voiding all possibilities of draws, and assuming all other combinations of scores in these ranges are equally likely, the probability that this matchup will score a total greater than ___ is ___%.

    Essentially trying to get a % chance output where x>k from a giant probability tree, but voiding where both datasets would use/add the same number.

    Thank you,
    N0043

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

    Re: Need help making a formula for % chance of all combinations of [set 1] + [set 2] > k

    Hello N0043 and Welcome to Excel Forum.
    This proposes a low-tech way:
    1. Populate B1 with the value used for K
    2. Populate B2 with: =COUNTIFS(D2:AL55,">"&B1,D2:AL55,"<>")/COUNTIFS(D2:AL55,"<>")
    3. Populate C2:C55 with GS scores: 79:132 (this may be quickly done typing 79 into cell C2, right clicking the fill handle, pull down and back up, select series, select column and type 132 into the Stop Value window)
    4. Populate D1:AL1 with Utah Jazz scores 92:126 (this may be quickly done typing 92 into cell D1, right clicking the fill handle, pull down and back up, select series, row should already be selected and type 126 into the Stop Value window)
    5. Populate D2:AL55 with: =IF($C2=D$1,"",SUM($C2,D$1))
    Let us know if you have any questions.
    Attached Files Attached Files
    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. adding chance to a formula
    By bellaaaaa4000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2020, 07:52 PM
  2. [SOLVED] Any chance to process multiple formulas in one formula?
    By annica123 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-02-2019, 11:07 AM
  3. Making 40 different combinations based on salary, position and percentage we want
    By Fridge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2019, 10:31 PM
  4. [SOLVED] Formula to chance decimal to imperial
    By Lensmeister in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2014, 07:37 AM
  5. second chance for Indexation formula problem (truly sorry for first post)
    By peer_1988 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2014, 07:12 AM
  6. Making a list of all possible combinations
    By jhelliar in forum Excel General
    Replies: 2
    Last Post: 02-03-2012, 06:12 AM
  7. [SOLVED] Random Chance Formula?
    By MasterCoder84 in forum Excel General
    Replies: 2
    Last Post: 06-30-2010, 11:38 PM

Tags for this Thread

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