Binomial distribution with and =Binom.dist excel formula can be used
can be obtained from =BINOM.DIST(1,6,0.2,FALSE) which gives 0.393216
can be obtained from =1-BINOM.DIST(1,6,0.2,TRUE) which gives 0.34464
can be obtained from =BINOM.DIST(3,6,0.2,TRUE) which yields 0.98304
can be obtained from =BINOM.DIST(2,6,0.2,TRUE) which yields 0.90112
Comments