DADiSP Worksheet Functions > Function Categories > Statistics and Calculus > Statistics and Calculus

 

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

BINCOEFF

Calculate the generalized binomial coefficient

BLOCKAVG

N-point block average

BLOCKMAX

N-point block maximum

BLOCKMEDIAN

N-point block median

BLOCKMIN

N-point block minimum

BLOCKRMS

N-point block RMS

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

COLRMS

Calculates the RMS for each column

COLSTDEV

Standard deviation of each column

COLSUM

Sum 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

DIFF

Calculate 2 point series difference

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

GNORMAL

Generate normally distributed random series

GRADIENT

Calculate the 2D derivative of an array

GRANDBINOMIAL

Generate binomial distributed random series

GRANDGAMMA

Generate gamma distributed random series

GRANDOM

Generate uniformly distributed random series

GRANDPOISSON

Generate Poisson distributed random series

HISTOGRAM

Calculate the frequency of values in a series

HYPOT

Calculate the square root of the sum of squares

IGRID

Grids XYZ data using the inverse distance method

INDEX

Normalize series to percentage terms

INF

Return the numeric representation of positive infinity

INTEG

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

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

NCHOOSEK

Return the unordered combinations of N items in groups of K

PARTSUM

Calculate Partial sum

PASCAL

Calculate Pascal's Triangle

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

ROWLEN

Length of each row

ROWMAX

Maximum of each row

ROWMEAN

Mean of each row

ROWMIN

Minimum of each row

ROWREDUCE

Apply REDUCE function to each row of a matrix

ROWSTDEV

Standard deviation of each row

ROWSUM

Sum of each row

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

STATSUM

Calculate summary statistics for one or more series

STD

Calculate sample (population) standard deviation of a series

STDERR

Calculate the standard error of a series or table

STDEV

Calculate standard deviation of a series

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