RANK.AVG
StatisticalRANK.AVG helps you perform summary and inferential functions for descriptive and statistical analysis.
Overview
Start with "=" then enter RANK.AVG(number, ref, [order]). Keep argument order as shown and use cell ranges where appropriate.
Backend scalar pathComplete docs
Syntax & Arity
=RANK.AVG(number, ref, [order])
2 to 3 arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| number | Required | Single | Numeric input value. |
| ref | Required | Single | Input argument used by this function. |
| order | Optional | Single | Optional argument for advanced control. |
Example Inputs & Outputs
Formula
=RANK.AVG(<number>, <ref>, <order>)
Example Output
Statistical summary value
Replace placeholders with your worksheet values or ranges to compute a result.