Difference between revisions of "Manuals/calci/DESCRIPTIVESTATISTICS"

Latest revision as of 02:31, 12 August 2020

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.

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 -

@@ Line 1: / Line 1: @@
-=DESCRIPTIVESTATISTICS (AreaArray, GroupBy, ConfidenceLevelPercentage, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag)=
+<div style="font-size:25px">'''DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,IsFirstRowLabels, NewTableFlag)'''</div><br/>
 where,
@@ Line 10: / Line 10: @@
 *<math>NewTableFlag</math> 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.
+DESCRIPTIVESTATISTICS(), calculates a range of statistical measurements and summarises them into a table.
 == Description ==
@@ Line 28: / Line 28: @@
 ==ZOS==
-*The syntax is to use this function in ZOS is <math>DESCRIPTIVESTATISTICS(AreaArray, GroupBy, ConfidenceLevelPercentage, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag)</math>
+*The syntax is to use this function in ZOS is <math> DESCRIPTIVESTATISTICS(AreaArray, GroupBy, ConfidenceLevelPercentage, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag) </math>
-*For e.g., descriptivestatistics([[8,7,11,7,33],[8,8,11,18,37]],"columns",95,1,1,false,true)
+*For e.g., DESCRIPTIVESTATISTICS([[8,7,11,7,33],[8,8,11,18,37]],"columns",95,1,1,false,true)
 == Examples ==