Create the calculations and graph shown above. The command for calculating a binomial probability in Excel is =BINOM. DIST(k,n,p,FALSE). Create a column that calculates P(X = k) where k ranges from 0 to 25, for a given sample size (n) and probability (p).

GOAL: One of the values of spreadsheets, is they allow investigators evaluate many difference mathematical scenarios by changing input values. In this assignment, you will investigate how probability (P) and population size (n) impacts the shape of the binomial distribution.

Create the calculations and graph shown above. The command for calculating a binomial probability in Excel is =BINOM. DIST(k,n,p,FALSE). Create a column that calculates P(X = k) where k ranges from 0 to 25, for a given sample size (n) and probability (p). The Excel equations you need to use is shown to the right of the graph.