Question

Assume that Xtilde operator bin(n,p). What EXCEL formula is used to calculate P(X=x)?

Answer 1

EXCEL formula used to calculate P(X=x) is

BINOMDIST(Number_s, Trials, Probability_s, Cumulative)

Where,

• Number_s    is the number of successes in trials.

• Trials    is the number of independent trials.

• Probability_s     is the probability of success on each trial.

• Cumulative     is a logical value that determines the form of the function. If cumulative is TRUE, then BINOMDIST returns the cumulative distribution function, which is the probability that there are at most number_s successes; if FALSE, it returns the probability mass function, which is the probability that there are number_s successes.