Difference between revisions of "Manuals/calci/QUARTILE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''QUARTILE( | + | <div style="font-size:30px">'''QUARTILE(Array,Quartile)'''</div><br/> |
| − | *<math> | + | *<math>Array</math> is the array of numeric values |
| − | *<math> | + | *<math>Quartile</math> indicates the position of the quartile |
==Description== | ==Description== | ||
| Line 7: | Line 7: | ||
*Quartiles are the values that divide a list of numbers into quarters. | *Quartiles are the values that divide a list of numbers into quarters. | ||
*A quartile is a type of quantile. | *A quartile is a type of quantile. | ||
| − | *In <math> QUARTILE( | + | *In <math> QUARTILE(Array,Quartile)</math>, <math>Array</math> is the array of numeric values to find the Quartile and <math> Quartile</math> is the position of the quartile. |
'''qu value''' '''QUARTILE(result)''' | '''qu value''' '''QUARTILE(result)''' | ||
0 - Minimum value | 0 - Minimum value | ||
| Line 15: | Line 15: | ||
4 - Maximum value | 4 - Maximum value | ||
*The difference between the upper and lower quartiles is called the inter-quartile range. | *The difference between the upper and lower quartiles is called the inter-quartile range. | ||
| − | *When we are giving <math> | + | *When we are giving <math>Quartile</math> in a decimal value, then it will change in to integer. |
*This function will give the result as error when | *This function will give the result as error when | ||
1. The array is empty | 1. The array is empty | ||
| − | 2. <math> | + | 2. <math>Quartile<0</math> or <math>Quartile>4</math> |
3. MIN,MEDIAN and MAX will give the same value as QUARTILE when <math>qu</math> is 0,2,and 4 respectively. | 3. MIN,MEDIAN and MAX will give the same value as QUARTILE when <math>qu</math> is 0,2,and 4 respectively. | ||
Revision as of 14:20, 8 June 2018
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
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)} , 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.
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 qu}
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