can be numbers or can be names, arrays or references containing numbers.
Values containing text, logical values or empty cells are ignored.
Argument can be "Rows" or "Columns".
If < '0' or > '100', Calci displays an error message.
If 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 KthSmallest}
< '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 KthLargest}
> 'Length of array', Calci displays an error message.
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 IsFirstRowLabels}
can be a logical value TRUE or FALSE.
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 NewTableFlag}
can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
If 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 NewTableFlag}
is TRUE, output is displayed on a new ZSpace cube. If 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 NewTableFlag}
is FALSE, output is displayed on the same spreadsheet where command is written.
If data is invalid, Calci displays NaN error message.
ZOS
The syntax is to use this function in ZOS is 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 DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest, IsFirstRowLabels,NewTableFlag)}
For e.g., descriptivestatistics([[8,7,11,7,33],[8,8,11,18,37]],"columns",95,1,1,false,true)
Examples
Consider the following table with two arrays as input to DESCRIPTIVESTATISTICS() function -
