Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KyWilde
 
Posts: n/a
Default 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?

  #2   Report Post  
Michael R Middleton
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"