title: Cumulative Binomial Distribution in Power Query
body: <p>I'm looking to do a cumulative binomial distribution in power query.  The data I have is:</p>
  <ol>
  <li>Employee</li>
  <li>Audits Completed</li>
  <li>Failed Audits</li>
  </ol>
  <p>I want to know the probability that an employee with less than a 5% audit failure rate is good or lucky.  Example, if an employee is audited 20 times with 0 failures, a binomial distribution will say the probability of that with a 5% true failure rate is 36%, so that employee may be lucky.
  Example 2, for an employee audited 100 times with 1 failure, I would calculate they have 0.6% chance of having 0 failure given a 5% failure rate, and  a 3.1% chance of 1 failure, for a 3.7% cumulative chance of having 1 or fewer failures by luck alone.</p>