| Function | Description | Example | Result |
|---|---|---|---|
| avedev(list) | The average of the absolute deviations of values from their mean. | avedev(listx) | |
| average(list) | The average of the values of the list. | average(listy) | |
| binomdist(success, trials, probSuccess, formType) | Calculates the probabilities for a binomial distribution. | binomdist(3, 98, 0.04, 0) | 0.2 |
| combin(totalItems, groupSize) | The number of combinations of a subset of items. | combin(52, 5) | 2598960 |
| correl(listx, listy) | The correlation coefficient between two data sets. | correl(listy, listx) | |
| count(list) | The count of the values in the list. | count(listy) | |
| covar(listx, listy) | The covariance of the product of paired deviations. | covar(listy, listx) | |
| devsq(list) | The sum of squares of deviations from the mean. | devsq(listx) | |
| fact(x) | The factorial of a number, n!. | fact(5) | 120 |
| factdouble(x) | The double factorial of a number, n!!. | factdouble(10) | 3840 |
| forecast(xval, listx, listy) | Extrapolates future values based on existing x and y values. | forecast(70,listy, listx) | |
| gamma(x) | The gamma function. | gamma(0.5) | 1.77 |
| gammaln(x) | calculates the natural logarithm of the absolute value of the gamma function of x. | gammaln(0.5) | 0.57 |
| geomean(list) | The geometric mean of the values of the list. | geomean(listx) | |
| harmean(list) | The harmonic mean of the values of the list. | harmean(listx) | |
| intercept(listx, listy) | Calculates the point at which a line will intersect the y values by using known x values and y values. | intercept(listy, listx) | |
| kurt(list) | The kurtosis of the values of the list, a measure of how peaked or flat a distribution is. | kurt(listx) | |
| maxlist(list) | The maximum value of the list. | maxlist(listx) | |
| median(list) | The median of the values of the list. | median(listx) | |
| minlist(list) | The minimum value of the list. | minlist(listx) | |
| mode(list) | The most common value of the values of the list. | mode(listx) | |
| multinomial(list) | The factorial of the sum divided by the product of the factorials. | multinomial(listx) | |
| normdist(x, mean, stdev, mode) | Returns the density function or the normal cumulative distribution. | normdist(70, 63, 5, 1) | 0.92 |
| norminv(x, mean, stdev) | Returns the inverse of the normal cumulative distribution. | norminv(0.9192,63,5) | 70 |
| normsdist(x) | Returns the standard normal cumulative distribution function. | normsdist(1.0) | 0.84 |
| normsinv(x) | Returns the inverse of the standard normal cumulative distribution. | normsinv(0.8413) | 1 |
| permut(objects, elements) | The number of permutations for a given number of objects. | permut(52, 5) | 311875200 |
| product(list) | Multiplies all the values of the list and returns the product. | product(listx) | |
| rand() | Returns a random number between 0 and 1. The example used a seed of 1234. | rand() | 0.22 |
| randbetween(low,high) | Returns an integer random number between and including the integers of the low and high values. | randbetween(1,6) | |
| slope(listx, listy) | The slope of the linear regression line for the lists. | slope(listy, listx) | |
| srand(x) | Seeds the random number generator. The seed is valid until the application quits. Otherwise srandomdev() is called. | srand(-1234.56) | 1234 |
| stdev(list) | The sample standard deviation of the values of the list. | stdev(listy) | |
| stdevp(list) | The population standard deviation of the values of the list. | stdevp(listy) | |
| sum(list) | Sum of the values of the list. | sum(listx) | |
| sumprod(list, list) | The sum of the products of the values of the lists. | sumprod(listy, listx) | |
| sumsq(list) | The sum of the squares of the values of the list. | sumsq(listx) | |
| var(list) | The sample variance of the values of the list. | var(listy) | |
| varp(list) | The population variance of the values of the list. | varp(listy) |