Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Manuals/calci/DESCRIPTIVESTATISTICS (view source)
Revision as of 02:33, 25 October 2013
, 02:33, 25 October 2013Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''DESCRIPTIVESTATISTICS'''(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag) where, ''..."
<div id="6SpaceContent" class="zcontent" align="left">
'''DESCRIPTIVESTATISTICS'''(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)
where,
'''Array '''- Input range should be one or more blocks.
'''GroupBy''' - Either groupby rows or columns.
'''ConfidenceLevel -''' represents the confidence level for mean and value should be in between 0 and 100.
'''KthLargest -''' represents the kth largest value for each range of data.
'''KthSmallest''' - represents the kth smallest value for each range of data.
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet.If NewTableFlag is omitted, it assumed to be FALSE.
</div>
----
<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 >100 or ConfidenceLevel < 0, returns the #ERROR.
DESCRIPTIVESTATISTICS returns the #ERROR,
if KthLargest > Length of Array or KthSmallest < 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"
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| class=" " | Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 8
| class="sshl_f" | 8
| class="sshl_f" | 5Space
| class="sshl_f" | 5
|- class="even"
| class=" " | Row2
| class=" " | 7
| class=" " | 8
| class=" " | 9
| class="sshl_f" | 128
|- class="odd"
| Row3
| class="sshl_f" | 11
| class="sshl_f" | 11
| 14
| class="sshl_f " | 15
|- class="even"
| Row4
| class="sshl_f" | 7
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<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" | 10000
| class=" " | 20
|- class="odd"
| class=" " | Row5
| class=" " | 33
| 37
| 10023
| 168
|- class="even"
| Row6
| class="sshl_f" | 9Space
| class="sshl_f" | 2
| 1.619775
| 0.525322
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Column 1
!
|- class="odd"
| Mean
| 8.25
|- class="even"
| Standard Deviation
| 1.8929694486000912
|- class="odd"
| Count
| 4
|- class="even"
| Standard Error
| 0.9464847243000456
|- class="odd"
| Median
| 7.5
|- class="even"
| Mode
| 7
|- class="odd"
| Sample Variance
| 3.5833333333333335
|- class="even"
| Kurtosis
| 2.615467820443488
|- class="odd"
| Skewness
| 1.6585238002878033
|- class="even"
| Minimum
| 7
|- class="odd"
| Maximum
| 11
|- class="even"
| Range
| 4
|- class="odd"
| Sum
| 33
|- class="even"
| Confidence Level 95%
| 1.5060697372158713
|- class="odd"
| Largest(1)
| 11
|- class="even"
| Smallest(1)
| 7
|}
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Column 2
!
|- class="odd"
| Mean
| 11.25
|- class="even"
| Standard Deviation
| 4.716990566028302
|- class="odd"
| Count
| 4
|- class="even"
| Standard Error
| 2.358495283014151
|- class="odd"
| Median
| 9.5
|- class="even"
| Mode
| 8
|- class="odd"
| Sample Variance
| 22.249999999999996
|- class="even"
| Kurtosis
| 1.9800530236081304
|- class="odd"
| Skewness
| 1.5173452799192164
|- class="even"
| Minimum
| 8
|- class="odd"
| Maximum
| 18
|- class="even"
| Range
| 10
|- class="odd"
| Sum
| 45
|- class="even"
| Confidence Level 95%
| 3.752895614602602
|- class="odd"
| Largest(1)
| 18
|- class="even"
| Smallest(1)
| 8
|}
</div>
----
<div id="9SpaceContent" class="zcontent" align="left">
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Row 1
!
|- class="odd"
| Mean
| 8
|- class="even"
| Standard Deviation
| 0
|- class="odd"
| Count
| 2
|- class="even"
| Standard Error
| 0
|- class="odd"
| Median
| 8
|- class="even"
| Mode
| 8
|- class="odd"
| Sample Variance
| 0
|- class="even"
| Kurtosis
| NaN
|- class="odd"
| Skewness
| NaN
|- class="even"
| Minimum
| 8
|- class="odd"
| Maximum
| 8
|- class="even"
| Range
| 0
|- class="odd"
| Sum
| 16
|- class="even"
| Confidence Level 95%
| 0
|- class="odd"
| Largest(2)
| 8
|- class="even"
| Smallest(1)
| 8
|}
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Row 2
!
|- class="odd"
| Mean
| 7.5
|- class="even"
| Standard Deviation
| 0.7071067811865476
|- class="odd"
| Count
| 2
|- class="even"
| Standard Error
| 0.5
|- class="odd"
| Median
| 7.5
|- class="even"
| Mode
| #ERROR
|- class="odd"
| Sample Variance
| 0.5000000000000001
|- class="even"
| Kurtosis
| NaN
|- class="odd"
| Skewness
| NaN
|- class="even"
| Minimum
| 7
|- class="odd"
| Maximum
| 8
|- class="even"
| Range
| 1
|- class="odd"
| Sum
| 15
|- class="even"
| Confidence Level 95%
| 4.492321766046884
|- class="odd"
| Largest(2)
| 7
|- class="even"
| Smallest(1)
| 7
|}
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Row 3
!
|- class="odd"
| Mean
| 11
|- class="even"
| Standard Deviation
| 0
|- class="odd"
| Count
| 2
|- class="even"
| Standard Error
| 0
|- class="odd"
| Median
| 11
|- class="even"
| Mode
| 11
|- class="odd"
| Sample Variance
| 0
|- class="even"
| Kurtosis
| NaN
|- class="odd"
| Skewness
| NaN
|- class="even"
| Minimum
| 11
|- class="odd"
| Maximum
| 11
|- class="even"
| Range
| 0
|- class="odd"
| Sum
| 22
|- class="even"
| Confidence Level 95%
| 0
|- class="odd"
| Largest(2)
| 11
|- class="even"
| Smallest(1)
| 11
|}
</div>
----
'''DESCRIPTIVESTATISTICS'''(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)
where,
'''Array '''- Input range should be one or more blocks.
'''GroupBy''' - Either groupby rows or columns.
'''ConfidenceLevel -''' represents the confidence level for mean and value should be in between 0 and 100.
'''KthLargest -''' represents the kth largest value for each range of data.
'''KthSmallest''' - represents the kth smallest value for each range of data.
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet.If NewTableFlag is omitted, it assumed to be FALSE.
</div>
----
<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 >100 or ConfidenceLevel < 0, returns the #ERROR.
DESCRIPTIVESTATISTICS returns the #ERROR,
if KthLargest > Length of Array or KthSmallest < 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"
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| class=" " | Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 8
| class="sshl_f" | 8
| class="sshl_f" | 5Space
| class="sshl_f" | 5
|- class="even"
| class=" " | Row2
| class=" " | 7
| class=" " | 8
| class=" " | 9
| class="sshl_f" | 128
|- class="odd"
| Row3
| class="sshl_f" | 11
| class="sshl_f" | 11
| 14
| class="sshl_f " | 15
|- class="even"
| Row4
| class="sshl_f" | 7
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<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" | 10000
| class=" " | 20
|- class="odd"
| class=" " | Row5
| class=" " | 33
| 37
| 10023
| 168
|- class="even"
| Row6
| class="sshl_f" | 9Space
| class="sshl_f" | 2
| 1.619775
| 0.525322
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Column 1
!
|- class="odd"
| Mean
| 8.25
|- class="even"
| Standard Deviation
| 1.8929694486000912
|- class="odd"
| Count
| 4
|- class="even"
| Standard Error
| 0.9464847243000456
|- class="odd"
| Median
| 7.5
|- class="even"
| Mode
| 7
|- class="odd"
| Sample Variance
| 3.5833333333333335
|- class="even"
| Kurtosis
| 2.615467820443488
|- class="odd"
| Skewness
| 1.6585238002878033
|- class="even"
| Minimum
| 7
|- class="odd"
| Maximum
| 11
|- class="even"
| Range
| 4
|- class="odd"
| Sum
| 33
|- class="even"
| Confidence Level 95%
| 1.5060697372158713
|- class="odd"
| Largest(1)
| 11
|- class="even"
| Smallest(1)
| 7
|}
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Column 2
!
|- class="odd"
| Mean
| 11.25
|- class="even"
| Standard Deviation
| 4.716990566028302
|- class="odd"
| Count
| 4
|- class="even"
| Standard Error
| 2.358495283014151
|- class="odd"
| Median
| 9.5
|- class="even"
| Mode
| 8
|- class="odd"
| Sample Variance
| 22.249999999999996
|- class="even"
| Kurtosis
| 1.9800530236081304
|- class="odd"
| Skewness
| 1.5173452799192164
|- class="even"
| Minimum
| 8
|- class="odd"
| Maximum
| 18
|- class="even"
| Range
| 10
|- class="odd"
| Sum
| 45
|- class="even"
| Confidence Level 95%
| 3.752895614602602
|- class="odd"
| Largest(1)
| 18
|- class="even"
| Smallest(1)
| 8
|}
</div>
----
<div id="9SpaceContent" class="zcontent" align="left">
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Row 1
!
|- class="odd"
| Mean
| 8
|- class="even"
| Standard Deviation
| 0
|- class="odd"
| Count
| 2
|- class="even"
| Standard Error
| 0
|- class="odd"
| Median
| 8
|- class="even"
| Mode
| 8
|- class="odd"
| Sample Variance
| 0
|- class="even"
| Kurtosis
| NaN
|- class="odd"
| Skewness
| NaN
|- class="even"
| Minimum
| 8
|- class="odd"
| Maximum
| 8
|- class="even"
| Range
| 0
|- class="odd"
| Sum
| 16
|- class="even"
| Confidence Level 95%
| 0
|- class="odd"
| Largest(2)
| 8
|- class="even"
| Smallest(1)
| 8
|}
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Row 2
!
|- class="odd"
| Mean
| 7.5
|- class="even"
| Standard Deviation
| 0.7071067811865476
|- class="odd"
| Count
| 2
|- class="even"
| Standard Error
| 0.5
|- class="odd"
| Median
| 7.5
|- class="even"
| Mode
| #ERROR
|- class="odd"
| Sample Variance
| 0.5000000000000001
|- class="even"
| Kurtosis
| NaN
|- class="odd"
| Skewness
| NaN
|- class="even"
| Minimum
| 7
|- class="odd"
| Maximum
| 8
|- class="even"
| Range
| 1
|- class="odd"
| Sum
| 15
|- class="even"
| Confidence Level 95%
| 4.492321766046884
|- class="odd"
| Largest(2)
| 7
|- class="even"
| Smallest(1)
| 7
|}
{| class="SpreadSheet blue"
|+ <br />Descriptive Statistics
|- class="even"
! Row 3
!
|- class="odd"
| Mean
| 11
|- class="even"
| Standard Deviation
| 0
|- class="odd"
| Count
| 2
|- class="even"
| Standard Error
| 0
|- class="odd"
| Median
| 11
|- class="even"
| Mode
| 11
|- class="odd"
| Sample Variance
| 0
|- class="even"
| Kurtosis
| NaN
|- class="odd"
| Skewness
| NaN
|- class="even"
| Minimum
| 11
|- class="odd"
| Maximum
| 11
|- class="even"
| Range
| 0
|- class="odd"
| Sum
| 22
|- class="even"
| Confidence Level 95%
| 0
|- class="odd"
| Largest(2)
| 11
|- class="even"
| Smallest(1)
| 11
|}
</div>
----