+ Reply to Thread
Results 1 to 2 of 2

Complex BINOMDIST function

Hybrid View

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    1

    Complex BINOMDIST function

    trying to work through experiment data, I am trying to find smallest n (# study subjects at start of study) that will allow a 96 percent chance of having at least 75 subjects (m=75) remaining at end of the study. there's a 90 percent chance that the subject will remain in the study (p= 0.9).

    the range of possible n's (subjects) is 75-100

    tried using =BINOMDIST(75,75,.9,1) to find the chance for n=75 that there are at least 75 subjects remaining in the study at the end... but no results. is there a way to manipulate the formula that i'm missing?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Complex BINOMDIST function

           ---A---- ---B---- ---C---- ----------------D----------------
       1   Subjects Failures   Prob                                    
       2        100       25 0.999996 C2: =BINOMDIST(B2, A2, 10%, TRUE)
       3         99       24 0.999989                                  
       4         98       23 0.999972                                  
       5         97       22 0.999931                                  
       6         96       21 0.999832                                  
       7         95       20 0.999606                                  
       8         94       19 0.999106                                  
       9         93       18 0.998042                                  
      10         92       17 0.995869                                  
      11         91       16 0.991618                                  
      12         90       15 0.983675                                  
      13         89       14 0.969555                                  
      14         88       13 0.945758                                  
      15         87       12 0.907898                                  
      16         86       11 0.851326                                  
      17         85       10 0.772388                                  
      18         84        9 0.670233                                  
      19         83        8 0.548620                                  
      20         82        7 0.416751                                  
      21         81        6 0.288098                                  
      22         80        5 0.176917                                  
      23         79        4 0.093530                                  
      24         78        3 0.040754                                  
      25         77        2 0.013690                                  
      26         76        1 0.003145                                  
      27         75        0 0.000370
    The formula for the first line calculates the probability of having at most at most 25 failures in 100 trials when the probability of failure is 10%.

    For 89 subjects (trials), the probability of at most 14 failures (leaving 75) is 96.9%
    Last edited by shg; 04-11-2012 at 01:36 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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