Part 2. MM4XL Tools > 1. Strategic Tools > Risk Analyst > 4. Functions > 3. Distribution Functions > mmRAYLEIGH(ModalValue)

Risk Analyst

mmRAYLEIGH(ModalValue)

Example

=mmRAYLEIGH(1) can equal 0.391181737.

Application

This is a distribution used to model the time to perform some work, the time to fail of a component of a machine; it is used in the study of sound, light and signal processing, wind speed and other situations where the time variable is crucial.

How to use

The Rayleigh distribution is used to simulate time to perform. Say we are modeling wind speed over a year in order to estimate the energy recovery from a wind turbine. The formula below simulates wind speed in miles with a modal value equal to 8.5 miles per hour:

=mmRAYLEIGH(8.5)

Copy the formula above in 100 cells. You will find that it produces values of wind speed with mode equal to 8.5 miles per hour. Roughly 40% of the simulated values lie below the 8.5 miles and 60% lie above.

Technical profile

Type Continuous distribution.
Syntax =mmRAYLEIGH(ModalValue)
Domain  Monte Carlo Simulation Software: Management Process Risk Analysis
Mode ModalValue
Parameters ModalValue = b > 0
Remarks If any argument is nonnumeric mmRAYLEIGH returns the #VALUE! error value.
Relationships It is a special case of the Weibull distribution.
It is related to the Chi2, to the Exponential, and to the Normal variate.
Graphs
mmRAYLEIGH(1) mmRAYLEIGH(10)
 Monte Carlo Simulation Software: Management Process Risk Analysis  Monte Carlo Simulation Software: Management Process Risk Analysis
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: