Share
Explore BrainMass

Exponential Distribution using Excel

The useful life of an electrical component is exponentially distributed with a mean of 2,500 hours.

a. what is the probability the circuit will last more than 3,000 hours

b. what is the probability the circuit will last between 2,500 and 2,750 hours.

c. what is the probability the circuit will fail within the first 2,000 hours.

Solution Preview

The answers are in the attached Excel file

The useful life of an electrical component is exponentially distributed with a mean of 2,500 hours.
  a. what is the probability the circuit will last more than 3,000 hours

We first need to calculate the probability of circuit failing between 0 and 3,000 hours

x= 3,000 hours
mean= 2,500 hours
lambda= 0.0004 = 1 / 2500
cumulative = 1

Probability of failure between 0 and 3,000 hours= 0.6988 = EXPONDIST(3000 , 0.0004 , ...

Solution Summary

Exponential Probability calculations using Excel worksheet function EXPONDIST.

$2.19