Question

Give the complete distribution for a binomial distribution, for six repetitions

If possible please also give the excel command to do this

Answer 1

1st part answer:

The distribution function of the binomial distribution function is

     where  ,

p is the probability of success and q is the probability of failure

for six repetitions ie for 6 trails it would be

then the equation obtained would be

  

consider the first term

   where

similarly

the rest of the terms can be ignored becasuse x is less than n

now for  

we can write

so the whole term changes to

(or)

  

now the whole term for six repetitions can be written as follows

   or

2nd partanswer:

The syntax for excel command for Binoial distribution of individual term is as follows

BINOM.DST(Number_s,Trails,Probability_s,Cumulative)

where Number_s is the nuber of successes in trails,

Trails is the number of independent trails,

Probability_s is the probability of success in each trail, and

Cumulative is the logical value: for the cumulative distribution function, use TRUE for the probabiity mass function, use FALSE

to enter it in formula section it can be found under statiscal formulas and looks like the below image