How to Manipulate formula for Binomial Distribution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks Jerry for your response. The problem I am trying to solve reads "In a
sample of 6 International travelers, what is the probability that AT LEAST 2
will remain with the tour group?" The binomial dist formula computes exact
probability not the "AT LEAST 2" which requires the formula be adjusted to
this.
This is what I am trying to determine. HELP
GH
 
Yes, that is what you asked and I answered the first time. See Help for
BINOMDIST, paying particular attention to the final argument, to understand
the solution.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NORMDIST(x,mean, stdev,false) vs f(x) 3
Formula than understands midnight? 25
Probabilty - Binomial - a simulation game? 4
Count entries in the column translating to minutes. 5
With F1 value, look at A, if match or partial match return B 5
Badly need help with a function 4
Editing Lookup Formula Error 6
Filldown starting from F2 instead of F1 5

Back
Top