writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + Line 7:
Line 7: + Line 13:
Line 14: − + Line 20:
Line 21: + Line 84:
Line 86: − + − +
Manuals/calci/DESCRIPTIVESTATISTICS (view source)
Revision as of 13:09, 22 February 2015
, 13:09, 22 February 2015→DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)
=DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)=
=DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag)=
where,
where,
*<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,
*<math>IsFirstRowLabels</math> is a logical value that determines if the first row has any label,
*<math>NewTableFlag</math> is a logical value that determines how the output should be displayed.
*<math>NewTableFlag</math> is a logical value that determines how the output should be displayed.
== Description ==
== Description ==
DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)
DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag)
*<math>Array</math> can be numbers or can be names, arrays or references containing numbers.
*<math>Array</math> can be numbers or can be names, arrays or references containing numbers.
*If <math>ConfidenceLevel</math> < '0' or <math>ConfidenceLevel</math> > '100', Calci displays an error message.
*If <math>ConfidenceLevel</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>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
*If <math>NewTableFlag</math> is TRUE, output is displayed on a new ZSpace cube. If <math>NewTableFlag</math> is FALSE, output is displayed on the same spreadsheet where command is written.
*If <math>NewTableFlag</math> is TRUE, output is displayed on a new ZSpace cube. If <math>NewTableFlag</math> is FALSE, output is displayed on the same spreadsheet where command is written.
</div>
</div>
=DESCRIPTIVESTATISTICS(A2:B5,"Columns",95,1,1,TRUE)
=DESCRIPTIVESTATISTICS(A2:B5,"Columns",95,1,1,FALSE,TRUE)
=DESCRIPTIVESTATISTICS(A2:B6,"Rows",95,2,1,TRUE)
=DESCRIPTIVESTATISTICS(A2:B6,"Rows",95,2,1,FALSE,TRUE)
----
----