Table of Contents
The PERCENTRANK.INC function in Google Sheets allows users to determine the rank of a given value in a data set based on its percentile. This function calculates the percentage of values in the data set that are equal to or less than the given value, and then converts it to a rank based on the data set’s total number of values. This feature is useful for analyzing data and understanding the distribution of values within a data set. By using the PERCENTRANK.INC function, users can easily determine the relative position of a specific value within a data set and make informed decisions based on its percentile.
PERCENTRANK.INC
Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
Sample Usage
PERCENTRANK.INC(A1:A100, A2, 4)
PERCENTRANK.INC(A1:A100, 10)
Syntax
PERCENTRANK.INC(data, value, [significant_digits])
data– The array or range containing the dataset to consider.value– The value whose percentage rank will be determined.significant_digits– [ OPTIONAL –3by default ] – The number of significant figures to use in the calculation.
Notes
- If the
valuedoes not fall within thedatagiven for the function, an estimation will be made to bring up a percentage rank for that value.
See Also
PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a dataset.
PERCENTRANK.EXC: Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.
PERCENTILE: Returns the value at a given percentile of a dataset.
MIN: Returns the minimum value in a numeric dataset.
MAX: Returns the maximum value in a numeric dataset.
MEDIAN: Returns the median value in a numeric dataset.
PERCENTILE: Returns the value at a given percentile of a dataset.
Cite this article
stats writer (2024). How can I use the PERCENTRANK.INC function in Google Sheets to calculate the rank of a given value in a data set based on its percentile?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-percentrank-inc-function-in-google-sheets-to-calculate-the-rank-of-a-given-value-in-a-data-set-based-on-its-percentile/
stats writer. "How can I use the PERCENTRANK.INC function in Google Sheets to calculate the rank of a given value in a data set based on its percentile?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-percentrank-inc-function-in-google-sheets-to-calculate-the-rank-of-a-given-value-in-a-data-set-based-on-its-percentile/.
stats writer. "How can I use the PERCENTRANK.INC function in Google Sheets to calculate the rank of a given value in a data set based on its percentile?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-percentrank-inc-function-in-google-sheets-to-calculate-the-rank-of-a-given-value-in-a-data-set-based-on-its-percentile/.
stats writer (2024) 'How can I use the PERCENTRANK.INC function in Google Sheets to calculate the rank of a given value in a data set based on its percentile?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-percentrank-inc-function-in-google-sheets-to-calculate-the-rank-of-a-given-value-in-a-data-set-based-on-its-percentile/.
[1] stats writer, "How can I use the PERCENTRANK.INC function in Google Sheets to calculate the rank of a given value in a data set based on its percentile?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the PERCENTRANK.INC function in Google Sheets to calculate the rank of a given value in a data set based on its percentile?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.