Some Excel Worksheet Functions

Part of the Statistical Analysis with Excel For Dummies Cheat Sheet

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.

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 Mode of a set of numbers
MEDIAN Median of a set of numbers
VARP Variance of a set of numbers considered to be a population
VAR Variance of a set of numbers considered to be a sample
STDEVP Standard deviation of a set of numbers considered to be a population
STDEV Standard deviation of a set of numbers considered to be a sample
STANDARDIZE A standard score based on a given mean and standard deviation
Relative Standing
Function What it calculates
RANK Rank of a number in a set of numbers
PERCENTRANK Rank of a number expressed as a percent
PERCENTILE The indicated percentile in a set of numbers
QUARTILE The 1st, 2nd, 3rd, or 4th quartile of a set of numbers
Correlation and Regression
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
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
Statistical Analysis with Excel For Dummies Cheat Sheet

Advertisement

Inside Dummies.com