Difference between revisions of "Manuals/calci/EXPONDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 26: Line 26:
 
*This function is valid only on the interval [0,infinity].
 
*This function is valid only on the interval [0,infinity].
 
The Cumulative Distribution Function is :
 
The Cumulative Distribution Function is :
<math>F(x;\lambda)=1-e^{-\lambda x},   x \ge 0</math>
+
<math>F(x;\lambda)=\begin{cases}
:<math>0    ,   x<0 </math>
+
1-e^{-\lambda x}, & x \ge 0</math>
 +
0    , x<0  
 +
\end{cases}</math>
 
or
 
or
 
:<math>F(x,\lambda)=1-e^{-\lambda x}.H(x)</math>
 
:<math>F(x,\lambda)=1-e^{-\lambda x}.H(x)</math>

Revision as of 00:32, 11 December 2013

EXPONDIST(x,lambda,cu)


  • is the value of the function
  • is the value of the rate parameter
  • is the logical value like TRUE or FALSE

Description

  • This function gives the Exponential Distribution. This distribution is used to model the time until something happens in the process.
  • This describes the time between events in a Poisson process i.e, a process in which events occur continuously and independently at a constant average rate.
  • For e.g Time between successive vehicles arrivals at a workshop.
  • In , is the value of the function, is called rate parameter and (cumulative) is the TRUE or FALSE.
  • This function will give the Cumulative Distribution Function when is TRUE, otherwise it will give the Probability Density Function , when is FALSE.
  • Suppose we are not giving the value, by default it will consider the value is FALSE.
  • This function will give the error result when
1.  or  is non-numeric.
2.  or 

The Probability Density Function of an Exponential Distribution is: or

  • where is the rate parameter and is the Heaviside step function
  • This function is valid only on the interval [0,infinity].

The Cumulative Distribution Function is : Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle F(x;\lambda)=\begin{cases} 1-e^{-\lambda x}, & x \ge 0} 0 , & x<0 \end{cases}</math> or

Examples

Question : If jobs arrive at an average of 15 seconds, per minute, what is the probability of waiting 30 seconds, i.e 0.5 min? Here and

  • =EXPONDIST(0.5,5,TRUE) = 0.917915001
  • =EXPONDIST(5,3,TRUE) = 0.999999694
  • =EXPONDIST(0.4,2,FALSE) = 0.898657928"

See Also

References