For anyone dealing with data, understanding statistical functions is a must. They help summarize, analyze, and understand the data in a meaningful way. Spreadsheets provide a wide array of statistical functions, from simple ones like averages and sums to more complex ones like standard deviation and regression analysis. This tutorial explores key statistical functions that can supercharge your data analysis in spreadsheets.


These functions provide central tendency measures of your data. The AVERAGE function calculates the arithmetic mean of a range of cells. The syntax is =AVERAGE(number1, [number2], ...).

The MEDIAN function finds the middle value of a dataset. If the data set has an odd number of observations, the number in the middle is returned. If there is an even number of observations, the average of the two middle numbers is returned. The syntax is =MEDIAN(number1, [number2], ...).

The MODE function returns the most frequently occurring number in a data set. The syntax is =MODE(number1, [number2], ...).

SUM and COUNT Functions

The SUM function adds all given values. The syntax is =SUM(number1, [number2], ...). The COUNT function counts the number of cells that contain numbers and counts numbers within the list of arguments. The syntax is =COUNT(value1, [value2], ...).

MAX and MIN Functions

The MAX function returns the largest value in a set of values. The syntax is =MAX(number1, [number2], ...). The MIN function does the opposite - it returns the smallest value in a set of values. The syntax is =MIN(number1, [number2], ...).

STDEV.P and STDEV.S Functions

These functions calculate the standard deviation of a dataset. Standard deviation is a measure of how spread out numbers are. STDEV.P is used when data represents the entire population. STDEV.S is used when data is a sample of the entire population. The syntax is =STDEV.P(number1, [number2], ...) or =STDEV.S(number1, [number2], ...).

CORREL Function

The CORREL function returns the correlation coefficient between two data sets. The correlation coefficient is a statistical measure that calculates the strength of the relationship between the relative movements of the two variables. The syntax is =CORREL(array1, array2).


The statistical functions in spreadsheets provide users with powerful tools to perform comprehensive data analysis. These functions, when combined, can provide insights into data sets that might not be immediately apparent, such as trends, averages, outliers, and relationships between variables. With practice, you'll find these statistical functions to be an invaluable part of your data analysis toolkit.

Text and images Copyright © Spreadsheet Templates

Use of this website is under the conditions of our Terms of Service.

Privacy is important and our policy is detailed in our Privacy Policy.

See the Spreadsheet Templates Cookie Policy for our use of cookies and the user options available.