Difference between revisions of "Documentation/How Tos/Calc: PERCENTRANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| (13 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | {{DISPLAYTITLE:PERCENTRANK function}} |
| + | {{Documentation/CalcFunc StatisticalTOC | ||
| + | |ShowPrevNext=block | ||
| + | |PrevPage=Documentation/How_Tos/Calc:_PERCENTILE_function | ||
| + | |NextPage=Documentation/How_Tos/Calc:_QUARTILE_function | ||
| + | }}__NOTOC__ | ||
== PERCENTRANK == | == PERCENTRANK == | ||
| Line 9: | Line 14: | ||
: <tt>'''number'''</tt> is the number whose percentage rank is to be found within the unordered range or array of numbers <tt>'''numberlist'''</tt>. | : <tt>'''number'''</tt> is the number whose percentage rank is to be found within the unordered range or array of numbers <tt>'''numberlist'''</tt>. | ||
| − | : <tt>'''PERCENTRANK'''</tt> internally assigns a rank to <tt>'''number'''</tt>, where 0 is the rank of the lowest number, 1 of the next lowest and so on. If <tt>'''number'''</tt> | + | : <tt>'''PERCENTRANK'''</tt> internally assigns a rank ''r'' to <tt>'''number'''</tt>, where 0 is the rank of the lowest number, 1 of the next lowest and so on. If <tt>'''number'''</tt> is not in <tt>'''numberlist'''</tt>, it is assigned a fractional rank proportionately between the rank of the numbers on either side (see the examples). Where ''N'' is the count of numbers in <tt>'''numberlist'''</tt>, <tt>'''PERCENTRANK'''</tt> returns ''r'' / (''N''-1), which is a fraction between 0 and 1 inclusive. |
| − | : This function is of limited use with a small list of numbers. It may be useful for example when determining where a score lies within all scores for a test, in which case the formula returned can be stated as ''L'' / (''N''-1), where ''L'' is the count of | + | : This function is of limited use with a small list of numbers. It may be useful for example when determining where a score lies within all scores for a test, in which case the formula returned can be stated as ''L'' / (''N''-1), where ''L'' is the count of scores which are lower than <tt>'''number'''</tt>. |
=== Example: === | === Example: === | ||
| + | <tt>'''PERCENTRANK(A2:A99; A7)'''</tt> | ||
| + | : where cells A2:A99 contain scores from a test, returns the percent rank (as a fraction) for the student whose test score is in cell A7. | ||
| + | |||
| + | The next two examples illustrate the calculation, but have little practical application: | ||
| + | |||
<tt>'''PERCENTRANK({3; 4; 9; 11; 12}; 4)'''</tt> | <tt>'''PERCENTRANK({3; 4; 9; 11; 12}; 4)'''</tt> | ||
: returns <tt>'''0.25'''</tt>. | : returns <tt>'''0.25'''</tt>. | ||
<tt>'''PERCENTRANK({9; 3; 7; 8}; 6)'''</tt> | <tt>'''PERCENTRANK({9; 3; 7; 8}; 6)'''</tt> | ||
| − | : returns <tt>'''0.25'''</tt>. The lowest number <tt>'''3'''</tt> is assigned rank 0; the next highest number <tt>'''7'''</tt> is assigned rank 1. <tt>'''6'''</tt> is assigned a rank proportionately between these, 0.75. There are 4 numbers in the list, so the result is calculated as 0.75/(4-1) = 0.75/3 = 0.25. | + | : returns <tt>'''0.25'''</tt>. The lowest number <tt>'''3'''</tt> is assigned rank '0'; the next highest number <tt>'''7'''</tt> is assigned rank '1'. <tt>'''6'''</tt> is assigned a rank proportionately between these, rank '0.75'. There are 4 numbers in the list, so the result is calculated as 0.75/(4-1) = 0.75/3 = 0.25. |
| − | === | + | ===Issues: === |
| − | + | * Despite its name, <tt>'''PERCENTRANK'''</tt> returns a fraction, not a percentage. | |
| − | |||
| − | [[Documentation/How_Tos/Calc: | + | {{SeeAlso|EN| |
| + | * [[Documentation/How_Tos/Calc: RANK function|RANK]] | ||
| + | * [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]] | ||
| − | + | * [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]] | |
| − | * | + | |
| + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
| + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
| + | [[Category: Documentation/Reference/Calc/Statistical functions]] | ||
Latest revision as of 14:54, 2 February 2024
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
PERCENTRANK
Returns the percentage rank of a number in a list of numbers.
Syntax:
PERCENTRANK(numberlist; number)
- number is the number whose percentage rank is to be found within the unordered range or array of numbers numberlist.
- PERCENTRANK internally assigns a rank r to number, where 0 is the rank of the lowest number, 1 of the next lowest and so on. If number is not in numberlist, it is assigned a fractional rank proportionately between the rank of the numbers on either side (see the examples). Where N is the count of numbers in numberlist, PERCENTRANK returns r / (N-1), which is a fraction between 0 and 1 inclusive.
- This function is of limited use with a small list of numbers. It may be useful for example when determining where a score lies within all scores for a test, in which case the formula returned can be stated as L / (N-1), where L is the count of scores which are lower than number.
Example:
PERCENTRANK(A2:A99; A7)
- where cells A2:A99 contain scores from a test, returns the percent rank (as a fraction) for the student whose test score is in cell A7.
The next two examples illustrate the calculation, but have little practical application:
PERCENTRANK({3; 4; 9; 11; 12}; 4)
- returns 0.25.
PERCENTRANK({9; 3; 7; 8}; 6)
- returns 0.25. The lowest number 3 is assigned rank '0'; the next highest number 7 is assigned rank '1'. 6 is assigned a rank proportionately between these, rank '0.75'. There are 4 numbers in the list, so the result is calculated as 0.75/(4-1) = 0.75/3 = 0.25.
Issues:
- Despite its name, PERCENTRANK returns a fraction, not a percentage.
See Also
