Written by Computes the equivalent normalized value of a random variable based on the distribution’s mean and standard deviation.
Fetches the user-specified nth smallest value from a given dataset.
Determines the slope of the line derived from the linear regression of a given dataset.
Provides the ranking of a specified value within a dataset. For duplicate values, it returns the highest rank among those entries.
Returns the ranking position of a specified value within a dataset. If multiple instances of the same value exist, the average rank of those entries will be determined.
Determines the position of a specified value within a dataset.
Refer to QUARTILE function for details.
Calculates the value closest to a specified quartile of a dataset, excluding 0 and 4.
Provides the value closest to a designated quartile within a dataset.
Calculates the Poisson distribution function (or its cumulative counterpart) for a given value and mean.