Review the criteria for a binomial in excel. Example a) On this example we will examine the probability a couple who has 8 children has exactly 5 boys. b) Next we will look at the probability that the

Review the criteria for a binomial in excel.Examplea) On this example we will examine the probability a couple who has 8 children has exactly 5 boys.b) Next we will look at the probability that they have more than 5 boys.c) Finally we will look at the probability that they have at most 5 boys.Assume a .5 chance of having a boy.Solution can be solved using excel.a) On this example we will examine the probability a couple who has 8 children has exactly 5 boys.Type this in an excel cell=binom.dist(5,8,.5,False)and then hit enter.21875 would be the answerb) Next we will look at the probability that they have more than 5 boys.Type this in an excel cell=1-binom.dist(5,8,.5,True)and then hit enter.144531 would be the answerc) Finally we will look at the probability that they have at most 5 boys.Assume a .5 chance of having a boy.Type this in an excel cell=binom.dist(5,8,.5,True)and hit enter.855469 would be the answerInstructions:For your post you will make up a problem similar to this example. Try to have at least 3 scenarios. You will not solve your own problem.