Statistical Functions
| AVEDEV(number1,number2,…) | Returns the average of the absolute deviations of data points from their mean. |
| AVERAGE(number1,number2,…) | Returns the average of its arguments. |
| AVERAGEA(value1,value2,…) | Returns the average of its arguments, including text and logical values. |
| BETADIST(x,alpha,beta,A,B) | Returns the cumulative beta probability density function. |
| BETAINV(probability,alpha,beta,A,B) | Returns the inverse of the cumulative beta probability density function. |
| BINOMDIST(number_s,trials,probability_s,cumulative) | Returns the individual term binomial distribution probability. |
| CHIDIST(x,degrees_freedom) | Returns the one-tailed probability of the chi-squared distribution. |
| CHIINV(probability,degrees_freedom) | Returns the inverse of the one-tailed ... |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
