Manuals/calci/QUARTILE
Jump to navigation
Jump to search
QUARTILE(Array,Quartile)
- 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 Array} is the array of numeric values
- 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 Quartile}
indicates the position of the quartile
- QUARTILE(), returns the quartile of a data set.
Description
- This function gives the value of quartile for a given set.
- Quartiles are the values that divide a list of numbers into quarters.
- A quartile is a type of quantile.
- 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 QUARTILE(Array,Quartile)} , 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 Array} is the array of numeric values to find the Quartile 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 Quartile} is the position of the quartile.
qu value QUARTILE(result) 0 - Minimum value 1 - First quartile(25th Percentile) 2 - Median value(50th Percentile) 3 - Third quartile(75th Percentile) 4 - Maximum value
- The difference between the upper and lower quartiles is called the inter-quartile range.
- When we are giving 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 Quartile} in a decimal value, then it will change in to integer.
- This function will give the result as error when
1. The array is empty
2. 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 Quartile<0}
or 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 Quartile>4}
3. MIN,MEDIAN and MAX will give the same value as QUARTILE when 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 Quartile}
is 0,2,and 4 respectively.
Examples
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 2 | 3 | 7 | 9 | 15 |
| 2 | 8 | 12 | 13 | 20 | 25 |
| 3 | 14 | 3 | 9 | 6 | 15 |
| 4 | 12 | 23 | 1 | 42 | 17 |
| 5 |
- =QUARTILE(A1:A4,0) = 2
- =QUARTILE(A1:A4,1) = 6.5
- =QUARTILE(B2:E3,3) = 16.25
- =QUARTILE(A2:B3,3) = 12.5
- =QUARTILE(A5:E5,3) = NAN
Related Videos
See Also
References