ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Expondist function... (https://www.excelbanter.com/excel-worksheet-functions/18198-expondist-function.html)

KyWilde

Expondist function...
 
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?


Michael R Middleton

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




All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com