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