avedev

Returns the average of the absolute deviations of the data points from their mean

double

avedev(Object valuesObj)

average

Returns the average value of its parameters

double

average(Object valuesObj)

averagea

Returns the average value of its arguments, including numbers, text, and logical values

double

averagea(Object valuesObj)

averageif 

Returns the mean (arithmetic mean) of all cells in the area that satisfy the given condition

double

averageif(Object valuesObj, String criteria, Object avgValuesObj)

binomdist

Returns the probability value of the unary binomial distribution

double

binomdist(double counts, double trials, double successP,boolean cummulative)

correl

Returns the correlation coefficient between two data sets

double

correl(Object valuesObj1, Object valuesObj2)

statisticCount

Calculate the number of parameters in the parameter list

int

statisticCount(Object valuesObj)

counta

Calculate the number of non-null value in parameter list

int

counta(Object valuesObj)

countblank 

Calculate the number of empty cell in the area

int

countblank(Object valuesObj)

countdistinct

Calculate the number of non-repetative digit in the parameter list

int

countdistinct(Object valuesObj)

countif 

Calculate the number of cell (currently only the numeric expressions are supported) that meets the given conditions in the area

int

countif(Object rangeObj, String criteria)

countn

Return the number of digit in the array

int

countn(Object valuesObj)

devsq

Return the quadratic sum of deviation

double

devsq(Object valuesObj)

expondist

Return the exponential distribution

double

expondist(double x, double lambda, boolean cumulative)

fisher

Return the transformed value of Fisher

double

fisher(double value)

fisherinv

Return the inverse function value transformed by Fisher

double

fisherinv(double value)

forecast

Return the value along the linear trend

double

forecast(double x, Object yObj, Object xObj)

frequency

Return the frequency distribution in the form of vertical array

int

frequency(Object datasObj, Object rangesObj)

geomean

Return the geometric mean

double

geomean(Object valuesObj)

harmean

Return the harmonic mean

double

harmean(Object valuesObj)

hypgeomdist

Returns hypergeometric distribution

double

hypgeomdist(double number_succ, double number_sample,double pop_succ, double number_pop, boolean cumulative)

intercept

Returns the intercept of the linear regression line

double

intercept(Object knownYObj, Object knownXObj)

kurt

Return the peak of the data set

double

kurt(Object valuesObj)

large

Returns the k-th largest value in the data set

double

large(Object valuesObj, int k)

statisticMax

Return the maximum value in the parameter list

double

statisticMax(Object valuesObj)

maxa

Returns the maximum value in the parameter list, including numbers, text, date and logical values

double

maxa(Object valuesObj) 

statisticMedian

Returns the median of a given set of values

double

statisticMedian(Object valuesObj)

statisticMin

Return the minimum value in the parameter list

double

statisticMin(Object valuesObj)

mina

Returns the minimum value in the parameter list, including numbers, text, date and logical values

double

mina(Object valuesObj)

statisticMode

Returns the most frequently occurring value in a dataset

double

statisticMode(Object valuesObj)

negbinomdist

Return negative binomial distribution

double

negbinomdist(double nb_fail, double nb_succ, double pro_succ)

pearson

Returns Pearson product moment correlation coefficient

double

pearson(Object valuesObj1, Object valuesObj2)

percentile

Returns the value of the k-th percentile of the values in the region

double

percentile(Object valuesObj, double k)

percentrank

Returns the percentage rank of values in the dataset

double

percentrank(Object valuesObj, double target, double significance) 

permut

Returns the number of arrays for a given number of objects

double

permut(double number, double chosen)

poisson

Return Poisson distribution

double

poisson(double x, double mean, boolean cumulative)

prob

The probability that the value in the return range falls within the specified range

double

prob(Object rangeObj, Object probRangeObj, double llimit, double uplimit) 

statisticQuartile

Returns the quartile of a set of data

double

statisticQuartile(Object valuesObj, double quart)

rank

Returns a list of numerical digits

int

rank(double number, Object valuesObj, double order)

rsq

Returns the square of the Pearson product moment correlation coefficient

double

rsq(Object arrayObj1, Object arrayObj2)

skew

Returns the asymmetry of the distribution

double

skew(Object valuesObj)

slope

Returns the slope of the linear regression line

double

slope(Object yObjs, Object xObjs)

small

Returns the kth lowest value in the data set

double

small(Object valuesObj, int k)

standardized

Return the normalized value

double

standardize(double x, double mean, double standard_dev)

stdev

Standard deviation based on sample estimates

double

stdev(Object valuesObj)

stdeva

Estimating the standard deviation based on samples (including numbers, text, and logical values)

double

stdeva(Object valuesObj)

stdevp

Calculate the standard deviation based on the entire sample population

double

stdevp(Object valuesObj)

stdevpa

Calculate standard deviations based on population (including numbers, text, and logical values)

double

stdevpa(Object valuesObj)

steyx

Returns the standard error generated by predicting the y-value of each x by linear regression

double

steyx(Object yObjs, Object xObjs)

trimmean

Return the internal average of the data set

double

trimmean(Object valuesObj, double percent)

varn

Calculate the variance based on the sample (corresponding to var in Excel, but var is the keyword in script, change to varn in firmware)

double

varn(Object valuesObj) 

vara

Estimate variance based on samples (including numbers, text, and logical values)

double

vara(Object valuesObj)

varp

Calculate the variance based on the sample population

double

 varp(Object valuesObj) 

varpa

Calculate the standard deviation based on population (including numbers, text, and logical values)

double

varpa(Object valuesObj)

weightedavg

Returns the weighted average of two arrays

double

weightedavg(Object array1Obj, Object array2Obj)

weibull

Returns Weibull probability density

double

weibull(double x, double alpha, double beta, boolean cumulative)