Which Excel function would generate a single random X value for a binomial random variable with parameters n = 16 and π = .25?
A)=BINOM.DIST(RAND(),16,.25,0)
B)=BINOM.DIST(0,16,.25,RAND())
C)=BINOM.INV(16,.25,RAND())
D)=BINOM.INV(0,16,.25,RAND())

Question

Quizplus · Accepted Answer

BINOM.INV(16,.25,RAND()) is the correct function because it calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a random number, effectively generating a random binomial variable with n = 16 and π = .25.

Which Excel Function Would Generate a Single Random X Value