topic Re: Binomial Distribution in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281885#M401848 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>=(Fact(vInput)/(Fact(Row)*Fact(vInput-Row))) * Pow(0.01, Row) * Pow(0.99, vInput - Row)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148502_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 05 Jan 2017 20:17:34 GMT sunny_talwar 2017-01-05T20:17:34Z Binomial Distribution in Qlikview https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281880#M401843 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How do I implement binomial distribution function in Qlikview, please find the attached excel file for the use case scenario.</P><P></P><P>Thanks,</P><P>Mahe</P></BODY></HTML> Thu, 05 Jan 2017 19:42:45 GMT https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281880#M401843 2017-01-05T19:42:45Z Re: Binomial Distribution in Qlikview https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281881#M401844 <HTML><HEAD></HEAD><BODY><P>See if this helps:</P><P><A href="https://community.qlik.com/thread/243863">Cumulative binomial distribution in equation editor</A></P></BODY></HTML> Thu, 05 Jan 2017 20:03:48 GMT https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281881#M401844 sunny_talwar 2017-01-05T20:03:48Z Re: Binomial Distribution in Qlikview https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281882#M401845 <HTML><HEAD></HEAD><BODY><P>I don't really know how this works, but is the reference to C6 correct here?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148492_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 05 Jan 2017 20:06:35 GMT https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281882#M401845 sunny_talwar 2017-01-05T20:06:35Z Re: Binomial Distribution in Qlikview https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281883#M401846 <HTML><HEAD></HEAD><BODY><P>Should it be referencing C3 here?</P></BODY></HTML> Thu, 05 Jan 2017 20:08:35 GMT https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281883#M401846 sunny_talwar 2017-01-05T20:08:35Z Re: Binomial Distribution in Qlikview https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281884#M401847 <HTML><HEAD></HEAD><BODY><P>Yes Sunny, it referering C3</P></BODY></HTML> Thu, 05 Jan 2017 20:13:16 GMT https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281884#M401847 2017-01-05T20:13:16Z Re: Binomial Distribution in Qlikview https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281885#M401848 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>=(Fact(vInput)/(Fact(Row)*Fact(vInput-Row))) * Pow(0.01, Row) * Pow(0.99, vInput - Row)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148502_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 05 Jan 2017 20:17:34 GMT https://community.qlik.com/t5/QlikView/Binomial-Distribution-in-Qlikview/m-p/1281885#M401848 sunny_talwar 2017-01-05T20:17:34Z