Difference between revisions of "Manuals/calci/PERCENTRANK"
| Line 20: | Line 20: | ||
|+Spreadsheet | |+Spreadsheet | ||
|- | |- | ||
| − | ! !! A !! B !! C !! D | + | ! !! A !! B !! C !! D !! E |
|- | |- | ||
! 1 | ! 1 | ||
| 3 || 4 || 1 || 2 ||1 | | 3 || 4 || 1 || 2 ||1 | ||
|} | |} | ||
| − | =PERCENTRANK(A1: | + | =PERCENTRANK(A1:E1,2) = 0.5 |
2. | 2. | ||
| Line 36: | Line 36: | ||
| 7 || 6 || 2 || 5 || 9 ||1 | | 7 || 6 || 2 || 5 || 9 ||1 | ||
|} | |} | ||
| − | =PERCENTRANK( | + | =PERCENTRANK(A1:F6,3) = 0.267 |
==Related Videos== | ==Related Videos== | ||
Revision as of 02:57, 6 October 2015
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar} is the array data and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } is the value
Description
- This function gives the percentage rank of a value in a given set of numbers.
- To calculate the relative standing of a data set we can use this function.
- For example, a test score that is greater than or equal to 50% of the scores of people taking the test is said to be at the 50th percentile rank.
- Percentile ranks are commonly used to clarify the interpretation of scores on standardized tests.
- To find the percentile rank of a score is :Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PR \%= \frac {L+( 0.5*S )}{N}}
Where, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle L} = Number of below rank, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle S} = Number of same rank, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle N} = Total numbers.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PERCENTRANK(ar,x)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar} is the array of numeric values and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x} is the value to find the rank.
- This function gives the result as error when array is empty .
Examples
1.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 3 | 4 | 1 | 2 | 1 |
=PERCENTRANK(A1:E1,2) = 0.5
2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | 7 | 6 | 2 | 5 | 9 | 1 |
=PERCENTRANK(A1:F6,3) = 0.267