DISTINCT (table)
The DISTINCT function that receives the name of a table as an input argument returns the table after eliminating duplicate rows.
LASTNONBLANK
The LASTNONBLANK function returns the last value in a column for which an expression does not return a Blank.
FIRSTNONBLANK
The FIRSTNONBLANK function returns the first value in a column for which an expression does not return a blank.
POISSON.DIST
The POISSON.DIST function returns the Poisson distribution for the number of events and the indicated mean.
PERMUT
The PERMUT function returns the number of permutations without repetition for a set of elements selected in blocks of a certain size.
PERCENTILEX.INC
The PERCENTILEX.INC function returns the value corresponding to the k-th percentile of the values taken by an expression that is evaluated for all the rows of a table, k belonging to the closed interval [0, 1].
PERCENTILEX.EXC
The PERCENTILEX.EXC function returns the value corresponding to the k-th percentile of the values taken by an expression that is evaluated for all the rows of a table, k belonging to the open interval (0, 1).
PERCENTILE.INC
The PERCENTILE.INC function returns the value corresponding to the k-th percentile of the values in a range, k belonging to the closed interval [0, 1].
PERCENTILE.EXC
The PERCENTILE.EXC function returns the value corresponding to the k-th percentile of the values in a range, with k belonging to the open interval (0, 1).
NORM.S.INV
The NORM.S.INV function returns the inverse of the cumulative standard normal distribution of a probability.
