Statistics Functions
Prev
Next
Function Library Guide
Table of Contents
1 Function Library
+ 2 Control Flow Functions
+ 3 Console I/O Functions
+ 4 Type Conversion and Formatting
5 Mathematics and Statistics
+ 5.1 Basic Math Functions
+ 5.2 Transcendental Functions
+ 5.3 Series Functions
+ 5.4 Matrix Functions
5.5 Statistics Functions
5.5.1 Basic Statistics Functions
5.5.2 quantile ...
5.5.3 covariance, correlation
5.5.4 gini Coefficient Functions
5.5.5 Linear and Exponential Regression
+ 5.5.6 Interpolation Functions
5.6 Conditional Combination Functions
+ 5.7 Finance and Business Functions
+ 6 String Functions
+ 7 Date and Time Functions
+ 8 Parameter Set Functions
+ 9 Table Functions
+ 10 Variables Functions
+ 11 Directory and File System Functions
+ 12 System Functions
+ 13 Help and Support Functions
+ 14 Cross-Functional Info
→ User Guide
→ Language Guide
Index
Introduction
This section covers all statistics functions.
Procedures and Functions Provided:
basic statistics functions:
average
average ignore blanks
average ignore zero
deviation
deviation ignore blanks
deviation ignore zero
geometric mean
geometric mean ignore blanks
geometric mean ignore zero
harmonic mean
median
median ignore zero
parallel
product
product ignore blanks
product ignore zero
rms
rms ignore blanks
rms ignore zero
sum
variance
variance ignore blanks
variance ignore zero
quantile
quantile ignore zero
covariance and correlation:
correlation
covariance
gini coefficient, income disparity:
gini
gini ignore blanks
gini ignore zero
linear regression, exponential regression:
regression
interpolation:
linear interpolation
nearest neighbor interpolation
nearest right neighbor interpolation
polynomial interpolation
spline interpolation