NTTRIANGULARPARAM
Returns parameters of the triangular distribution for the specified mean, standard deviation and skewness.
Syntax
NTTRIANGULARPARAM(
Mean,
Stdev,
Skew
)
Parameters
- Mean is the arithmetic mean of the distribution.
- Stdev is the standard deviation of the distribution (Positive value).
- Skew is the skewness of the distribution.
Example
- The example may be easier to understand if you copy it to a blank worksheet\
How to copy an example
-
Create a blank workbook or worksheet.
-
Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
-
Press CTRL+C.
-
In the worksheet, select cell A1, and press CTRL+V.
-
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
| A | B | |
|---|---|---|
| 1 | Data | Description |
| 2 | 0 | Arithmetic mean of the distribution |
| 3 | 3 | Standard deviation of the distribution |
| 4 | 0.1 | Skewness of the distribution |
| 5 | Formula | Description (Result) |
| 6 | =NTTRIANGULARPARAM(A2,A3,A4) | Parameters of the distribution Min, Max and Mode for the terms above |
Note The formula in the example must be entered as an array formula. After copying the example to a blank worksheet, select the range A6:A8 starting with the formula cell. Press F2, and then press CTRL+SHIFT+ENTER.