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

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

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+<div style="font-size:25px">'''DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,IsFirstRowLabels, NewTableFlag)'''</div><br/>
-'''DESCRIPTIVESTATISTICS'''(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)
 where,
+*<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>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,
+*<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.
-'''Array '''- Input range should be one or more blocks.
+DESCRIPTIVESTATISTICS(), calculates a range of statistical measurements and summarises them into a table.
-'''GroupBy''' - Either groupby rows or columns.
+== Description ==
-'''ConfidenceLevel -''' represents the confidence level for mean and value should be in between 0 and 100.
+DESCRIPTIVESTATISTICS (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,
+IsFirstRowLabels,NewTableFlag)
-'''KthLargest -''' represents the kth largest value for each range of data.
+*<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>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.
+*<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 data is invalid, Calci displays NaN error message.
-'''KthSmallest''' - represents the kth smallest value for each range of data.
+==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)
-'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet.If NewTableFlag is omitted, it assumed to be FALSE.
+== Examples ==
-</div>
+Consider the following table with two arrays as input to DESCRIPTIVESTATISTICS() function -
-----
-<div id="1SpaceContent" class="zcontent" align="left">Calculates a range of statistical measurements and summarises them into a table. This table includes calculations for: Mean, Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosos, Skewness, Range, Minimum, Maximum, Sum, Count, Largest, Smallest and Confidence Level.</div>
-----
-<div id="7SpaceContent" class="zcontent" align="left">
-If ConfidenceLevel &gt;100 or ConfidenceLevel &lt; 0, returns the #ERROR.
+<div id="5SpaceContent" class="zcontent" align="left">
-DESCRIPTIVESTATISTICS returns the #ERROR,
-if KthLargest &gt; Length of Array or KthSmallest &lt; 0.
-</div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-DESCRIPTIVE STATISTICS
-</div></div>
-----
-<div id="8SpaceContent" class="zcontent" align="left">
-Lets see an example in (Column3, Row1)
-<nowiki>=DESCRIPTIVESTATISTICS(R1C1:R4C2, "Columns", 95, 1, 1, TRUE)</nowiki>
-It returns the result in new sheet(5Sapce).
-<nowiki>=DESCRIPTIVESTATISTICS(R1C1:R3C2,"Rows", 95, 2, 1, TRUE)</nowiki>
-It returns the result in new sheet(9space).
-</div>
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
-----
-<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
-----
-<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
-----
-<div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
@@ Line 65: / Line 41: @@
 | class=" " |
 | Column1
-| class="   " | Column2
+| Column2
-| class="   " | Column3
+| Column3
 | Column4
 |- class="odd"
 | class=" " | Row1
 | class=" " | 8
-| class="sshl_f" | 8
+| class=" " | 8
-| class="sshl_f" | 5Space
+| class="sshl_f" |
-| class="sshl_f" | 5
+| class="sshl_f" |
 |- class="even"
 | class="  " | Row2
 | class=" " | 7
-| class="    " | 8
+| class=" " | 8
-| class="   " | 9
+| class="   " |
-| class="sshl_f" | 128
+| class="sshl_f" |
 |- class="odd"
-| Row3
+| class=" " | Row3
-| class="sshl_f" | 11
+| class=" " | 11
-| class="sshl_f" | 11
+| class=" " | 11
-| 14
+| class=" " |
-| class="sshl_f    " | 15
+| class="sshl_f" |
 |- class="even"
-| Row4
+| class=" " | Row4
-| class="sshl_f" | 7
+| class=" " | 7
-| class="        SelectTD1 ChangeBGColor SelectTD1" |
+| class=" " | 18
-<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>18
+| class="sshl_f" |
-| class="sshl_f" | 10000
+| class="  " |
-| class="  " | 20
 |- class="odd"
 | class=" " | Row5
-| class="   " | 33
+| class=" " | 33
-| 37
+| class=" " | 37
-| 10023
+| class="sshl_f" |
-| 168
+| class="  " |
 |- class="even"
-| Row6
+| class=" " | Row6
-| class="sshl_f" | 9Space
+| class=" " |
-| class="sshl_f" | 2
+| class=" " |
-| 1.619775
+| class="sshl_f" |
-| 0.525322
+| class="  " |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+</div>
+ =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 -
 <div id="5SpaceContent" class="zcontent" align="left">
