Purchase Solution

Exponential Distribution using Excel

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
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 , ...

Purchase this Solution
Free BrainMass Quizzes
Basic Physics

This quiz will test your knowledge about basic Physics.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Exponential Distribution Function and Derivation of the Equation

    Exponential distribution functions and derivation of the equations are examined. The expert uses Excel Data Analysis and charts.

  • Probability: expected value using exponential distribution

    582145 Probability: expected value using exponential distribution Please assist in answering the following question. Please submit details of work including excel sheet used to arrive to the solution.

  • Time Series Analysis and Forecast

    Thus, we conclude that the data exhibits a monthly or seasonal distribution pattern. Exponential smoothing forecast has been performed on the given data using no holdout period and requesting 12 months of future forecasts.

  • Panic Attacks and Exponential Distribution

    152431 Panic Attacks and Exponential Distribution It has been demonstrated that the time until a panic attack is experienced by students during a statistics exam can be modeled as an exponential distribution with λ equal to .037^-1 minutes.

  • 12 Multiple Choice Word Problems involving the Binomial, Normal, Poisson and Exponential Probability Distributions

    Answer questions 11and 12 using the preceding information and modeling this situation as an exponential distribution. 11.

  • Computing Averages and Probability Using Excel

    For parts a through e; assume µ = 15 This needs to be completed using Excel. Please see attachments. The expert examines computing the averages and probability using Excel.

  • Queuing problem: Average time a customer spends in Queue

    Hi The attached excel file contain a step by step procedure and formulas to calculate P(0), Wq and Lq for a multiserver queuing model with Arrival rate following poission distribution while service rate following an Exponential distribution.

  • The probability

    Students arrive at a rate of about four per minute according to a Poisson distribution. The single cashier ringing up sales takes about 12 seconds per customer, following an exponential distribution.

  • Simulation problem using software

    Generate 10,000 Yi's and compute ten sample means and sample variances using 1,000 Yi's each, respectively. Comment on the convergence of Yi to the steady-state distribution. You can use wither Arena or Excel for this simulation.

  • Forecast Analysis

    For the data in the Excel file Baseball Attendance do the following: a. Develop spreadsheet models for forecasting attendance using single moving average and single exponential smoothing. b.

View More Related Solutions