Difference between revisions of "Manuals/calci/QUARTILE"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
3 - Third quartile(75th Percentile) | 3 - Third quartile(75th Percentile) | ||
4 - Maximum value | 4 - Maximum value | ||
| − | *The difference between the upper and lower quartiles is called the | + | *The difference between the upper and lower quartiles is called the inter-quartile range. |
| − | *When we are giving qu in a decimal value ,then it will change in to integer. | + | *When we are giving <math>qu</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. qu<0 or qu>4 | + | 2. <math>qu<0</math> or <math>qu>4</math> |
| − | 3. MIN,MEDIAN and MAX will give the same value as QUARTILE when qu 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. |
==Examples== | ==Examples== | ||
Revision as of 04:57, 7 January 2014
QUARTILE(ar,qu)
- 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 ar} 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 qu} 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(ar,qu)} , 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 ar} 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 qu} 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 qu} 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 qu<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 qu>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
- ar={2,3,7,9,15}
- QUARTILE(A1:A5,0)=2
- QUARTILE(A1:A5,1)=3
- ar={8,12,13,20,25,28,42}
- QUARTILE(B2:B8,3)=26.5
- QUARTILE(B2:B8,4)=42
- QUARTILE(B2:B8,5)=NAN