Statistics and Calculus

 

A2STD

Convert an alpha confidence level to a standard deviation range

AMPDIST

Calculate Amplitude Distribution

AREA

Calculate the total area of a series using Simpsonís rule

AVGFILT

N-point neighboring point averaging

BLOCKAVG

N-point block average

BLOCKMEDIAN

N-point block median

CAREA

Calculate closed loop area

CNF2STD

Convert a confidence level (%) to a standard deviation range

COLLENGTH

Number of samples in each column

COLMAX

Maximum value in each column

COLMEAN

Mean value for each column

COLMEDIAN

Median value for each column

COLMIN

Minimum value for each column

COLREDUCE

Apply REDUCE function to each column

COLSTDEV

Standard deviation of each column

CONFX

Calculate the confidence level for a given density function and x value

CUMTRAPZ

Calculates the integral of a series using the trapezoidal rule.

DERIV

Calculate derivative

DYDX

Perform a derivative on XY data

EPS

Return the minimum positive real value

ERRORBAR

Add error bars to graph

EXPMOVAVG

Exponential Moving Average

FDERIV

Calculates the derivative of a series in the frequency domain

FINTEG

Calculates the integral of a series in the frequency domain

GRADIENT

Calculate the 2D derivative of an array

HISTOGRAM

Calculate the frequency of values in a series

IGRID

Grids XYZ data using the inverse distance method

INDEX

Normalize series to percentage terms

INTEG

Calculates the integral of a series using Simpsonís rule.

INF

Return the numeric representation of positive infinity

INVDISTANCE

Interpolate XYZ data to arbitrary XY coordinates using the inverse distance method

INVPROBN

Return z value of the probability of X <= z for a normal distribution

IVSNORMPB

Return z value for input probability based on normal pdf

KURTOSIS

Calculate the kurtosis of a series

LDERIV

Calculate derivative from the left

LENGTH

Return length of series

LINAVG

Zero phase moving average

LINEXPAVG

Zero phase exponential moving average

LINFIT

General Linear Least Squares Regression

LINREG

Determine linear regression

LINREG2

Linear regression of two or more series

LINRMS

Zero phase moving RMS

MAX

Calculate max

MEAN

Calculate mean

MEDFILT1

N-point median filtering on a series

MEDIAN

Calculate median

MOVAVG

N-point moving average

MOVAVG2

N-point moving average with end point padding

MOVMAX

N-point moving maximum

MOVMEDIAN

N-point moving median

MOVMIN

N-point moving minimum

MOVRMS

N-point moving RMS

MOVSTD

N-point moving standard deviation

PARTSUM

Calculate Partial sum

PDFNORM

Return the probability density function for a normal distribution

PEARSON

Calculate Pearson's Linear Correlation Coefficient

PERCENTILE

Estimate the percentile of a series

POLYAREA

Calculate the area of a regular polygon

POLYROOT

Find the roots of a polynomial in ascending powers

PROBN

Calculate the probability of X <= z for a normal distribution

RDERIV

Calculate derivative from right

RMS

Root Mean Square

ROOTS

Find the roots of a polynomial in descending powers

ROWREDUCE

Apply REDUCE function to each row of a matrix

SERSIZE

Return length of series

SGRID

Grids XYZ data using spline interpolation

SKEW

Calculate the skewness of a series

SPLINE2

Performs two-dimensional cubic spline fitting

STATS

Display statistics, STDEV and ERROR

STDERR

Calculate the standard error of a series or table

STDEV

Calculate Standard Deviation

SVD

Generate Singular Value Decomposition of a matrix

SVDDIV

Solves for x in A *^ x = b using singular value decomposition

TRAPZ

Calculate the total area of a series using the trapezoidal rule

TREND

Fit a line to a series

XCONF

Calculate x value for a given density function and confidence level