NTJOHNSONSUDIST
Returns the Johnson SU distribution for the specified parameters.
Syntax
NTJOHNSONSUDIST(
- x,
- Gamma,
- Delta,
- Lambda,
- Xi,
- Cumulative
)
Parameters
- x is the value for which you want the 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 .
- Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NTJOHNSONSUDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.
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.
1 2 3 4 5 6 7 8
9
A B Data Description 2.5 Value for which you want the distribution 0.8 Value of parameter Gamma 2 Value of parameter Delta 2.5 Value of parameter Lambda 1.2 Value of parameter Xi Formula Description (Result) =NTJOHNSONSUDIST(A2,A3,A4,A5,A6,TRUE) Cumulative distribution function for the terms above =NTJOHNSONSUDIST(A2,A3,A4,A5,A6,FALSE) Probability density function for the terms above - Download sample excel sheet
See also
- NTRANDJOHNSONSU
- NTJOHNSONSUINV
- NTJOHNSONSUKURT
- NTJOHNSONSUMEAN
- NTJOHNSONSUMOM
- NTJOHNSONSUPARAM
- NTJOHNSONSUSKEW
- NTJOHNSONSUSTDEV
- Johnson SU distribution