Statistical

Here are the articles in this section:
AVEDEV
Average deviations
AVERAGE
Calculate average of an array
AVERAGE_WEIGHTED
Weighted average
BETA
Beta function
BETA_DIST
Beta distribution
BETA_INV
Beta inverse distribution
BINOMDIST
Calculates the probability of drawing a certain number of successes
CHISQ_DIST
Chi-squared distribution
CHISQ_INV
Chi-squared inverse
CHISQ_RT_DIST
Chi-squared right-tailed distribution
CHISQ_RT_INV
Chi-squared right-tailed inverse
CHI_TEST
Chi test
CONFIDENCE
Confidence using a normal distribution
CONFIDENCE_T
Confidence with a student's t-distribution
CORREL
Correlation coefficient
COVAR
Covariant for sample
COVAR_P
Covariant for population
DEVSQ
Deviations squared
ERF
Gauss error function
ERFC
Complementary Gauss error function
ERFC_INV
Inverse of complementary Gauss error function
EXPON_DIST
Exponential distribution
EXPON_INV
Exponential distribution inverse
FISHER
Fisher transformation
FISHER_INV
Fisher inverse transformation
FORECAST
Calculate forecast based on a linear regression
F_DIST
F distribution
F_DIST_RT
F distribution right-tailed
F_INV
Inverse F distribution left-tailed
F_INV_RT
Inverse F distribution right-tailed
F_TEST
F-test
GAMMA
Gamma
GAMMALN
Gamma LN
GAMMA_DIST
Gamma distribution
GAMMA_INV
Gamma inverse
GAUSS
Gauss
GEOMEAN
Geometric mean
HARMEAN
Harmonic mean
HYPGEOM_DIST
Hypergeometric distribution
INTERCEPT
Calculate intercept based on a linear regression
KURT
Kurtosis
LOGNORM_DIST
Log-normal distribution
LOGNORM_INV
Log-normal inverse distribution
MEDIAN
Median
MODE
Calculate mode of an array
NEG_BINOM_DIST
Calculates negative binomial distribution
NORM_DIST
Normal distribution
NORM_INV
Inverse normal distribution
NORM_S_DIST
Normal standart cumulative distribution
NORM_S_INV
Inverse standard normal distribution
NTH_LARGEST
Returns the nth largest element
NTH_SMALLEST
Returns the nth smallest element
PERCENTILE
Percentile of dataset
PERCENTILE_EXC
Percentile exclusive of dataset
PERCENT_RANK
Returns the value at a given percentile of a dataset, exclusive of 0 and 1
PERCENT_RANK_EXC
Returns the percentage rank (percentile) from 0 to 1 exclusive
PERMUT
Permut
PERMUTATIONA
Permutation
PHI
PHI distribution
POISSON_DIST
Poisson distribution
PROB
Probability
QUARTILE
Quartile of dataset
QUARTILE_EXC
Quartile of dataset, exclusive
RANK
Rank of the given value in the dataset
RANK_AVG
Average rank of the given value in the dataset
RSQ
Pearson's R-Square function
SKEW
Skewness sample
SKEW_P
Skewness population
SLOPE
Slope
STANDARDIZE
Standardize
STDEV
Standard deviation based on a sample
STDEV_P
Standard deviation based on a population
STEYX
Standard error of the regression dataset
TRIM_MEAN
Trim mean
T_DIST
Student's t-distribution
T_DIST_2T
Student's two-tailed t-distribution
T_DIST_RT
Student's right-tailed t-distribution
T_INV
Inverse Student's one-tailed t-distribution
T_INV_2T
Inverse Student's two-tailed t-distribution
T_TEST
T-test
VARIANCE
Calculate variance of an array
VARIANCE_B
Biased variance
VARIANCE_P
Variance of the population
WEIBULL_DIST
Weibull distribution
WEIBULL_INV
Weibull inverse distribution
Z_TEST
Z test