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 Parameter Description Values List of numeric values Exam...

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 Parameter Description Values List of numeric ...

Updated on : 20 May 2022

Average

Given a list of numbers, calculates their average. Function signature AVERAGE(values: Array) => Number Parameter Description Values List of numeric values Examples Formula Return value AVERAG...

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 Parameter Description Probability The probabili...

Updated on : 20 May 2022

Beta

Calculates the beta function using the specified values. Function signature BETA(xinput: Number, yinput: Number) => Number Parameter Description X input The X input to the Beta function Y input The Y input to the...

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 Parameter Description ...

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 Parameter Description Observed range Th...

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 Parameter Description Value The input to the chi-squared probabil...

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 Parameter Description Probability The probability associated wit...

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 Parameter Description Value The input to the chi-squared probability distribution ...

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 Parameter Description Probability The probability associated...

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 Parameter Description Alph...

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 Parameter Description Alpha Sig...

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 Parameter Description Y dataset Li...

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 Parameter Description Y dataset List of dependent data. X datase...

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 Parameter Description Y dataset List of dependent data. X dataset Li...

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 Parameter Description Y dataset List of dependent data. Examples numbers ...

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 Parameter Description Number Upper boundary of the integral Examples Fo...

Updated on : 20 May 2022

ERFC_inv

Calculates the inverse of the ERFC function. Function signature ERFC_INV(number: Number) => Number Parameter Description Number Number to calculate Examples Formula Return value ERFC_INV(0)...

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 Parameter Description Number Upper boun...

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 Parameter Description ...

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 Parameter Description Input The in...

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 Parameter Description Value The input to the F probability...

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 Parameter Description Value The input to ...

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 Parameter Description Probability ...

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 Parameter Description Probability The ...

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 Parameter Description Sample 1 The first...

Updated on : 20 May 2022

Fisher_inv

Given a value, calculates its inverse Fisher transformation. Function signature FISHER_INV(number: Number) => Number Parameter Description Number Value to transform Examples Formula Return value ...

Updated on : 20 May 2022

Fisher

Given a value, calculates its Fisher transformation. Function signature FISHER(number: Number) => Number Parameter Description Number Value to transform Examples Formula Return value FISHER(-...

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 Parameter Description Value Th...

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 Parameter Description Probability The input t...

Updated on : 20 May 2022

Gamma

Calculates the value of the Gamma function for the given input number. Function signature GAMMA(number: Number) => Number Parameter Description Number The input to the Gamma function Examples Formula Re...

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 Parameter Description Number The input to the Gamma function Ex...

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 Parameter Description Values List of numeric values Examples Formula Return value ...

Updated on : 20 May 2022

Harmean

Given a list of numbers, calculates their harmonic mean (average). Function signature HARMEAN(values: Array) => Number Parameter Description Values List of numeric values Examples Formula Return value ...

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 Parameter Description Values List of numeric values Examples Formula Return value KURT([1, 2...

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 Parameter Descript...

Updated on : 20 May 2022

Median

Given a list of numbers, calculates their median value. Function signature MEDIAN(values: Array) => Number Parameter Description Values List of numeric values Examples Formula Return value ME...

Updated on : 20 May 2022

Mode

Given a list of numbers, calculates their mode. Function signature MODE(values: Array) => Number Parameter Description Values List of numeric values Examples numbers = [2,4,6] mode2Numbers = [1,1,2,2,4,6,2,2] ...

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 Parameter Description Input The input to the normal s distr...

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 Parameter Description Input The input of the inverse normal sta...

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 Parameter Description List List or range containing the dataset to consider Rank The ra...

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 Parameter Description List List or range containing the dataset to consider Rank The ...

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 Parameter Description Input The input to the PHI function ...

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 Parameter Description ...

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 Parameter Description ...

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 ...

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 Parameter Description Value The value whose rank will be determined ...

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 Parameter Description Y dataset ...

Updated on : 20 May 2022

Skew_p

Given a list of numbers, calculates their population skewness. Function signature SKEW_P(values: Array) => Number Parameter Description Values List of numeric values Examples numbersSym = [1,2,3,4] numbersNonS...

Updated on : 20 May 2022

Skew

Given a list of numbers, calculates their sample skewness. Function signature SKEW(values: Array) => Number Parameter Description Values List of numeric values Examples numbersSym = [1,2,3,4] numbersNonSym = [...

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 Parameter Description Y dataset List of dependent dat...

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 Parameter Description ...

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 Parameter Description Values List of numeric values Examples numbers = [2,4,6] number...

Updated on : 20 May 2022

Stdev

Given a list of numbers as a sample, calculates standard deviation. Function signature STDEV(values: Array) => Number Parameter Description Values List of numeric values Examples numbers = [2,4,6] numbers2 = [...

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 Parameter Description Y dataset List of dependent data. ...

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 Parameter Description Input The input to the distribution...

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 Parameter Description Input The input to the distributi...

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 Parameter Description Input The input to the distr...

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 Parameter Description Prob...

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 Parameter Description Probabi...

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 Parameter Description First sa...

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 Parameter Description Values ...

Updated on : 20 May 2022

Variance_b

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

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 Parameter Description Values List of numeric values 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 Parameter Description Values List of numeric values Examples numbers = [2,4,6] singleNu...

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 Parameter Description Probability Probab...

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 Paramete...

Updated on : 20 May 2022