QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
The following article introduces you to the QUARTILE.INC function - one of the functions in the group of statistical functions that is very popular in Excel.
Description: The function returns the quartile of a dataset, with percentile values from 0 to 1 including 0 and 1. Functions supported from Execl 2010 onwards.
Syntax: QUARTILE.INC (array, quart)
Inside:
- array: An array or range containing values that want to find quartiles, a required parameter .
- quart: The position of the quartile to be returned, is the required parameter including the following values:
+ quart = 0 -> function returns the minimum value.
+ quart = 1 -> function returns the first quartile (25th percentile).
+ quart = 2 -> function returns the median value (50th percentile).
+ quart = 3 -> function returns the 3rd quartile (75th percentile).
+ quart = 4 -> function returns the maximum value.
Attention:
- If quart is not an integer -> it is truncated to an integer.
- If array is empty -> the function returns the #NUM! Error value .
- If quart > 4 or quart <0 -> the function returns the #NUM! Error value
- The MIN and MAX, MEDIAN functions return the same value as the QUARTILE.INC function with corresponding values quart = 0, quart = 4, quart = 2.
For example:
Locate the units as described in the following data table:
- Determine the position of the 1st percentile. In the cell to calculate enter the formula : = QUARTILE.INC (D6: J6, D7)
- Press Enter -> 1st percentile is:
- The fourth percentile. In the cell to calculate enter the formula: = QUARTILE.INC (D6: J6, D8). Press Enter -> return value is:
- In case the value of quart = 0 -> the function still calculates normally.
- Where the quart value = 6> 4 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using QUARTILE.INC function in Excel.
Good luck!
You should read it
- PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
- PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
- How to Calculate Quartiles in Excel
- LARGE function - The function returns the kth largest value in a dataset in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
- KURT function - The function returns the sharp coefficient of a dataset in Excel
- MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
- MODE.MULT function - The function returns a vertical array of the most common values in Excel
May be interested
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excelrank.avg 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 average rank. support functions from execl 2010 version and above
- RSQ - The function returns the square of the Pearson torque correlation coefficient in Excelrsq: the function returns the square of the pearson moment correlation coefficient through data points in known_ys and known_xs. syntax: rsq (known_ys, known_xs)
- SKEW function - The function returns the deviation of the distribution in Excelskew function: the function returns the deviation of the distribution - the deviation represents the asymmetry of the distribution around its axis. - negative deviations: the distribution with the asymmetric side extends more to the negative value. - positive deviation: the distribution with the asymmetric side extends much to g
- SLOPE function - The function returns the slope of a linear regression line through data points in Excelslope function: the function returns the slope of a linear regression line through data points. the slope is the vertical distance divided by the horizontal distance between any two points on that line, the rate of change along the regression line. syntax: slope (known_ys, known_xs)
- 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)
- STANDARDIZE function - The function returns the normalized value from a specific distribution in Excelstandardize function: the function returns the normalized value from a distribution characterized by mean and standard_dev arguments. syntax: standardize (x, mean, standard_dev)