Manuals/calci/DESCRIPTIVESTATISTICS

DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,IsFirstRowLabels, NewTableFlag)

where,

$AreaArray$ is array of integers or reference to the cells containing array,
$GroupBy$ is a method that performs the analysis by Columns or Rows,
$ConfidenceLevelPercentage$ represents the confidence level for mean of data points and is between 0 to 100,
$KthLargest$ represents the Kth largest value for each range of data,
$KthSmallest$ represents the Kth smallest value for each range of data,
$IsFirstRowLabels$ is a logical value that determines if the first row has any label,
$NewTableFlag$ is a logical value that determines how the output should be displayed.

DESCRIPTIVESTATISTICS(), calculates a range of statistical measurements and summarises them into a table.

Description

DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest, IsFirstRowLabels,NewTableFlag)

$AreaArray$ can be numbers or can be names, arrays or references containing numbers.
Values containing text, logical values or empty cells are ignored.
Argument $GroupBy$ can be "Rows" or "Columns".
If $ConfidenceLevelPercentage$ < '0' or $ConfidenceLevel$ > '100', Calci displays an error message.
If $KthSmallest$ < '0' or $KthLargest$ > 'Length of array', Calci displays an error message.
$IsFirstRowLabels$ can be a logical value TRUE or FALSE.
$NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
If $NewTableFlag$ is TRUE, output is displayed on a new ZSpace cube. If $NewTableFlag$ is FALSE, output is displayed on the same spreadsheet where command is written.
If data is invalid, Calci displays NaN error message.

The syntax is to use this function in ZOS is $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)

Consider the following table with two arrays as input to DESCRIPTIVESTATISTICS() function -

=DESCRIPTIVESTATISTICS(A2:B6,"Columns",95,1,1,FALSE,TRUE)
=DESCRIPTIVESTATISTICS(A2:B6,"Rows",95,2,1,FALSE,TRUE)

DESCRIPTIVESTATISTICS() displays the respective output for above examples -