3.5.3.1 General Stat

Basic

Name Brief Example
Count Counts elements in a vector. Example
Countif Counts the elements in a vector that satisfy a specified condition. Example
Cov Returns the covariance between two datasets.
Forecast Performs linear regression on the known XY coordinates to calculate or predict y coordinate at given coordinate x. Example
Intercept Calculates the intercept of the linear regression of the given curve. Example
Max This function returns the maximum value from a set of values. Example
Maxifs Returns the maximum value from a given dataset vd that satisfies a specified condition con. Example
Mean Returns the average of a vector. Example
Median This function is used to return median of vdData with n Interpolation. Example
Min This function is used to return the minimum value from a set of values. Example
Minifs Returns the minimum value from a given dataset vd that satisfies a specified condition con. Example
Rms This function is used to return the root mean square of a vector. Example
Slope Calculates the slope of the linear regression of the given curve. Example
Ss Assumes the mean of the data as the reference value. Example
StdDev Calculates the standard deviation based on a sample. Example
StdDevP Return the standard deviation based on the entire population given as arguments. Example
Total Returns the sum of a vector. Example

Data Manipulation

Name Brief Example
Ave Breaks dataset into groups of size size, finds the average for each group, and returns a range containing these values. Example
Diff Returns a dataset that contains the difference between adjacent elements in dataset.
Sum Returns a range whose i th element is the sum of the first i elements of the dataset dataset. Example

Advanced

Name Brief Example
Confidence Returns the confidence interval for a population mean. Example
Histogram The histogram(dataset, inc, min, max) function generates data bins from dataset in the specified range from min to max.
Kurt Returns the kurtosis of the specified dataset. Example
Percentile Returns a range comprised of the percentile values for dataset1 at each percent value specified in dataset2. Example
QCD2 Returns a factor (Quality Control D2 Factor) Example
QCD3 Returns a factor. (Quality Control D3 Factor) Example
QCD4 Returns a factor. (Quality Control D4 Factor) Example
Skew Returns the skewness of a distribution. Example

Time Series

Name Brief Example
Emovavg This function returns exponential moving averages. Example
Mmovavg This function returns modified moving averages. Example
Movavg This function returns the average of adjacent ranges. Example
Movslope This function returns a vector to calculate the moving slope at each point with a window width of nPt. Example
Movrms This function returns a vector to calculate the root mean square(rms) of adjacent ranges. Example
Tmovavg This function returns triangular moving averages. Example
Wmovavg This function returns weighted moving averages. Example
MovCoef This function returns a vector of moving correlation coefficients. Example