Answer to Question #174549 in Statistics and Probability for Kim

Question

BINOMDIST(2,52,0.02,TRUE)

Answer 1

BINOMDIST(2,52,0.02,TRUE)

The last argument for this function, when TRUE, indicates the probability returned should be cumulative. That is to say, it gives the sum 

$$P(0)+P(1)+...+P(k)$$

$$\text{BINOMDIST}(2,52,0.02,TRUE)\approx0.91406589702$$