Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
mean = 33 days, what's pdf of success in 40 days...
I keep getting .009 and that seems low. Am I using this function incorrectly? |
#2
![]() |
|||
|
|||
![]()
KyWilde -
mean = 33 days, what's pdf of success in 40 days... I keep getting .009 and that seems low. Am I using this function incorrectly? < Yes. If X is an exponentially-distributed uncertain quantity (random variable) with Mean(X) = 33, then the parameter for Excel's EXPONDIST function is Lambda = 1/Mean(X) = 1/33. P(X<=40) = EXPONDIST(40,1/33,True) = 0.70243459 - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |