Difference between revisions of "Manuals/calci/DESCRIPTIVESTATISTICS"

From ZCubes Wiki
Jump to navigation Jump to search
Line 224: Line 224:
 
| Mode
 
| Mode
 
| 8
 
| 8
 +
|- class="odd"
 
| Standard Deviation
 
| Standard Deviation
 
| 0
 
| 0
−
|- class="odd"
+
|- class="even"
 
| Sample Variance
 
| Sample Variance
 
| 0
 
| 0
−
|- class="even"
+
|- class="odd"
 
| Kurtosis
 
| Kurtosis
 
| NaN
 
| NaN
−
|- class="odd"
+
|- class="even"
 
| Skewness
 
| Skewness
 
| NaN
 
| NaN
−
|- class="even"
+
|- class="odd"
 
| Range
 
| Range
 
| 0
 
| 0
−
|- class="odd"
+
|- class="even"
 
| Minimum
 
| Minimum
 
| 8
 
| 8
−
|- class="even"
+
|- class="odd"
 
| Maximum
 
| Maximum
 
| 8
 
| 8
−
|- class="odd"
+
|- class="even"
 
| Sum
 
| Sum
 
| 16
 
| 16
−
|- class="even"
+
|- class="odd"
 
| Count
 
| Count
 
| 2
 
| 2
−
|- class="odd"
+
|- class="even"
 
| Confidence Level 95%
 
| Confidence Level 95%
 
| 0
 
| 0
−
|- class="even"
+
|- class="odd"
 
| Largest(2)
 
| Largest(2)
 
| 8
 
| 8
Line 278: Line 279:
 
| Mode
 
| Mode
 
| #ERROR
 
| #ERROR
 +
|- class="odd"
 
| Standard Deviation
 
| Standard Deviation
 
| 0.7071067811865476
 
| 0.7071067811865476
−
|- class="odd"
+
|- class="even"
 
| Sample Variance
 
| Sample Variance
 
| 0.5000000000000001
 
| 0.5000000000000001
−
|- class="even"
+
|- class="odd"
 
| Kurtosis
 
| Kurtosis
 
| NaN
 
| NaN
−
|- class="odd"
+
|- class="even"
 
| Skewness
 
| Skewness
 
| NaN
 
| NaN
−
|- class="even"
+
|- class="odd"
 
| Range
 
| Range
 
| 1
 
| 1
−
|- class="odd"
+
|- class="even"
 
| Minimum
 
| Minimum
 
| 7
 
| 7
−
|- class="even"
+
|- class="odd"
 
| Maximum
 
| Maximum
 
| 8
 
| 8
−
|- class="odd"
+
|- class="even"
 
| Sum
 
| Sum
 
| 15
 
| 15
−
|- class="even"
+
|- class="odd"
 
| Count
 
| Count
 
| 2
 
| 2
−
|- class="odd"
+
|- class="even"
 
| Confidence Level 95%
 
| Confidence Level 95%
 
| 6.353102368087358
 
| 6.353102368087358
−
|- class="even"
+
|- class="odd"
 
| Largest(2)
 
| Largest(2)
 
| 7
 
| 7
Line 332: Line 334:
 
| Mode
 
| Mode
 
| 11
 
| 11
 +
|- class="odd"
 
| Standard Deviation
 
| Standard Deviation
 
| 0
 
| 0
−
|- class="odd"
+
|- class="even"
 
| Sample Variance
 
| Sample Variance
 
| 0
 
| 0
−
|- class="even"
+
|- class="odd"
 
| Kurtosis
 
| Kurtosis
 
| NaN
 
| NaN
−
|- class="odd"
+
|- class="even"
 
| Skewness
 
| Skewness
 
| NaN
 
| NaN
−
|- class="even"
+
|- class="odd"
 
| Range
 
| Range
 
| 0
 
| 0
−
|- class="odd"
+
|- class="even"
 
| Minimum
 
| Minimum
 
| 11
 
| 11
−
|- class="even"
+
|- class="odd"
 
| Maximum
 
| Maximum
 
| 11
 
| 11
−
|- class="odd"
+
|- class="even"
 
| Sum
 
| Sum
 
| 22
 
| 22
−
|- class="even"
+
|- class="odd"
 
| Count
 
| Count
 
| 2
 
| 2
−
|- class="odd"
+
|- class="even"
 
| Confidence Level 95%
 
| Confidence Level 95%
 
| 0
 
| 0
−
|- class="even"
+
|- class="odd"
 
| Largest(2)
 
| Largest(2)
 
| 11
 
| 11
Line 386: Line 389:
 
| Mode
 
| Mode
 
| #ERROR
 
| #ERROR
 +
|- class="odd"
 
| Standard Deviation
 
| Standard Deviation
 
| 7.7781745930520225
 
| 7.7781745930520225
−
|- class="odd"
+
|- class="even"
 
| Sample Variance
 
| Sample Variance
 
| 60.49999999999999
 
| 60.49999999999999
−
|- class="even"
+
|- class="odd"
 
| Kurtosis
 
| Kurtosis
 
| NaN
 
| NaN
−
|- class="odd"
+
|- class="even"
 
| Skewness
 
| Skewness
 
| NaN
 
| NaN
−
|- class="even"
+
|- class="odd"
 
| Range
 
| Range
 
| 11
 
| 11
−
|- class="odd"
+
|- class="even"
 
| Minimum
 
| Minimum
 
| 7
 
| 7
−
|- class="even"
+
|- class="odd"
 
| Maximum
 
| Maximum
 
| 18
 
| 18
−
|- class="odd"
+
|- class="even"
 
| Sum
 
| Sum
 
| 25
 
| 25
−
|- class="even"
+
|- class="odd"
 
| Count
 
| Count
 
| 2
 
| 2
−
|- class="odd"
+
|- class="even"
 
| Confidence Level 95%
 
| Confidence Level 95%
 
| 69.88412604896092
 
| 69.88412604896092
−
|- class="even"
+
|- class="odd"
 
| Largest(2)
 
| Largest(2)
 
| 7
 
| 7
Line 431: Line 435:
 
== References ==
 
== References ==
  
−
*[http://en.wikipedia.org/wiki/Descriptive_statistics]
+
*[http://en.wikipedia.org/wiki/Descriptive_statistics Descriptive Statistics]

Revision as of 20:35, 21 January 2014

DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)

where,

  • is array of integers or reference to the cells containing array,
  • is a method that performs the analysis by Columns or Rows,
  • represents the confidence level for mean of data points and is between 0 to 100,
  • represents the Kth largest value for each range of data,
  • represents the Kth smallest value for each range of data,
  • 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.

Description

DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)

  • can be numbers or can be names, arrays or references containing numbers.
  • Values containing text, logical values or empty cells are ignored.
  • Argument can be "Rows" or "Columns".
  • If < '0' or > '100', Calci displays an error message.
  • If < '0' or > 'Length of array', Calci displays an error message.
  • can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
  • If is TRUE, output is displayed on a new ZSpace cube. If is FALSE, output is displayed on the same spreadsheet where command is written.
  • If data is invalid, Calci displays NaN error message.


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:B5,"Columns",95,1,1,TRUE)
=DESCRIPTIVESTATISTICS(A2:B6,"Rows",95,2,1,TRUE)

DESCRIPTIVESTATISTICS() displays the respective output for above examples -


Descriptive Statistics
Column 1
Mean 8.25
Standard Error 0.9464847243000456
Median 7.5
Mode 7
Standard Deviation 1.8929694486000912
Sample Variance 3.5833333333333335
Kurtosis 2.6154678204434845
Skewness 1.6585238002878033
Range 4
Minimum 7
Maximum 11
Sum 33
Count 4
Confidence Level 95% 3.0121394744317427
Largest(1) 11
Smallest(1) 7

Descriptive Statistics
Column 2
Mean 11.25
Standard Error 2.358495283014151
Median 9.5
Mode 8
Standard Deviation 4.716990566028302
Sample Variance 22.249999999999996
Kurtosis 1.9800530236081304
Skewness 1.517345279919216
Range 10
Minimum 8
Maximum 18
Sum 45
Count 4
Confidence Level 95% 7.505791229205204
Largest(1) 18
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

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/DESCRIPTIVESTATISTICS&oldid=197355"