@@ Line 118: / Line 106: @@
 |- class="odd"
 | Mean
-| 8.25
+| 13.2
-|- class="even"
-| Standard Deviation
-| 1.8929694486000912
-|- class="odd"
-| Count
-| 4
 |- class="even"
 | Standard Error
-| 0.9464847243000456
+| 5.0039984012787215
 |- class="odd"
 | Median
-| 7.5
+| 8
 |- class="even"
 | Mode
 | 7
 |- class="odd"
+| Standard Deviation
+| 11.189280584559492
+|- class="even"
 | Sample Variance
-| 3.5833333333333335
+| 125.20000000000002
+|- class="odd"
+| Kurtosis
+| 4.552218048566379
 |- class="even"
-| Kurtosis
+| Skewness
-| 2.615467820443488
+| 2.121996141236003
 |- class="odd"
-| Skewness
+| Range
-| 1.6585238002878033
+| 26
 |- class="even"
 | Minimum
@@ Line 148: / Line 136: @@
 |- class="odd"
 | Maximum
-| 11
+| 33
 |- class="even"
-| Range
+| Sum
-| 4
+| 66
 |- class="odd"
-| Sum
+| Count
-| 33
+| 5
 |- class="even"
 | Confidence Level 95%
-| 1.5060697372158713
+| 13.8933265079393
 |- class="odd"
 | Largest(1)
-| 11
+| 33
 |- class="even"
 | Smallest(1)
@@ Line 173: / Line 161: @@
 |- class="odd"
 | Mean
-| 11.25
+| 16.4
-|- class="even"
-| Standard Deviation
-| 4.716990566028302
-|- class="odd"
-| Count
-| 4
 |- class="even"
 | Standard Error
-| 2.358495283014151
+| 5.4644304369257
 |- class="odd"
 | Median
-| 9.5
+| 11
 |- class="even"
 | Mode
 | 8
 |- class="odd"
+| Standard Deviation
+| 12.218837915284743
+|- class="even"
 | Sample Variance
-| 22.249999999999996
+| 149.3
+|- class="odd"
+| Kurtosis
+| 2.704996615148442
 |- class="even"
-| Kurtosis
+| Skewness
-| 1.9800530236081304
+| 1.6908658101947216
 |- class="odd"
-| Skewness
+| Range
-| 1.5173452799192164
+| 29
 |- class="even"
 | Minimum
@@ Line 203: / Line 191: @@
 |- class="odd"
 | Maximum
-| 18
+| 37
 |- class="even"
-| Range
+| Sum
-| 10
+| 82
 |- class="odd"
-| Sum
+| Count
-| 45
+| 5
 |- class="even"
 | Confidence Level 95%
-| 3.752895614602602
+| 15.171690746489805
 |- class="odd"
 | Largest(1)
-| 18
+| 37
 |- class="even"
 | Smallest(1)
@@ Line 223: / Line 211: @@
 </div>
 ----
 <div id="9SpaceContent" class="zcontent" align="left">
@@ Line 233: / Line 222: @@
 | Mean
 | 8
-|- class="even"
-| Standard Deviation
-| 0
-|- class="odd"
-| Count
-| 2
 |- class="even"
 | Standard Error
@@ Line 249: / Line 232: @@
 | 8
 |- class="odd"
+| Standard Deviation
+| 0
+|- class="even"
 | Sample Variance
 | 0
-|- class="even"
+|- class="odd"
 | Kurtosis
 | NaN
-|- class="odd"
+|- class="even"
 | Skewness
 | NaN
+|- class="odd"
+| Range
+| 0
 |- class="even"
 | Minimum
@@ Line 264: / Line 253: @@
 | 8
 |- class="even"
-| Range
-| 0
-|- class="odd"
 | Sum
 | 16
+|- class="odd"
+| Count
+| 2
 |- class="even"
 | Confidence Level 95%
@@ Line 288: / Line 277: @@
 | Mean
 | 7.5
-|- class="even"
-| Standard Deviation
-| 0.7071067811865476
-|- class="odd"
-| Count
-| 2
 |- class="even"
 | Standard Error
@@ Line 304: / Line 287: @@
 | #ERROR
 |- class="odd"
