Manuals/calci/QUARTILE

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 (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\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

Spreadsheet

	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

QUARTILE

See Also

• MAX
• MIN
• MEDIAN
• PERCENTILE

References

• Quartile

• List of Main Z Functions

• Z3 home