writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + Line 14:
Line 14: − + − + − + Line 27:
Line 27: − +
Manuals/calci/DESCRIPTIVESTATISTICS (view source)
Revision as of 17:39, 6 June 2018
, 17:39, 6 June 2018no edit summary
=DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag)=
=DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,IsFirstRowLabels,NewTableFlag)=
where,
where,
*<math>Array</math> is array of integers or reference to the cells containing array,
*<math>AreaArray</math> is array of integers or reference to the cells containing array,
*<math>GroupBy</math> is a method that performs the analysis by Columns or Rows,
*<math>GroupBy</math> is a method that performs the analysis by Columns or Rows,
*<math>ConfidenceLevel</math> represents the confidence level for mean of data points and is between 0 to 100,
*<math>ConfidenceLevelPercentage</math> represents the confidence level for mean of data points and is between 0 to 100,
*<math>KthLargest</math> represents the Kth largest value for each range of data,
*<math>KthLargest</math> represents the Kth largest value for each range of data,
*<math>KthSmallest</math> represents the Kth smallest value for each range of data,
*<math>KthSmallest</math> represents the Kth smallest value for each range of data,
== Description ==
== Description ==
DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag)
DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,IsFirstRowLabels,NewTableFlag)
*<math>Array</math> can be numbers or can be names, arrays or references containing numbers.
*<math>AreaArray</math> can be numbers or can be names, arrays or references containing numbers.
*Values containing text, logical values or empty cells are ignored.
*Values containing text, logical values or empty cells are ignored.
*Argument <math>GroupBy</math> can be "Rows" or "Columns".
*Argument <math>GroupBy</math> can be "Rows" or "Columns".
*If <math>ConfidenceLevel</math> < '0' or <math>ConfidenceLevel</math> > '100', Calci displays an error message.
*If <math>ConfidenceLevelPercentage</math> < '0' or <math>ConfidenceLevel</math> > '100', Calci displays an error message.
*If <math>KthSmallest</math> < '0' or <math>KthLargest</math> > 'Length of array', Calci displays an error message.
*If <math>KthSmallest</math> < '0' or <math>KthLargest</math> > 'Length of array', Calci displays an error message.
*<math>IsFirstRowLabels</math> can be a logical value TRUE or FALSE.
*<math>IsFirstRowLabels</math> can be a logical value TRUE or FALSE.
==ZOS==
==ZOS==
*The syntax is to use this function in ZOS is <math>DESCRIPTIVESTATISTICS(Array,GroupBy,ConfidenceLevelInPercentage,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)