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)

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 < '0' or > 'Length of array', Calci displays an error message.
can be a logical value TRUE or FALSE.
can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
If is TRUE, output is displayed on a new ZSpace cube. If 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
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 -