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.

Description

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.

ZOS

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)

Examples

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

	Column1	Column2	Column3	Column4
Row1	8	8
Row2	7	8
Row3	11	11
Row4	7	18
Row5	33	37
Row6

=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 -

Descriptive Statistics
Column 1
Mean	13.2
Standard Error	5.0039984012787215
Median	8
Mode	7
Standard Deviation	11.189280584559492
Sample Variance	125.20000000000002
Kurtosis	4.552218048566379
Skewness	2.121996141236003
Range	26
Minimum	7
Maximum	33
Sum	66
Count	5
Confidence Level 95%	13.8933265079393
Largest(1)	33
Smallest(1)	7

Descriptive Statistics
Column 2
Mean	16.4
Standard Error	5.4644304369257
Median	11
Mode	8
Standard Deviation	12.218837915284743
Sample Variance	149.3
Kurtosis	2.704996615148442
Skewness	1.6908658101947216
Range	29
Minimum	8
Maximum	37
Sum	82
Count	5
Confidence Level 95%	15.171690746489805
Largest(1)	37
Smallest(1)	8

Descriptive Statistics
Row 1
Mean	8
Standard Error	0
Median	8
Mode	8
Standard Deviation	0
Sample Variance	0
Kurtosis	NaN
Skewness	NaN
Range	0
Minimum	8
Maximum	8
Sum	16
Count	2
Confidence Level 95%	0
Largest(2)	8
Smallest(1)	8

Descriptive Statistics
Row 2
Mean	7.5
Standard Error	0.5
Median	7.5
Mode	#ERROR
Standard Deviation	0.7071067811865476
Sample Variance	0.5000000000000001
Kurtosis	NaN
Skewness	NaN
Range	1
Minimum	7
Maximum	8
Sum	15
Count	2
Confidence Level 95%	6.353102368087358
Largest(2)	7
Smallest(1)	7

Descriptive Statistics
Row 3
Mean	11
Standard Error	0
Median	11
Mode	11
Standard Deviation	0
Sample Variance	0
Kurtosis	NaN
Skewness	NaN
Range	0
Minimum	11
Maximum	11
Sum	22
Count	2
Confidence Level 95%	0
Largest(2)	11
Smallest(1)	11

Descriptive Statistics
Row 4
Mean	12.5
Standard Error	5.499999999999999
Median	12.5
Mode	#ERROR
Standard Deviation	7.7781745930520225
Sample Variance	60.49999999999999
Kurtosis	NaN
Skewness	NaN
Range	11
Minimum	7
Maximum	18
Sum	25
Count	2
Confidence Level 95%	69.88412604896092
Largest(2)	7
Smallest(1)	7

Descriptive Statistics
Row 5
Mean	35
Standard Error	2
Median	35
Mode	#ERROR
Standard Deviation	2.8284271247461903
Sample Variance	8.000000000000002
Kurtosis	NaN
Skewness	NaN
Range	4
Minimum	33
Maximum	37
Sum	70
Count	2
Confidence Level 95%	25.41240947234943
Largest(2)	33
Smallest(1)	33

References

Descriptive Statistics

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-=DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag)=
+<div style="font-size:25px">'''DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,IsFirstRowLabels, NewTableFlag)'''</div><br/>
 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>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>KthSmallest</math> represents the Kth smallest value for each range of data,
@@ 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 ==
-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.
 *Argument <math>GroupBy</math> can be "Rows" or "Columns".
-*If <math>ConfidenceLevel</math> &lt; '0' or <math>ConfidenceLevel</math> &gt; '100', Calci displays an error message.
+*If <math>ConfidenceLevelPercentage</math> &lt; '0' or <math>ConfidenceLevel</math> &gt; '100', Calci displays an error message.
 *If <math>KthSmallest</math> &lt; '0' or <math>KthLargest</math> &gt; 'Length of array', Calci displays an error message.
 *<math>IsFirstRowLabels</math> can be a logical value TRUE or FALSE.
