Written by Produces a vertical array of the values that occur with the highest frequency in a specified range or dataset.
Calculates the median value from a set of numbers.
Provides the coefficients of a linear equation based on the given data.
Returns the k-th largest value from a given data set.
Defines a conditional assessment to execute
Creates a calculated set of members or tuples by sending a set expression to the server’s cube, which generates the set and subsequently relays that set to Microsoft Office Excel.
Calculates the correlation coefficient of two datasets.
Returns the index at which a substring first appears within a given text.
Fetches the user-specified nth smallest value from a given dataset.
Provides the ranking of a specified value within a dataset. For duplicate values, it returns the highest rank among those entries.