NTJOHNSONSUINV
Returns the inverse of the cumulative distribution function for a specified Johnson SU distribution.
Syntax
NTJOHNSONSUINV(
prob,
Gamma,
Delta,
Lambda,
Xi
)
Parameters
- prob is a probability corresponding to the normal distribution .
- Gamma is a parameter of the distribution .
- Delta is a parameter of the distribution .
- Lambda is a parameter of the distribution .
- Xi is a parameter 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.5 | Probability associated with the Johnson SU distribution |
3 | 0.8 | Value of parameter Gamma |
4 | 2 | Value of parameter Delta |
5 | 2.5 | Value of parameter Lambda |
6 | 1.2 | Value of parameter Xi |
7 | Formula | Description (Result) |
8 | =NTJOHNSONSUINV(A2,A3,A4,A5,A6) | Inverse of the cumulative distribtion function for the terms above |