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 if the first row has any label,
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 (AreaArray,GroupBy,ConfidenceLevelPercentage,KthLargest,KthSmallest,IsFirstRowLabels,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.
- 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.
ZOS
- The syntax is to use this function in ZOS is
- 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
|
Related Videos
See Also
References