Create a column that calcuates P(X = k) where k ranges from 0 to 25, for a given sample size (n) ande probability (p). The Excel equations you need to use is shown to the right of the graph.

Zohpius

April 17, 2023

Excel
Biostats- Take Home 3
GOAL: One of the values of speadsheets, is they allow investigators evalaute many difference mathemitical senarios by changing input values. In this assigment, you will investigate how probability (P) and population size (n) inpacts 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 calcuates P(X = k) where k ranges from 0 to 25, for a given sample size (n) ande probability (p). The Excel equations you need to use is shown to the right of the graph.