statistical

AVEDEV

Given a list of numbers, calculates the average of the magnitudes of deviations of data from their mean. Function signature AVEDEV(values: Array) => Number Examples numbers = [2,4,6] singleNumber = [2]

Updated on : 20 May 2022

Average_weighted

Given a list of numbers and a matching list of weights, calculates the numbers' weighted average. Function signature AVERAGE_WEIGHTED(values: Array, weights: Array) => Number Examples numbers = [1,2,4] weights = [0.5,0.5,0.25] numbers...

Updated on : 20 May 2022

Average

Given a list of numbers, calculates their average. Function signature AVERAGE(values: Array) => Number Examples

Updated on : 20 May 2022

Beta_dist

Calculates the probability of the given value using the beta distribution function. Optionally, you can use the cumulative distribution function. Function signature BETA_DIST(input: Number, alpha: Number, beta: Number, cumulative: Boolean) => N...

Updated on : 20 May 2022

Beta_inv

Given a probability, calculates the value of the inverse beta distribution function. Function signature BETA_INV(probability: Number, alpha: Number, beta: Number) => Number Examples

Updated on : 20 May 2022

Beta

Calculates the beta function using the specified values. Function signature BETA(xinput: Number, yinput: Number) => Number Examples

Updated on : 20 May 2022

Binomdist

Calculates the individual term binomial distribution probability. Function signature BINOMDIST(numbersuccesses: Number, numbertrials: Number, numberprobabilityofsuccess: Number, cumulative: Boolean) => Number Examples

Updated on : 20 May 2022

Chi_test

Calculates a Pearson's chi-squared test on two sets of data's associated right-tailed probability. Function signature CHI_TEST(observedrange: Array, expectedrange: Array) => Number Examples numbers = [1,2,4] numbers2 = [1,3,9] numbers...

Updated on : 20 May 2022

Chisq_dist

Calculates the chi-squared distribution (left-tailed). Function signature CHISQ_DIST(value: Number, degreesfreedom: Number, cumulative: Boolean) => Number Examples

Updated on : 20 May 2022

Chisq_inv

Calculates the inverse of the chi-squared distribution (left-tailed). Function signature CHISQ_INV(probability: Number, degreesoffreedom: Number) => Number Examples

Updated on : 20 May 2022

Chisq_rt_dist

Calculates the chi-squared distribution (right-tailed). Function signature CHISQ_RT_DIST(value: Number, degreesfreedom: Number) => Number Examples

Updated on : 20 May 2022

Chisq_rt_inv

Calculates the inverse of the chi-squared distribution (right-tailed). Function signature CHISQ_RT_INV(probability: Number, degreesoffreedom: Number) => Number Examples

Updated on : 20 May 2022

Confidence_t

Using a Student's t-distribution, calculates the confidence interval for a population mean. Function signature CONFIDENCE_T(alpha: Number, standarddeviation: Number, samplesize: Number) => Number Examples

Updated on : 20 May 2022

Confidence

Using a normal distribution, calculates the confidence interval for a population mean. Function signature CONFIDENCE(alpha: Number, standarddeviation: Number, samplesize: Number) => Number Examples

Updated on : 20 May 2022

Correl

Given two lists of numbers as a dataset, calculates their r, or the Pearson product moment correlation coefficient. Function signature CORREL(ydataset: Array, xdataset: Array) => Number Examples numbers = [1,2,4] numbers2 = [1,3,9] nu...

Updated on : 20 May 2022

Covar_p

Given two lists of numbers as a dataset, calculates the population covariance. Function signature COVAR_P(ydataset: Array, xdataset: Array) => Number Examples numbers = [1,2,4] numbers2 = [1,3,9] numbersReverse = [4,2,1] numbersLarge ...

Updated on : 20 May 2022

Covar

