Statistical functions
This list contains predefined summary functions of statistical nature.
- corr
Returns the coefficient of correlation of a set of number pairs. This is computed as follows: COVAR_POP(numeric_expression1, numeric_expression2) / (STDDEV_POP(numeric_expression1) * STDDEV_POP(numeric_expression2)) - covariance-pop
Returns the population covariance of a set of number pairs. - covariance-samp
Returns the sample covariance of a set of number pairs. - regression-average-x
Returns the average of the independent variable (numeric_expression2) of the regression line. - regression-average-y
Returns the average of the dependent variable (numeric_expression1) of the regression line. - regression-count
Returns the number of non-null numbers used to fit the regression line. - regression-intercept
Returns the y-intercept of the regression line. This is computed as follows: AVG(numeric_expression1) - REGR_SLOPE(numeric_expression1, numeric_expression2) * AVG(numeric_expression2) - regression-r2
Returns the coefficient of determination (also known as "R-squared" or "goodness of fit") of the regression line. This value is computed based on the following conditions: IF VAR_POP(numeric_expression2) = 0 THEN NULL IF VAR_POP(numeric_expression1) = 0 AND VAR_POP(numeric_expression2) <> 0 THEN 1 IF VAR_POP(numeric_expression1) > 0 and VAR_POP(numeric_expression2) <> 0 THEN POWER(CORR (numeric_expression1, numeric_expression2)) - regression-slope
Returns the slope of the regression line. This is computed as follows: COVAR_POP(numeric_expression1,numeric_expression2) / VAR_POP(numeric_expression2) - regression-sxx
Returns the following computation after eliminating NULL pairs: REGR_COUNT(numeric_expression1, numeric_expression2) * VAR_POP(numeric_expression2) - regression-sxy
Returns the following computation after eliminating NULL pairs: REGR_COUNT(numeric_expression1, numeric_expression2) * COVAR_POP(numeric_expression1, numeric_expression2) - regression-syy
Returns the following computation after eliminating NULL pairs: REGR_COUNT(numeric_expression1, numeric_expression2) * VAR_POP(numeric_expression1) - standard-deviation
Returns the standard deviation of selected data items. - standard-deviation-pop
Computes the population standard deviation and returns the square root of the population variance. - standard-deviation-samp
Computes the sample standard deviation and returns the square root of the population variance. - variance
Returns the variance of selected data items. - variance-pop
Returns the population variance of a set of numbers after discarding the nulls in this set. - variance-samp
Returns the sample variance of a set of numbers after discarding the nulls in this set.
Parent topic: Summaries