Statistics function improvements

Version: 2021b

Type: Features

Category: Programming

Subcategory: Labtalk

Jira: ORG-23039

Improved functions

ave() – 3rd argument added for more statistics quantities

1 (default, same as current): mean
2 sd, 3 se, 4 min, 5 max, 6 median, 7 sum, 8 RMS
E.g. Enter formula ave(A, 10, 2) in Column B’s F(x) cell to calculate standard deviation of every 10 data in column A.

Confidence() – a 4th argument “dist” is added to provide another algorithm.
dist=1 is default, same as current result,
dist=2 uses Student's t distribution, same as Excel's CONFIDENCE.T function

New functions

lcl(vd[, level]) // lower confidence level
ucl(vd[, level]) // upper confidence level
Mad(vd) // Mean Absolute Deviation
Geomean(vd) // Geometric Mean
Geosd(vd) // Geometric SD
Harmean(vd) // Harmonic Mean