| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Probability
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Probability
Are you sure that it didn't ask for the probability of more than *75*,
rather than more than 7? -- David Biddulph "Dennis" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Probability
You are right, it is 75.
-- Dennis "David Biddulph" wrote: Are you sure that it didn't ask for the probability of more than *75*, rather than more than 7? -- David Biddulph "Dennis" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Probability
Dennis,
I believe the way to solve the problem is to calculate 1 - (probability that 7 or fewer people miss 2 days of work) = 1 - P(7 people miss 2 days of work) - P(6 people miss 2 days of work) - P(5 people miss 2 days of work) ... - P(0 people miss 2 days of work). This can likely all be calculated using the binomial function in excel... BINOMDIST "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Probability
Good! It's always comforting if given the answer you can work out what the
question is. I wondered whether your lecturer may have hoped that you use something like the Central Limit Theorem approximation to the Binomial Distribution (if you've covered that in your syllabus), but that doesn't come to quite the answer you gave. You can let Excel do it the crude number-crunching way, and work out the probability that the number absent is zero, then the probability for 1, then for 2, etc. You can add up the probabilities for N = 0 to 200 and confirm that you've got your formula right by seeing that these add up to 1. You can add up p(N) for N = 0 to 75, and that will give the probability that the number is 75 or fewer; subtract that from 1 and you've got the number you're after. If you want, you can let Excel plot the crude number crunching value for the cumulative distribution and also plot the Central Limit Theorem approximation. -- David Biddulph "Dennis" wrote in message ... You are right, it is 75. -- Dennis "David Biddulph" wrote: Are you sure that it didn't ask for the probability of more than *75*, rather than more than 7? -- David Biddulph "Dennis" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Probability
=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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Probability
Thanks Martin!!!!
-- Dennis "Martin P" wrote: =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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| probability density function | Excel Worksheet Functions | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| XY labels in probability chart | Charts and Charting in Excel | |||
| Selecting at random with weighted probability | Excel Worksheet Functions | |||
| How do I graph normal probability distributions in excel? | Excel Worksheet Functions | |||
Linear Mode
