Thread: is there a function like NORMSINV for exponential distribution
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
  
Posts: 837
Default is there a function like NORMSINV for exponential distribution
-LN(1-p)/lambda
is the inverse of EXPONDIST(x,lambda,TRUE)

Jerry

"Stuart Douglas" wrote:

I am trying to calculate safety stock using an exponential distribution need
to calculate the safety factor for a desired service level
Reply With QuoteReply With Quote