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
Binomial distribution probability
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 with 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 integral
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, left-tailed
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
Calculate negative binomial distribution
NORM_DIST
Normal distribution
NORM_INV
Inverse normal distribution
NORM_S_DIST
Standard noral cumulative distribution
NORM_S_INV
Inverse standard normal distribution
NTH_LARGEST
Nth largest number in array
NTH_SMALLEST
Nth smallest number in array
PERCENTILE
Percentile of dataset
PERCENTILE_EXC
Percentile exclusive of dataset
PERCENT_RANK
Percent rank of a number in array
PERCENT_RANK_EXC
Percent rank of a number in array (exclusive 0 and 1)
PERMUT
Permutation
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