In: Statistics and Probability
Use Excel to generate the probability distribution for a binomial random variable for which there are 20 trials (n = 20) and the probability of success is 0.5 (p = 0.5), and show the graph.
Using Excel and the command .
For different values 0, 1, 2, ..., 20. trials is 20, probability is 0.5, and cumulative is choosen as False.
Then gives . The following output is obtained for different values