View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default How to Manipulate formula for Binomial Distribution

You have not specified the binomial p, but I will guess that p=0.4 from your
ambiguously worded "probability of both f(0) and f(1) individually equal 0.23"
=1-BINOMDIST(1,6,0.4,TRUE)
returns 0.76672.

Jerry

"GH" wrote:

How can I change binomial distribution formula to do:

successes of at least 2 (this equates to 1 - f(0) - (f1)
number of trials 6
probability of both f((0) and f(1) individually equal .23