Calculates the Poisson distribution function (or its cumulative counterpart) for a given value and mean.
Refer to the function POISSON.DIST for detailed insights.
The PHI function provides the result of the standard normal distribution, characterized by a mean of 0 and a standard deviation of 1.
Calculates the number of possible arrangements when selecting a subset of items from a larger group, while considering the order of selection.
Calculates the total number of permutations when selecting a group of items (with replacement) from a larger set of items.
Calculates the percentage rank (or percentile) of a given value within a specified dataset, producing a result from 0 to 1.
Calculates the percentile rank (percentage) of a specified value in a dataset, returning a value between 0 and 1, exclusive of the specified value.
Calculates the percentile rank of a specified value within a given dataset.
Refer to PERCENTILE
Provides the value at a specified percentile of a dataset, excluding the endpoints 0 and 1.