The PPOINT distribution computes the value of a variable that follows a specified
distribution for which the probability of being smaller or equal to x is equal to the specified
percentage.
Syntax
IDAX.PPOINT(in parameter_string varchar(32672))
A list of
<parameter>=<value> entries that are separated by a comma.
Parameter descriptions
- intable
- Mandatory.
- The input table.
- Data type: VARCHAR(256)
- type
- Mandatory.
- The kind of distribution that is to be used.
- n
- normal (QNORM)
- c
- chi-square (QCHISQ)
- t
- t-student (QT)
- u
- uniform (QUNIF)
- e
- exponential (QEXP)
- w
- Weibull (QWEIBULL)
- You can calculate several distributions simultaneously by concatenating the distribution
abbreviations in the parameter value.
- Data type: VARCHAR(ANY)
- incolumn
- Mandatory.
- The numeric column of the input table that contains the percentage.
- The percentage must be in the range of 0 - 1.
- Data type: VARCHAR(128)
- id
- Mandatory.
- The column of the input table that identifies a unique instance ID.
- Data type: VARCHAR(128)
- outtable
- Mandatory.
- The output table.
- Data type: VARCHAR(256)
- df
- Optional.
- The number of degrees of freedom for a student distribution or chi-square distribution.
- Default: none
- Data type: INT8
- min
- Optional.
- The minimum value for a uniform distribution.
- Default: none
- Data type: DOUBLE
- max
- Optional.
- The maximum value for a uniform distribution.
- Default: none
- Data type: DOUBLE
- scale
- Optional.
- The scale for an exponential distribution or Weibull distribution.
- Min: 0.00000000001
- Default: none
- Data type: DOUBLE
- shape
- Optional.
- The shape for Weibull distribution.
- Default: none
- Data type: DOUBLE
- mean
- Optional.
- The mean value for a normal distribution.
- Default: none
- Data type: DOUBLE
- variance
- Optional.
- The variance for a normal distribution.
- Min: 0.00000000001
- Default: none
- Data type: VARCHAR(ANY)
Returned information
INT8 the number of input table values for which a percentage point is calculated.