Investment Studio > Expressions > Functions > Statistical

Result type Function name Arguments
float avedev (float data [, ...])
float average (float data [, ...])
float beta (float a, float b)
float betadist (float x, float alpha, float beta, float a = 0, float b = 1, boolean cumulative = TRUE)
float betainv (float probability, float alpha, float beta, float a = 0, float b = 1)
float binomdist (integer successes, integer trials, float success_probability, boolean cumulative = TRUE)
float chi2 (float array[rows][cols] actual_values, float array[rows][cols] expected_values)
float chidist (float x, integer degrees_of_freedom, boolean cumulative = TRUE)
float chiinv (float probability, integer degrees_of_freedom)
float chitest (float array[rows][cols] actual_values, float array[rows][cols] expected_values)
float confidence (float alpha, float standard_deviation, integer size)
float correl (float array[rows][cols] a, float array[rows][cols] b, boolean nonbiased = FALSE)
integer count (data [, ...])
integer counta (data [, ...])
integer countblank (array argument)
integer countif (array data, string criteria)
float covar (float array[rows][cols] a, float array[rows][cols] b, boolean nonbiased = FALSE)
float critbinom (integer trials, float success_probability, float criterion)
float devsq (float data [, ...])
float erf (float argument)
float expondist (float x, float lambda, boolean cumulative = TRUE)
float exponinv (float probabililty, float lambda)
float fdist (float x, integer degrees_of_freedom_numerator, integer degrees_of_freedom_denominator, boolean cumulative = TRUE)
float finv (float probability, integer degrees_of_freedom_numerator, integer degrees_of_freedom_denominator)
float fisher (float argument)
float fisherinv (float argument)
float forecast (float x, float array known_ys, float array known_xs)
float array[*][1] frequency (float array data, float array bins)
float ftest (float array a, float array b)
float gamma (float argument)
float gammadist (float x, float alpha, float beta, boolean cumulative)
float gammainv (float probability, float alpha, float beta)
float gammaln (float argument)
float geomean (float data [, ...])
float array[*][1] growth (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, float array new_xs = known_xs, boolean fit_constant = TRUE)
float harmean (float data [, ...])
float hypgeomdist (integer sample_successes, integer sample_size, integer population_successes, integer population_size, boolean cumulative = FALSE)
float intercept (float array known_ys, float array known_xs)
float kurt (float data [, ...])
float large (float array table, integer rank)
float array[*][*] linest (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, boolean fit_constant = TRUE, boolean statistics = FALSE)
float array[*][*] logest (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, boolean fit_constant = TRUE, boolean statistics = FALSE)
float loginv (float probability, float mean, float standard_deviation)
float lognormdist (float x, float mean, float standard_deviation, boolean cumulative = TRUE)
float max (float data [, ...])
float median (float data [, ...])
float min (float data [, ...])
float mode (float data [, ...])
float negbinomdist (integer failures, integer successes, float success_probability)
float normdist (float x, float mean, float standard_deviation, boolean cumulative = TRUE)
float norminv (float probability, float mean, float standard_deviation)
float normsdist (float x, boolean cumulative = TRUE)
float normsinv (float probability)
float pearson (float array a, float array b)
float percentile (float array data, float left_alfa)
float percentrank (float array data, float x, integer significant_digits = 3)
float permut (integer n, integer k)
float poisson (integer events, float lambda, boolean cumulative = TRUE)
float prob (float array x_values, float array probability_values, float lower_limit, float upper_limit = lower_limit)
float quartile (float array data, integer quartile)
integer rank (float x, float array data, integer order = 0)
float rsq (float array a, float array b)
float skew (float data [, ...])
float slope (float array known_ys, float array known_xs)
float small (float array table, integer rank)
float standardize (float x, float mean, float standard_deviation)
float stdev (float data [, ...])
float stdevp (float data [, ...])
float steyx (float array known_ys, float array known_xs)
float tdist (float x, integer degrees_of_freedom, integer tails, boolean cumulative = TRUE)
float tinv (float probability, integer degrees_of_freedom)
float array[*][1] trend (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, float array new_xs = known_xs, boolean fit_constant = TRUE)
float trimmean (float array data, float percent)
float ttest (float array a, float array b, integer tails, integer type)
float var (float data [, ...])
float varp (float data [, ...])
float weibull (float x, float shape, float scale, boolean cumulative = TRUE)
float weibullinv (float probability, float shape, float scale)
float ztest (float array data, float x, float standard_deviation = stdev(data))