Written by Provides the value closest to a designated quartile within a dataset.
Calculates the percentile rank (percentage) of a specified value in a dataset, returning a value between 0 and 1, exclusive of the specified value.
Returns the value corresponding to a specified percentile within a dataset.
Calculates the value for the cumulative distribution function of the standard normal at a given point.
Computes the median value for a set of numeric data points.
Calculates the highest value within a specified range of cells based on defined criteria.
Identifies the highest numeric value within a given dataset.
Identifies the highest value within a set of numeric values.
Returns the n-th largest value from a dataset, with n defined by the user.
Refer to FTEST.