Statistics

The list used for statistical computations

Creates a Statistics object

Creates a Statistics object

Example:

Statistics(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)

Return the arithmetic mean (average) of the list

The arithmetic mean of a set of values is the quantity commonly called “the” mean or the average. It’s simply the sum of all the terms in a list, divided by the number of elements in the list.

Alias for average

Returns the average of the absolute deviations of data points from their mean. It is a measure of the variability in a data set.

Returns the sum of squares of deviations of data points from their sample mean.

Returns the geometric mean.

In mathematics, the geometric mean is a mean or average, which indicates the central tendency or typical value of a set of numbers by using the product of their values (as opposed to the arithmetic mean which uses their sum). The geometric mean is defined as the nth root of the product of n numbers, i.e., for a set of numbers x_1, x_2, …, x_n, the geometric mean is defined as

Returns the harmonic mean

In mathematics, the harmonic mean (sometimes called the subcontrary mean) is one of several kinds of average, and in particular, one of the Pythagorean means. Typically, it is appropriate for situations when the average of rates is desired.

The harmonic mean can be expressed as the reciprocal of the arithmetic mean of the reciprocals of the given set of observations. As a simple example, the harmonic mean of 1, 4, and 4 is

Return the weighted arithmetic mean (average) of the list with the given coefficients

The weighted arithmetic mean is similar to an ordinary arithmetic mean (the most common type of average), except that instead of each of the data points contributing equally to the final average, some data points contribute more than others. The notion of weighted mean plays a role in descriptive statistics and also occurs in a more general form in several other areas of mathematics.

If all the weights are equal, then the weighted mean is the same as the arithmetic mean. While weighted means generally behave in a similar fashion to arithmetic means, they do have a few counterintuitive properties, as captured for instance in Simpson’s paradox.

This function returns the correlation coefficient of two cell ranges.

Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location’s average temperature and the use of air conditioners.

Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.

Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = fisher(x), then inverseFisher(y) = x.

In mathematics, the error function (also called the Gauss error function), often denoted by erf, is a complex function of a complex variable defined as:

Integral of the Gauss function

Computed using:

Returns the median of the given numbers. The median is the number in the middle of a set of numbers.

If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle.

Returns corresponding quantile

In statistics and probability quantiles are cut points dividing the range of a probability distribution into continuous intervals with equal probabilities, or dividing the observations in a sample in the same way. There is one fewer quantile than the number of groups created. Thus quartiles are the three cut points that will divide a dataset into four equal-sized groups. Common quantiles have special names: for instance quartile, decile (creating 10 groups: see below for more). The groups created are termed halves, thirds, quarters, etc., though sometimes the terms for the quantile are used for the groups created, rather than for the cut points.

Linear regression on a set of points

Returns an affine function going through the set of point.

Returns the standard deviation of the list

The standard deviation (SD, also represented by the lower case Greek letter sigma σ for the population standard deviation or the Latin letter s for the sample standard deviation) is a measure of the amount of variation or dispersion of a set of values. A low standard deviation indicates that the values tend to be close to the mean (also called the expected value) of the set, while a high standard deviation indicates that the values are spread out over a wider range.

Computed using:

Returns the variance of the list

In probability theory and statistics, variance is the expectation of the squared deviation of a random variable from its mean. Informally, it measures how far a set of (random) numbers are spread out from their average value.

Computed using: