# How to Calculate Average or Mean in Excel

Calculating the mean, or average, of a data set is actually pretty easy. You just add all the values of the data, and then divide that sum by the number of data points. This can be a challenging task if the data consists of a large amount of numbers. In those cases you can use `Excel` to do the job for you.

`Excel` Instruction

### CalculatingtheMean

1.
Input the data in `Excel`.
2.
Click a nearby empty cell where you want the mean value to be shown. Write

=AVERAGE(

3.
Then mark all the numbers of the data and press `Enter`.

Example 1

Below, you can see an overview of how many pieces of candy eight of the students in a class ate this weekend:

 $10,15,8,16,3,4,0,24$

Find the mean of this data.

1.
First you enter all the data values in `Excel`, into individual cells.
2.
Then you enter the formula for finding the mean in an empty cell. Write

=AVERAGE(

3.
Then you highlight the cell range containing your data and press `Enter`. Simple as that!

The result is:

From `Excel` you see that the mean amount of candy eaten this weekend is 10 pieces.

Want to know more?Sign UpIt's free!
Next entry
How to Find Mean of Grouped Data in Excel

Economy
Statistics