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
- MODE.MULT function - The function returns a vertical array of the most common values in Excelmode.mult function: the function returns a vertical array of the most frequently occurring values, or repeating values in an array or data range. support functions from excel 2010 onwards. syntax: mode.mult ((number1, [number2], ...)
- How to rank on Excel with RANK functionto rank on excel we will use the rank function. you can rank in ascending or descending order according to your needs.
- SMALL function - The function returns the kth smallest value in a dataset in Excelsmall function: the function returns the kth smallest value in a dataset. syntax: small (array, k)
- The use of the RANK function in excelthe rank function is a relatively common function and is widely used in the office world, and especially by accountants. so, what's the rank function for?
- MAX function - The function returns the largest value in a set of values in Excelmax function: the function returns the largest value in the set of values. syntax: max (number1, [number2], ...)
- STDEV.P function - The function returns the standard deviation based on the whole in Excelstdev.p: the function returns the standard deviation based on the whole population, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.p (number1, [number2] ,.
- How to calculate the percentage change in Pivot Table in Excelalthough the main function of a pivottable is to summarize large data, you can use them to calculate the percentage change between values.
- RANK function - Rank function in Excel - Usage and examplesthe rank function arranges equal numbers of the same rank. however, the duplication will affect the ranking of subsequent numbers. for example, you have the sequence number: 1,2,2,3,4 and are arranged in ascending order, so the order of the number 1 in the series is 5.
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excelfrequency function: function that calculates and returns the frequency of occurrences of values within a certain range and returns a vertical number array. syntax: frequency (data_array, bins_array)
- How to use the RANK function in Excelthe rank function in excel is a function used by many people in data processing. for accountants, the rank function is very popular.