Difference between revisions of "Manuals/calci/PERCENTRANK"
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''PERCENTRANK( | + | <div style="font-size:30px">'''PERCENTRANK (Array,Number,Significance) '''</div><br/> |
| − | *<math> | + | *<math>Array</math> is the set of data and <math> Number</math> is the value to find the rank. |
| + | **PERCENTRANK(),returns the percentage rank of a value in a data set. | ||
==Description== | ==Description== | ||
| Line 12: | Line 13: | ||
<math>S</math> = Number of same rank, | <math>S</math> = Number of same rank, | ||
<math>N</math> = Total numbers. | <math>N</math> = Total numbers. | ||
| − | *In <math>PERCENTRANK( | + | *In <math>PERCENTRANK (Array,Number,Significance)</math>, <math>Array</math> is the array of numeric values and <math>Number</math> is the value to find the rank. |
*This function gives the result as error when array is empty . | *This function gives the result as error when array is empty . | ||
| Line 51: | Line 52: | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Percentile_rank Percentile Rank ] | [http://en.wikipedia.org/wiki/Percentile_rank Percentile Rank ] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 15:56, 8 August 2018
PERCENTRANK (Array,Number,Significance)
- 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 Array}
is the set of 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 Number}
is the value to find the rank.
- PERCENTRANK(),returns the percentage rank of a value in a data set.
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, = 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 (Array,Number,Significance)} , 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 Array} 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 Number} 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:F1,3) = 0.267
Related Videos
See Also
References