@@ Line 26: / Line 27: @@
 *If data is invalid, Calci displays NaN error message.
+==ZOS==
+*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)
 == Examples ==
@@ Line 86: / Line 90: @@
 </div>
-  =DESCRIPTIVESTATISTICS(A2:B5,"Columns",95,1,1,FALSE,TRUE)
+  =DESCRIPTIVESTATISTICS(A2:B6,"Columns",95,1,1,FALSE,TRUE)
   =DESCRIPTIVESTATISTICS(A2:B6,"Rows",95,2,1,FALSE,TRUE)
@@ Line 102: / Line 106: @@
 |- class="odd"
 | Mean
-| 8.25
+| 13.2
 |- class="even"
 | Standard Error
-| 0.9464847243000456
+| 5.0039984012787215
 |- class="odd"
 | Median
-| 7.5
+| 8
 |- class="even"
 | Mode
@@ Line 114: / Line 118: @@
 |- class="odd"
 | Standard Deviation
-| 1.8929694486000912
+| 11.189280584559492
 |- class="even"
 | Sample Variance
-| 3.5833333333333335
+| 125.20000000000002
 |- class="odd"
 | Kurtosis
-| 2.6154678204434845
+| 4.552218048566379
 |- class="even"
 | Skewness
-| 1.6585238002878033
+| 2.121996141236003
 |- class="odd"
 | Range
-| 4
+| 26
 |- class="even"
 | Minimum
@@ Line 132: / Line 136: @@
 |- class="odd"
 | Maximum
-| 11
+| 33
 |- class="even"
 | Sum
-| 33
+| 66
 |- class="odd"
 | Count
-| 4
+| 5
 |- class="even"
 | Confidence Level 95%
-| 3.0121394744317427
+| 13.8933265079393
 |- class="odd"
 | Largest(1)
-| 11
+| 33
 |- class="even"
 | Smallest(1)
@@ Line 157: / Line 161: @@
 |- class="odd"
 | Mean
-| 11.25
+| 16.4
 |- class="even"
 | Standard Error
-| 2.358495283014151
+| 5.4644304369257
 |- class="odd"
 | Median
-| 9.5
+| 11
 |- class="even"
 | Mode
@@ Line 169: / Line 173: @@
 |- class="odd"
 | Standard Deviation
-| 4.716990566028302
+| 12.218837915284743
 |- class="even"
 | Sample Variance
-| 22.249999999999996
+| 149.3
 |- class="odd"
 | Kurtosis
-| 1.9800530236081304
+| 2.704996615148442
 |- class="even"
 | Skewness
-| 1.517345279919216
+| 1.6908658101947216
 |- class="odd"
 | Range
-| 10
+| 29
 |- class="even"
 | Minimum
@@ Line 187: / Line 191: @@
 |- class="odd"
 | Maximum
-| 18
+| 37
 |- class="even"
 | Sum
-| 45
+| 82
 |- class="odd"
 | Count
-| 4
+| 5
 |- class="even"
 | Confidence Level 95%
-| 7.505791229205204
+| 15.171690746489805
 |- class="odd"
 | Largest(1)
-| 18
+| 37
 |- class="even"
 | Smallest(1)
@@ Line 485: / Line 489: @@
 |}
 </div>
+==Related Videos==
+{{#ev:youtube|eLyLbaXfJXo|280|center|DESCRIPTIVE STATISTICS}}
 == See Also ==
+*[[Manuals/calci/STATS | STATS]]
 *[[Manuals/calci/COVAR | COVAR]]
 *[[Manuals/calci/COVARIANCE | COVARIANCE]]
@@ Line 493: / Line 503: @@
 *[http://en.wikipedia.org/wiki/Descriptive_statistics Descriptive Statistics]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/DESCRIPTIVESTATISTICS"

Latest revision as of 02:31, 12 August 2020

Contents

Description

ZOS

Examples

Related Videos

See Also

References

Navigation menu

Search