O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 59. Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project

  • How can I estimate the probability that a machine will work without failing for at least 20 hours?

  • How can I estimate the probability that hanging drywall in a building will take more than 200 hours?

The Weibull random variable is a continuous random variable that is often used to model the lifetime of a machine. If we have data about how long similar machines have lasted in the past, we can estimate the two parameters (alpha and beta) that define a Weibull random variable. You can then use the WEIBULL function in Microsoft Office Excel 2007 to determine probabilities of interest, such as an estimate of how long a machine will run without failing.

The Beta ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required