Bugs and feature requests

Statistical

Here are the articles in this section:

Average deviations

Calculate average of an array

AVERAGE_WEIGHTED

Weighted average

Beta distribution

Beta inverse distribution

Calculates the probability of drawing a certain number of successes

Chi-squared distribution

Chi-squared inverse

Chi-squared right-tailed distribution

Chi-squared right-tailed inverse

Confidence using a normal distribution

Confidence with a student's t-distribution

Correlation coefficient

Covariant for sample

Covariant for population

Deviations squared

Gauss error function

Complementary Gauss error function

Inverse of complementary Gauss error function

Exponential distribution

Exponential distribution inverse

Fisher transformation

Fisher inverse transformation

Calculate forecast based on a linear regression

F distribution right-tailed

Inverse F distribution left-tailed

Inverse F distribution right-tailed

Gamma distribution

Hypergeometric distribution

Calculate intercept based on a linear regression

Log-normal distribution

Log-normal inverse distribution

Calculate mode of an array

Calculates negative binomial distribution

Normal distribution

Inverse normal distribution

Normal standart cumulative distribution

Inverse standard normal distribution

Returns the nth largest element

Returns the nth smallest element

Percentile of dataset

Percentile exclusive of dataset

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

PHI distribution

Poisson distribution

Quartile of dataset

Quartile of dataset, exclusive

Rank of the given value in the dataset

Average rank of the given value in the dataset

Pearson's R-Square function

Skewness sample

Skewness population

Standard deviation based on a sample

Standard deviation based on a population

Standard error of the regression dataset

Student's t-distribution

Student's two-tailed t-distribution

Student's right-tailed t-distribution

Inverse Student's one-tailed t-distribution

Inverse Student's two-tailed t-distribution

Calculate variance of an array

Biased variance

Variance of the population

Weibull distribution

Weibull inverse distribution

Last updated 1 week ago