week 5 math

Binomial in Excel Week 4.html

Week 5 - Example 4

Here is an example by the steps

Binomial Distribution

For 2007 and below use binomdist

For n=10 experiments

X=4

P=.6

Type in a cell

=binom.dist(4,10,.6, FALSE) 

 

For n=10

X<=4

P=.6

type in an excel cell

=binom.dist(4,10,.6,TRUE)

 

For n=10

X<4

P=.6

type in a cell

=binom.dist(3,10,.6, TRUE)

 

For n=10

x>=4

type in a cell

=1-binom.dist(3,10,.6,TRUE)