Binomial Distribution in Qlikview

[#1]

Hi All,

How do I implement binomial distribution function in Qlikview, please find the attached excel file for the use case scenario.

Thanks,

Mahe

[sunny_talwar]

See if this helps:

Cumulative binomial distribution in equation editor

[sunny_talwar]

I don't really know how this works, but is the reference to C6 correct here?

[sunny_talwar]

Should it be referencing C3 here?

[#5]

Yes Sunny, it referering C3

[sunny_talwar]

May be like this:

=(Fact(vInput)/(Fact(Row)*Fact(vInput-Row))) * Pow(0.01, Row) * Pow(0.99, vInput - Row)