Manuals/calci/PERCENTRANK

PERCENTRANK(ar,x)

• $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 $x$ is the value to find the rank.
• This function gives the result as error when array is empty .

Examples

1.

Spreadsheet

	A	B	C	D	E
1	3	4	1	2	1

=PERCENTRANK(A1:E1,2) = 0.5

2.

Spreadsheet

	A	B	C	D	E	F
1	7	6	2	5	9	1

=PERCENTRANK(A1:F1,3) = 0.267

Related Videos

PERCENTRANK

See Also

• MAX
• MIN
• MEDIAN
• QUARTILE
• PERCENTILE

References

Percentile Rank

List of Main Z Functions

Z3 home