Revision as of 06:16, 22 January 2014

DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)

where,

$Array$ is array of integers or reference to the cells containing array,
$GroupBy$ is a method that performs the analysis by Columns or Rows,
$ConfidenceLevel$ 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,
$NewTableFlag$ is a logical value that determines how the output should be displayed.

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

$Array$ 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 $ConfidenceLevel$ < '0' or $ConfidenceLevel$ > '100', Calci displays an error message.
If $KthSmallest$ < '0' or $KthLargest$ > 'Length of array', Calci displays an error message.
$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.

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

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

DESCRIPTIVESTATISTICS() displays the respective output for above examples -

@@ Line 205: / Line 205: @@
 </div>
 ----
 <div id="9SpaceContent" class="zcontent" align="left">