PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
The following article introduces you to PERCENTRANK.EXC - one of the functions in the group of statistical functions that is very popular in Excel.
Description: The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1. The function supports Excel 2010 and later versions.
Syntax: PERCENTRANK.EXC (array, x, [significance])
Inside:
- array: An array or range of data to determine percentile, which is a required parameter .
- x: The value you want to determine its rank in the dataset, is a required parameter.
- significance: The value determines the number of digits of the percentage value returned, which is an optional parameter, if omitted the default is 3 digits.
Attention:
- If array array value is empty -> the function returns the #NUM! Error value .
- If significance value <1 -> the function returns the #NUM! Error value .
- If x does not match any value of the array -> interpolation function to determine the rank of the value.
For example:
Find the rank of the values described in the data table below:
- Calculate the rank of the value 12 in the array. In the cell to calculate enter the formula : = PERCENTRANK.EXC (E6: K6, E7)
- Press Enter -> rank of value 12 in the dataset is:
- Calculate the rank of the value 4.25. In the cell to calculate, enter the formula: = PERCENTRANK.EXC (E6: K6, E8)
- Press Enter -> return value is:
Because the value 4.25 is a non-array value -> the function returns the # N / A error value
Above are instructions and some specific examples when using PERCENTRANK.EXC function in Excel.
Good luck!
You should read it
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
- QUARTILE function - The function returns the quartile of a dataset in Excel
- LARGE function - The function returns the kth largest value in a dataset in Excel
- KURT function - The function returns the sharp coefficient of a dataset in Excel
May be interested
- PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excelpercentrank.inc function: the function returns the rank of a value in a dataset as a percentage including values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.inc (array, x, [significance])
- PROB function - The function returns the probability that values in a range are between two limits in Excelprob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excelrank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
- Operations with blocks in Excelthe following article shows you how to manipulate blocks in excel. frequently used operations in spreadsheets when working with blocks: 1. select blocks of contiguous cells. place the mouse cursor in the first cell position of the block - hold the left mouse button dragging
- How to enter formula data in Excelshow you how to enter formula data in excel. working with excel you can not help but work with formulas and functions in excel. formula data input is a type of data entry through data that is available based on a calculation or 1
- How to name, comment and protect cells in Excelinstructions on how to name, note and protect cells in excel. 1. name the data cell. - normally, the data cell with the default name is the combination of the column and row order that makes up the cell. for example, cell b5 is named b5. - to change the name for a cell, do as follows: + click to select