+| Standard Deviation
+| 0.7071067811865476
+|- class="even"
 | Sample Variance
 | 0.5000000000000001
-|- class="even"
+|- class="odd"
 | Kurtosis
 | NaN
-|- class="odd"
+|- class="even"
 | Skewness
 | NaN
+|- class="odd"
+| Range
+| 1
 |- class="even"
 | Minimum
@@ Line 319: / Line 308: @@
 | 8
 |- class="even"
-| Range
-| 1
-|- class="odd"
 | Sum
 | 15
+|- class="odd"
+| Count
+| 2
 |- class="even"
 | Confidence Level 95%
-| 4.492321766046884
+| 6.353102368087358
 |- class="odd"
 | Largest(2)
@@ Line 343: / Line 332: @@
 | Mean
 | 11
-|- class="even"
-| Standard Deviation
-| 0
-|- class="odd"
-| Count
-| 2
 |- class="even"
 | Standard Error
@@ Line 359: / Line 342: @@
 | 11
 |- class="odd"
+| Standard Deviation
+| 0
+|- class="even"
 | Sample Variance
 | 0
-|- class="even"
+|- class="odd"
 | Kurtosis
 | NaN
-|- class="odd"
+|- class="even"
 | Skewness
 | NaN
+|- class="odd"
+| Range
+| 0
 |- class="even"
 | Minimum
@@ Line 374: / Line 363: @@
 | 11
 |- class="even"
-| Range
-| 0
-|- class="odd"
 | Sum
 | 22
+|- class="odd"
+| Count
+| 2
 |- class="even"
 | Confidence Level 95%
@@ Line 390: / Line 379: @@
 |}
+{| class="SpreadSheet blue"
+|+ <br />Descriptive Statistics
+|- class="even"
+! Row 4
+!
+|- class="odd"
+| Mean
+| 12.5
+|- class="even"
+| Standard Error
+| 5.499999999999999
+|- class="odd"
+| Median
+| 12.5
+|- class="even"
+| Mode
+| #ERROR
+|- class="odd"
+| Standard Deviation
+| 7.7781745930520225
+|- class="even"
+| Sample Variance
+| 60.49999999999999
+|- class="odd"
+| Kurtosis
+| NaN
+|- class="even"
+| Skewness
+| NaN
+|- class="odd"
+| Range
+| 11
+|- class="even"
+| Minimum
+| 7
+|- class="odd"
+| Maximum
+| 18
+|- class="even"
+| Sum
+| 25
+|- class="odd"
+| Count
+| 2
+|- class="even"
+| Confidence Level 95%
+| 69.88412604896092
+|- class="odd"
+| Largest(2)
+| 7
+|- class="even"
+| Smallest(1)
+| 7
+|}
+{| class="SpreadSheet blue"
+|+ <br />Descriptive Statistics
+|- class="even"
+! Row 5
+!
+|- class="odd"
+| Mean
+| 35
+|- class="even"
+| Standard Error
+| 2
+|- class="odd"
+| Median
+| 35
+|- class="even"
+| Mode
+| #ERROR
+|- class="odd"
+| Standard Deviation
+| 2.8284271247461903
+|- class="even"
+| Sample Variance
+| 8.000000000000002
+|- class="odd"
+| Kurtosis
+| NaN
+|- class="even"
+| Skewness
+| NaN
+|- class="odd"
+| Range
+| 4
+|- class="even"
+| Minimum
+| 33
+|- class="odd"
+| Maximum
+| 37
+|- class="even"
+| Sum
+| 70
+|- class="odd"
+| Count
+| 2
+|- class="even"
+| Confidence Level 95%
+| 25.41240947234943
+|- class="odd"
+| Largest(2)
+| 33
+|- class="even"
+| Smallest(1)
+| 33
+|}
 </div>
-----
+==Related Videos==
+{{#ev:youtube|eLyLbaXfJXo|280|center|DESCRIPTIVE STATISTICS}}
+== See Also ==
+*[[Manuals/calci/STATS | STATS]]
+*[[Manuals/calci/COVAR | COVAR]]
+*[[Manuals/calci/COVARIANCE | COVARIANCE]]
+== References ==
+*[http://en.wikipedia.org/wiki/Descriptive_statistics Descriptive Statistics]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]