=1-BINOMDIST(75,200,0.4,TRUE)

"Dennis" wrote:

I am working on a question for a statistics class. We are supposed to find
Excel program to answer the following question.

The probability that a worker is absent from work more than 2 times a year
is 0.4. There are 200 workers in the sample. What is the probability that
more than 7 workers will be absent more than 2 times per year. The answer is
.741044. Can anyone help me find the function that will perform this
operation?
--
Dennis