Archive

ROW

Returns a table with a single row containing values that result from the expressions given to each column.

RANKX

Returns the ranking of a number in a list of numbers for each row in the table argument.

RANK.EQ

Returns the ranking of a number in a list of numbers.

POISSON.DIST

Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.

PERCENTILEX.INC

Returns the percentile number of an expression evaluated for each row in a table.

PERCENTILEX.EXC

Returns the percentile number of an expression evaluated for each row in a table.

PERCENTILE.INC

Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.

PERCENTILE.EXC

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

NORM.S.INV

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

NORM.S.DIST

Returns the standard normal distribution (has a mean of zero and a standard deviation of one).