Excel® 2013 On Demand

Using Statistical Functions

You can use statistical functions to help you perform analysis on a group of numbers. You can use formulas to find information, such as MAX or MIN (maximum or minimum value in a list), MEDIAN (median of given numbers), COUNT (number of items in a list), STDEV.S (standard deviation based on a sample), STDEV.P (standard deviation based on the entire population), SKEW (skewness of the distribution), or KURT (kurtosis of a data set). Other (New!) statistical functions include GAMMA, GAUSS (0.5 when less than standard normal cumulative distribution), BIN.DIST.RANGE (probability of a trial result using a binomial distribution), PERMUTATIONA (number of permutation for a given number of objects with repetitions), PHI (density ...