EXPONENTIAL DISTRIBUTION EXCEL

# EXPONENTIAL DISTRIBUTION EXCEL - = 2 Exponential...

This preview shows pages 1–3. Sign up to view the full content.

NORMAL DISTRIBUTION Characteristics If the number of events is Poisson with average number of events in the interval = λ , then the time between events is exponential with average time between events = 1/ λ Density function = λ e - λ x EXCEL EXPONDIST(t, λ ,FALSE) = The density at X = t for an exponential distribution with mean = 1/ λ (Not a probability) EXPONDIST(t, λ ,TRUE) = P(X t) for an exponential distribution with mean = 1/ λ Examples Example 1 EXPONDIST(t, λ ,FALSE) for an Exponential Distribution λ = 2 Exponential Distribution for lambda = 2 f(.6) 0 0.5 1 1.5 2 2.5 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 X f(X) =EXPONDIST(.6,2,FALSE) gives the height of this line (NOT A PROBABILITY)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Examples 2 -- EXPONDIST(t, λ ,TRUE) for an Exponential Distribution with
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: = 2 Exponential Distribution for lambda = 2 P(X &lt;= 1.2) 0.5 1 1.5 2 2.5 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 X f(X) =EXPONDIST(1.2,2,TRUE) gives cumulative probability up to 1.2 X Exponential Distribution for lambda = 2 P(X &gt;= .7) 0.5 1 1.5 2 2.5 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 X f(X) =1-EXPONDIST(.7,2,TRUE) gives probability x exceeds .7 Exponential Distribution for lambda = 2 P(.5 &lt;= X &lt;= 1.3) 0.5 1 1.5 2 2.5 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 X P(.5 X 1.3) = EXPONDIST(1.3,2,TRUE) -EXPONDIST(.5,2,TRUE)...
View Full Document

## EXPONENTIAL DISTRIBUTION EXCEL - = 2 Exponential...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online