mytest > help > Part 2. MM4XL Tools > 1. Strategic Tools > Risk Analyst > 4. Functions > 2. Utility Functions > Function mmWEIBULLEST(Life, Shape, [Optional: SelectedValue])

Risk Analyst

Function mmWEIBULLEST(Life, Shape, [Optional: SelectedValue])

This function helps finding the input values of the mmWEIBULL distribution. It can be entered as an array function or, by setting the optional value, as a common function.

An array formula is entered with Ctrl+Shift+Enter, and in this case it requires you to select two columns on one row in the input range.

Example

The following formula returns the input parameters to the mmWEIBULL function for a machine with an average time of functioning without problems equal to 93 months and a standard deviation of 1.3 months. Select range, for instance, A1:B1 type the folowing formula and press Ctrl+Shift+Enter:

mmWEIBULLEST(1.3, 93, 0)

To compute only the Life parameter of the function type the following formula in one cell and press enter:

mmWEIBULLEST(1.3, 93, 1)

To compute only the Shape parameter of the function type the following formula in one cell and press enter:

mmWEIBULLEST(1.3, 93, 2)

mmWEIBULLEST(1.3, 93, 0) returns the values 91.10 and 93.58, which can be used as Life and Shape parameters to the mmWEIBULLL function, respectively.
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: