| F.DIST | Returns the left-tailed F distribution for two data sets | F.DIST(x, deg_freedom1, deg_freedom2, cumulative) |
| F.DIST.RT | Returns the right-tailed F distribution for two data sets. | F.DIST.RT(x, deg_freedom1, deg_freedom2) |
| VAR | Returns the variance for a sample of numbers | VAR(value1, [value2, ...]) |
| VARA | Returns the variance for a mixed sample | VARA(value1, [value2, ...]) |
| VARPA | Returns the variance for the entire population | VARPA(value1, [value2, ...]) |
| CORREL | Returns the Pearson correlation coefficient between two data sets | CORREL(data_X, data_Y) |
| LINEST | Returns the parameters of a straight line that passes closest to all available data points using the least squares method | LINEST(known_data_y, [known_data_x], [b], [stats]) |
| MAX | Returns the largest value in a set of numbers | MAX(value1, [value2, ...]) |
| MEDIAN | Returns the middle of a set of numbers | MEDIAN(value1, [value2, ...]) |
| MIN | Returns the smallest value in a set of numbers | MIN(value1, [value2, ...]) |
| MODE | Returns the most frequent value in a group of numbers | MODE(value1, [value2, ...]) |
| LARGE | Returns the Nth largest value in a set of numbers | LARGE(set, N) |
| SMALL | Returns the Nth smallest value in a set of numbers | SMALL(set, N) |
| NORM.DIST | Returns the cumulative distribution function value or probability density value for a given x, mean, and standard deviation | NORM.DIST(x, mean, standard_deviation, cumulative) |
| RANK.EQ | Returns the rank of a number relative to other numbers in a range or array | RANK.EQ(number, range, [order]) |
| AVERAGE | Returns the arithmetic mean of the numbers | AVERAGE(value1, [value2, ...]) |
| AVERAGEIF | Returns the arithmetic mean of the values that meet the given criterion | AVERAGEIF(range, criterion, [average_range]) |
| STDEV.S | Returns the standard deviation for a sample of values | STDEV.S(value1, [value2, ...]) |
| COUNT | Returns the number of values in a dataset | COUNT(value1, [value2, ...]) |
| COUNTIF | Returns the number of values that meet the specified criterion | COUNTIF(range, criterion) |
| COUNTIFS | Returns the number of values that meet all specified criteria | COUNTIFS(criterion_range1, criterion1, [criterion_range2, criterion2, ...]) |
| COUNTA | Returns the number of non-empty cells in a dataset | COUNTA(value1, [value2, ...]) |
| COUNTBLANK | Returns the number of empty cells in a given range | COUNTBLANK(range) |
| FISHER | Returns the Fisher transformation of a specified value | FISHER(value) |