Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to use?
What function should I use to find the probability of 2 girls being absent
out of 5 total students being absent in a class of 25 total students? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to use?
To attack the problem, I would either use the hypergometric distribution
(HYPGEOMDIST function) or approximate it with the binomial distribution (BINOMDIST), but either way you have neither adequately identified the probability that you want to calculate nor given enough information to calculate it. Jerry "Adam" wrote: What function should I use to find the probability of 2 girls being absent out of 5 total students being absent in a class of 25 total students? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |