# Some Excel Worksheet Functions for Statistical Analysis

Excel can help you make all sorts of calculations. Here’s a selection of Excel’s statistical worksheet functions. Each one returns a value into a selected cell.

Check out these functions for central tendency and variability.

Function | What it calculates |

AVERAGE | Mean of a set of numbers |

AVERAGEIF | Mean of a set of numbers that meet a condition |

AVERAGEIFS | Mean of a set of numbers that meet one or more conditions |

HARMEAN | Harmonic mean of a set of positive numbers |

GEOMEAN | Geometric mean of a set of positive numbers |

MODE.SNGL | Mode of a set of numbers |

MEDIAN | Median of a set of numbers |

VAR.P | Variance of a set of numbers considered to be a population |

VAR.S | Variance of a set of numbers considered to be a sample |

STDEV.P | Standard deviation of a set of numbers considered to be a population |

STDEV.S | Standard deviation of a set of numbers considered to be a sample |

STANDARDIZE | A standard score based on a given mean and standard deviation |

These handy functions for relative standing can also be very useful.

Function | What it calculates |

RANK.EQ | Rank of a number in a set of numbers. If more than one number has the same rank, it returns the top rank of those numbers. |

RANK.AVG | Rank of a number in a set of numbers. If more than one number has the same rank, it returns their average. |

PERCENTRANK.INC | Rank of a number in a set of numbers, expressed as a percent of the numbers it’s greater than or equal to. |

PERCENTRANT.EXC | Rank of a number in a set of numbers, expressed as a percent of the numbers it’s greater than. |

PERCENTILE.INC | The indicated percentile in a set of numbers, in terms of “greater than or equal to.” |

PERCENTILE.EXC | The indicated percentile in a set of numbers, in terms of “greater than.” |

QUARTILE.INC | The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of “greater than or equal to.” |

QUARTILE.EXC | The 1st, 2nd, 3rd, or 4th quartile of a set of numbers, in terms of “greater than.” |

These functions for correlation and regression are also good ones to know.

Function | What it Calculates |

CORREL | Correlation coefficient between two sets of numbers |

PEARSON | Same as CORREL. (Go figure!) |

RSQ | Coefficient of determination between two sets of numbers (square of the correlation coefficient) |

SLOPE | Slope of a regression line through two sets of numbers |

INTERCEPT | Intercept of a regression line through two sets of numbers |

STEYX | Standard error of estimate for a regression line through two sets of numbers |