How to Calculate Mean in Excel

The mean, often referred to as the average, is a fundamental statistical measure that represents the sum of a set of values divided by the number of values in that set. In Microsoft Excel, you can easily calculate the mean using the AVERAGE function.

Calculating a mean

Write all the numbers you want to know the mean of, and laid out in the same roll.

excel mean data

To calculate the mean (average) in Microsoft Excel, you can use the AVERAGE function. Click on any blank column and type in =AVERAGE(choose from first to the end ex. A1,A22).

excel mean formula

Mean formula here is: =AVERAGE(A1:A14)

Note: The 85.35714 is the mean of all numbers. It means that this is the average of the numbers in the specified range.

You’ve successfully calculated the mean (average) of a set of numbers in Microsoft Excel using the AVERAGE function.

You can download free Mean Calculator template here

See also  How to calculate covariance in Excel?