Provides a description of the binomial probability distribution and its five cases. Emphasis is placed on the greater than and equal ( ≥ ) case—commonly referred to as the “k-of-n case.” Examples are provided along with notes on how the cumulative binomial compares to other methods used to calculate system reliability for simple series and parallel configurations.
Calculates and graphs the probability of success for pass-fail data. That is, data is trials or demands and not clock time. Use this tool if the conditions for the binomial probability distribution are satisfied. This tool contains six programs where:
- Programs 1-3 are based on the cumulative case ( ≥ ) for the binomial. That is, the calculation addresses x or more successes out of n number of trials.
- Program 4 is based on the exact case for the binomial. That is, the calculation addresses exactly x successes out of n number of trials.
- Program 5 calculates the reliability of a system for e number of elements in a series configuration and for a given minimum element reliability.
- Program 6 is the reverse of Program 5. That is, Program 6 calculates the minimum reliability of each element in a series configuration required for a given system reliability.
This tool requires the security level in Excel to be at medium or lower. To change the security level in Excel 2003 versions:
- Open Excel
- Click Tools
- Click Options
- Click Security Tab
- Click the Macro Security Button
- Click Medium or Low