Purchase Solution

# Exponential Distribution using Excel

Not what you're looking for?

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 Summary

Exponential Probability calculations using Excel worksheet function EXPONDIST.

##### 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 , ...

##### Variables in Science Experiments

How well do you understand variables? Test your knowledge of independent (manipulated), dependent (responding), and controlled variables with this 10 question quiz.

##### The Moon

Test your knowledge of moon phases and movement.

##### Intro to the Physics Waves

Some short-answer questions involving the basic vocabulary of string, sound, and water waves.

##### Introduction to Nanotechnology/Nanomaterials

This quiz is for any area of science. Test yourself to see what knowledge of nanotechnology you have. This content will also make you familiar with basic concepts of nanotechnology.