86 Articles in this category

DarkLight
statistical
86 Articles in this category

DarkLight
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
Given a list of numbers, calculates their average.
Function signature
AVERAGE(values: Array) => Number
Examples
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
Chisq_dist
Calculates the chisquared distribution (lefttailed).
Function signature
CHISQ_DIST(value: Number, degreesfreedom: Number, cumulative: Boolean) => Number
Examples
Updated on : 20 May 2022
Chisq_inv
Calculates the inverse of the chisquared distribution (lefttailed).
Function signature
CHISQ_INV(probability: Number, degreesoffreedom: Number) => Number
Examples
Updated on : 20 May 2022
Chisq_rt_dist
Calculates the chisquared distribution (righttailed).
Function signature
CHISQ_RT_DIST(value: Number, degreesfreedom: Number) => Number
Examples
Updated on : 20 May 2022
Chisq_rt_inv
Calculates the inverse of the chisquared distribution (righttailed).
Function signature
CHISQ_RT_INV(probability: Number, degreesoffreedom: Number) => Number
Examples
Updated on : 20 May 2022
Confidence_t
Using a Student's tdistribution, 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
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 (righttailed).
Function signature
F_DIST_RT(value: Number, degreesoffreedom1: Number, degreesoffreedom2: Number) => Number
Examples
Updated on : 20 May 2022
F_dist
Calculates F probability distribution (lefttailed).
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 (righttailed).
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 (lefttailed).
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 Ftest 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
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
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
Kurt
Given a list of numbers, calculates its kurtosis.
Function signature
KURT(values: Array) => 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
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
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
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
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
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
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 yvalues' 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 twotailed tdistribution 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 righttailed tdistribution 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 tdistribution 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 twotailed tdistribution 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 onetailed tdistribution function.
Function signature
T_INV(probability: Number, degreesoffreedom.: Number) => Number
Examples
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