Given two lists of numbers as a dataset, calculates the sample covariance. Function signature COVAR(ydataset: Array, xdataset: Array) => Number Examples numbers = [1,2,4] numbers2 = [1,3,9] numbersReverse = [4,2,1] numbersLarge = [1,2...

Updated on : 20 May 2022

Devsq

Given a list of numbers as the sample, calculates the sum of squares of deviations. Function signature DEVSQ(ydataset: Array) => Number Examples numbers = [1,2,4] numbers2 = [1,7,19,8,3,9]

Updated on : 20 May 2022

ERF

Calculates the integral of the Gauss error function between 0 and the given number. Function signature ERF(number: Number) => Number Examples

Updated on : 20 May 2022

ERFC_inv

Calculates the inverse of the ERFC function. Function signature ERFC_INV(number: Number) => Number Examples

Updated on : 20 May 2022

ERFC

Calculates the complementary of the integral of the Gauss error function between 0 and the given number, i.e. 1 - ERF\(number\) . Function signature ERFC(number: Number) => Number Examples

Updated on : 20 May 2022

Expon_dist

Given a specific lambda, calculates the value of the exponential distribution function at the given number. Function signature EXPON_DIST(input: Number, lambda: Number, cumulative: Boolean) => Number Examples

Updated on : 20 May 2022

Expon_inv

Given a specific lambda, calculates the value of the inverse exponential distribution function at the given number. Function signature EXPON_INV(input: Number, lambda: Number) => Number Examples

Updated on : 20 May 2022

F_dist_rt

Calculates F probability distribution (right-tailed). Function signature F_DIST_RT(value: Number, degreesoffreedom1: Number, degreesoffreedom2: Number) => Number Examples

Updated on : 20 May 2022

F_dist

Calculates F probability distribution (left-tailed). Function signature F_DIST(value: Number, degreesoffreedom1: Number, degreesoffreedom2: Number, cumulative: Boolean) => Number Examples

Updated on : 20 May 2022

F_inv_rt

Calculates the inverse of the F probability distribution (right-tailed). Function signature F_INV_RT(probability: Number, degreesoffreedom1: Number, degreesoffreedom2: Number) => Number Examples

Updated on : 20 May 2022

F_inv

Calculates the inverse of the F probability distribution (left-tailed). Function signature F_INV(probability: Number, degreesoffreedom1: Number, degreesoffreedom2: Number) => Number Examples

Updated on : 20 May 2022

F_test

Given two lists of numbers, calculates the probability associated with an F-test for the equality of variances. Function signature F_TEST(sample1: Array, sample2: Array) => Number Examples

Updated on : 20 May 2022

Fisher_inv

Given a value, calculates its inverse Fisher transformation. Function signature FISHER_INV(number: Number) => Number Examples

Updated on : 20 May 2022

Fisher

Given a value, calculates its Fisher transformation. Function signature FISHER(number: Number) => Number Examples

Updated on : 20 May 2022

Forecast

Given the dependent and independent datasets a list of numbers, calculates the expected y-value for the given input x using linear regression. Function signature FORECAST(input: Number, dependantdata: Array, independentdata: Array) => Number ...

Updated on : 20 May 2022

Gamma_dist

Calculates the value of the Gamma distribution function for the given input number. Function signature GAMMA_DIST(value: Number, shape: Number, scale: Number, cumulative: Boolean) => Number Examples

Updated on : 20 May 2022

Gamma_inv

Calculates the inverse of the Gamma distribution function for the given probability. Function signature GAMMA_INV(probability: Number, shape: Number, scale: Number) => Number Examples

Updated on : 20 May 2022

Gamma

Calculates the value of the Gamma function for the given input number. Function signature GAMMA(number: Number) => Number Examples

Updated on : 20 May 2022

GammaIn

Calculates the natural logarithm of the value of the Gamma function for the given input number. Function signature GAMMALN(number: Number) => Number Examples

Updated on : 20 May 2022

Gauss

Given the input number z, returns the probability that a random value, taken from a normal (Gaussian) distribution, will fall between the mean and z standard deviations below or above the mean. Function signature GAUSS(number: Number) => Number...

Updated on : 20 May 2022

Geomean

Given a list of numbers, calculates their geometric mean (average). Function signature GEOMEAN(values: Array) => Number Examples

Updated on : 20 May 2022

Harmean

Given a list of numbers, calculates their harmonic mean (average). Function signature HARMEAN(values: Array) => Number Examples

Updated on : 20 May 2022

Hypgeom_dist

Given a population size and the number of successes in the population, calculates the probability of drawing a given number of successes in the given number of tries. The trial is performed without replacing draws. Function signature HYPGEOM_DI...

Updated on : 20 May 2022

Intercept

Given two lists of numbers, representing the dependent and independent data, performs linear regression on the dataset, calculating the y-value at which the resultant line will intersect the y-axis. Function signature INTERCEPT(dependentdata: A...

Updated on : 20 May 2022

Kurt

Given a list of numbers, calculates its kurtosis. Function signature KURT(values: Array) => Number Examples

Updated on : 20 May 2022

Lognorm_dist

description: Log-normal distribution # LOGNORM_DIST Description Given a mean and standard deviation, calculates the value of log-normal distribution at the given value. Function signature LOGNORM_DIST(input: Number, mean: Number, standa...

Updated on : 20 May 2022

Lognorm_inv

Given a mean and standard deviation, calculates the value of the inverse log-normal distribution at the given value. Function signature LOGNORM_INV(input: Number, mean: Number, standarddeviation: Number) => Number Examples

Updated on : 20 May 2022

Median

Given a list of numbers, calculates their median value. Function signature MEDIAN(values: Array) => Number Examples

Updated on : 20 May 2022

Mode

Given a list of numbers, calculates their mode. Function signature MODE(values: Array) => Number Examples numbers = [2,4,6] mode2Numbers = [1,1,2,2,4,6,2,2] mode1and2Numbers = [1,1,1,1,2,2,4,6,2,2] mode2and1Numbers = [2,2,2,1,1,1] sin...

Updated on : 20 May 2022

Neg_binom_dist

Given the probability of success in independent trials, calculates the probability that a certain number of failures will be reached before a certain number of successes is reached. Function signature NEG_BINOM_DIST(numfailures: Number, numsucc...

Updated on : 20 May 2022

Norm_dist

Calculates the value of the normal distribution function for the given number input, mean, and standard deviation. Optionally, the cumulative distribution function can be used. Function signature NORM_DIST(input: Number, mean: Number, standar...

Updated on : 20 May 2022

Norm_inv

Calculates the value of the inverse normal distribution function for the given number input, mean, and standard deviation. Optionally, the cumulative distribution function can be used. Function signature NORM_INV(input: Number, mean: Number, ...

Updated on : 20 May 2022

Norm_s_dist

Calculates the value of the standard normal cumulative distribution function for the given input number. Function signature NORM_S_DIST(input: Number) => Number Examples

Updated on : 20 May 2022

Norm_s_inv

Calculates the value of the inverse standard normal distribution function for the given input number. Function signature NORM_S_INV(input: Number) => Number Examples

Updated on : 20 May 2022

NTH_largest

Given a list of numbers, returns the nth largest number. Function signature NTH_LARGEST(list: Array, rank: Number) => Number Examples array = [10,1,2,6,-1,10,12]

Updated on : 20 May 2022

NTH_smallest

Given a list of numbers, returns the nth smallest number. Function signature NTH_SMALLEST(list: Array, rank: Number) => Number Examples numbers1 = [10,1,2,6,-1,10,12] numbers2 = [29,44,61,1,36,-3,14,10,-24]

Updated on : 20 May 2022

Percent_rank_EXC

Updated on : 20 May 2022

Percent_rank

Given a list of numbers and a value in that list, gives the percent rank / percentile of the value. The percent rank is given as a decimal number between 0 and 1. If the exact value is not found in the list, it's percent rank is estimated based on...

Updated on : 20 May 2022

Percentile_EXC

Given a list of numbers and a percentile value (a decimal greater than 0 and smaller than 1), returns the value at that percentile. If a specific value is not found at the exact percentile given, the value is estimated based on other numbers in th...

Updated on : 20 May 2022

Percentile

Given a list of numbers and a percentile value (a decimal between 0 and 1), returns the value at that percentile. If a specific value is not found at the exact percentile given, the value is estimated based on other numbers in the list. Function...

Updated on : 20 May 2022

Permut

Calclulates the combitanorics function nPk for the given input. Given the size of a pool of objects, returns the number of ways a given number of objects can be chosen from that pool, with order of objects chosen taken into consideration. Function...

Updated on : 20 May 2022

Permutationa

Given the size of a pool of objects, returns the number of permutations for selecting a number of objects from that pool, with each object being replaced to the pool after being selected. Mathematically, this is equivalent to raising the pool size...

Updated on : 20 May 2022

PHI

Calculates the value of the normal distribution for the input value, with mean 0 and a standard deviation of 1. Function signature PHI(input: Number) => Number Examples

Updated on : 20 May 2022

Poisson_dist

Calculates the value of the Poisson distribution function for the given input number and mean. Optionally, the cumulative distribution function can be used. Function signature POISSON_DIST(input: Number, mean: Number, cumulative: Boolean) => Nu...

Updated on : 20 May 2022

Prob

Given two lists of numbers that correspond to a set of values and their probabilities, calculates the probability that a random value falls between the given low and high limit. Function signature PROB(values: Array, probabilities: Array, lowli...

Updated on : 20 May 2022

Quartile_exc

Given a list of numbers and a quartile (integer 1, 2 or 3), returns the value in the list nearest to the given quartile. Function signature QUARTILE_EXC(values: Array, quartilenumber: Number) => Number Examples

Updated on : 20 May 2022

Quartile

Given a list of numbers and a quartile (integer between 0 and 4), returns the value in the list nearest to the given quartile. Function signature QUARTILE(values: Array, quartilenumber: Number) => Number Examples

Updated on : 20 May 2022

Rank_avg

Given a list of numbers, returns the given value's rank in the list. If there are multiple matching values in the list, returns their average rank. Function signature RANK_AVG(value: Number, values: Array, ordering: Boolean) => Number Ex...

Updated on : 20 May 2022

Rank

Given a list of numbers, returns the given value's rank in the list. Function signature RANK(value: Number, values: Array, ordering: Boolean) => Number Examples

Updated on : 20 May 2022

RSQ

Given two lists of numbers as a dataset, calculates the square of r, the Pearson product moment correlation coefficient. Function signature RSQ(ydataset: Array, xdataset: Array) => Number Examples numbers = [1,2,4] numbers2 = [1,3,9] ...

Updated on : 20 May 2022

Skew_p

Given a list of numbers, calculates their population skewness. Function signature SKEW_P(values: Array) => Number Examples numbersSym = [1,2,3,4] numbersNonSym = [1,2,3,10] numbersNonSymNeg = [-10,1,2,3] numbers = [2,5,8,13,10,18,23,2...

Updated on : 20 May 2022

Skew

Given a list of numbers, calculates their sample skewness. Function signature SKEW(values: Array) => Number Examples numbersSym = [1,2,3,4] numbersNonSym = [1,2,3,10] numbersNonSymNeg = [-10,1,2,3] numbers = [2,5,8,13,10,18,23,26] ...

Updated on : 20 May 2022

Slope

Given two lists of numbers as a dataset, calculates the slope of the line from linear regression. Function signature SLOPE(ydataset: Array, xdataset: Array) => Number Examples numbers = [1,2,3] numbers2 = [1,3,6] numbersReverse = [3,2...

Updated on : 20 May 2022

Standardize

Calculates a given random variable's normalized equivalent, using the given mean and standard deviation. Function signature STANDARDIZE(input: Number, mean: Number, standarddeviation: Number) => Number Examples

Updated on : 20 May 2022

Stdev_p

Given a list of numbers as a population, calculates standard deviation. Function signature STDEV_P(values: Array) => Number Examples numbers = [2,4,6] numbers2 = [2,5,8,13,10] numbers3 = [2,4,4,4,5,5,7,9] singleNumber = [1]

Updated on : 20 May 2022

Stdev

Given a list of numbers as a sample, calculates standard deviation. Function signature STDEV(values: Array) => Number Examples numbers = [2,4,6] numbers2 = [2,5,8,13,10] numbers3 = [2,4,4,4,5,5,7,9]

Updated on : 20 May 2022

Steyx

Calculates the predicted y-values' standard errors for each x in the dataset's regression. Function signature STEYX(ydataset: Array, xdataset: Array) => Number Examples

Updated on : 20 May 2022

T_dist_2T

Calculates a Student's two-tailed t-distribution probability for the given input. Function signature T_DIST_2T(input: Number, degreesoffreedom.: Number) => Number Examples

Updated on : 20 May 2022

T_dist_rt

Calculates a Student's right-tailed t-distribution probability for the given input. Function signature T_DIST_RT(input: Number, degreesoffreedom.: Number) => Number Examples

Updated on : 20 May 2022

T_dist

Calculates a Student's t-distribution probability for the given input. Function signature T_DIST(input: Number, degreesoffreedom.: Number, cumulative: Boolean) => Number Examples

Updated on : 20 May 2022

T_inv_2t

Given an input probability, calculates the negative inverse for Student's two-tailed t-distribution function. Function signature T_INV_2T(probability: Number, degreesoffreedom.: Number) => Number Examples

Updated on : 20 May 2022

T_inv

Given an input probability, calculates the negative inverse for Student's one-tailed t-distribution function. Function signature T_INV(probability: Number, degreesoffreedom.: Number) => Number Examples

Updated on : 20 May 2022

T_test

Calculates the probability associated with t-test for the given two lists of numbers. Function signature T_TEST(firstsample: Array, secondsample: Array, tails: Number, type: Number) => Number Examples num1 = [1,2,3,4,5,6] num2 = [1,3,...

Updated on : 20 May 2022

Trim_mean

Given a list of numbers, calculates the mean, excluding a specified range of numbers from the start and end of the list. Function signature TRIM_MEAN(values: Array, number: Number) => Number Examples numbers = [29,44,61,1,36,-3,14,10,...

Updated on : 20 May 2022

Variance_b

Given a list of numbers, calculates the biased variance. Function signature VARIANCE_B(values: Array) => Number Examples numbers = [2,4,6]

Updated on : 20 May 2022

Variance_p

Given a list of numbers as population, calculates the uncorrected variance. Function signature VARIANCE_P(values: Array) => Number Examples numbers = [2,4,6]

Updated on : 20 May 2022

Variance

Given a list of numbers as sample, calculates the unbiased variance. Function signature VARIANCE(values: Array) => Number Examples numbers = [2,4,6] singleNumber = [1]

Updated on : 20 May 2022

Weibull_dist

Calculates the Weibull distribution function's value for the given input number, shape and scale. Optionally, the cumulative distribution function can be used. Function signature WEIBULL_DIST(input: Number, shape: Number, scale: Number, cumulat...

Updated on : 20 May 2022

Weibull_inv

Given a probability, calculates the value of the inverse Weibull distribution function. Function signature WEIBULL_INV(probability: Number, shape: Number, scale: Number) => Number Examples

Updated on : 20 May 2022

Z_test

Given a list of numbers, calculates the one-tailed P-value of a Z-test. Optionally, the standard distribution can be explicitly given. Function signature Z_TEST(data: Array, value: Number, standarddeviation: Number) => Number Examples ...

Updated on : 20 May 2022