Documentation/Calc Functions/RANK.AVG

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

RANK.AVG

Category:

Statistical Analysis

Summary:

Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, the average rank is returned.

Syntax:

RANK.AVG(Value; Data; Type)

Returns:

Arguments:

Value is the value, whose rank is to be determined.

Data is the array or range of data in the sample.

Type (optional) is the sequence order. Type = 0 means descending from the last item of the array to the first (this is the default), Type = 1 means ascending from the first item of the range to the last.

Additional details:

The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank.

Examples:

=RANK.AVG(A10;A1:A50) returns the ranking of the value in A10 in value range A1:A50. If the specified value does not exist within the range, an error message is displayed.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: