Level 18 Level 20
Level 19

Statistical functions - Part 3


30 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
PERMUT
Returns the number of permutations for a given number of objects
POISSON.DIST
Returns the Poisson distribution
PROB
Returns the probability that values in a range are between two limits
QUARTILE.EXC
Returns the quartile of the data set, based on percentile values from 0..1, exclusive
QUARTILE.INC
Returns the quartile of a data set
RANK.AVG
Returns the rank of a number in a list of numbers
RANK.EQ
Returns the rank of a number in a list of numbers
RSQ
Returns the square of the Pearson product moment correlation coefficient
SKEW
Returns the skewness of a distribution
SLOPE
Returns the slope of the linear regression line
STANDARDIZE
Returns a normalized value
STDEV.P
Calculates standard deviation based on the entire population
STDEV.S
Estimates standard deviation based on a sample
STDEVA
Estimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPA
Calculates standard deviation based on the entire population, including numbers, text, and logical values
STEYX
Returns the standard error of the predicted y-value for each x in the regression
T.DIST
Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.2T
Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.RT
Returns the Student's t-distribution
T.INV
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
T.INV.2T
Returns the inverse of the Student's t-distribution
TREND
Returns values along a linear trend
TRIMMEAN
Returns the mean of the interior of a data set
T.TEST
Returns the probability associated with a Student's t-test
VAR.P
Calculates variance based on the entire population
VAR.S
Estimates variance based on a sample
VARA
Estimates variance based on a sample, including numbers, text, and logical values
VARPA
Calculates variance based on the entire population, including numbers, text, and logical values
WEIBULL.DIST
Returns the Weibull distribution
Z.TEST
Returns the one-tailed probability-value of a z-test