# How to calculate mean median and mode in Excel

You can watch a video tutorial here.

In statistical analysis, you will frequently need to summarize the data that you are studying. This includes finding out metrics such as the mean, median, and mode that gives you an idea of the nature of the data.

In Excel, you can find the mean, median, and mode by using the Data Analysis tool or by using the following functions.

1. AVERAGE(): this returns the mean of a set of numbers
• Syntax: AVERAGE(range)
• range: the range or set of numbers
2. MEDIAN(): this returns the median or the middle of a set of numbers
• Syntax: MEDIAN(range)
• range: the range or set of numbers
3. MODE.SNGL():  this returns the mode or the most frequently occurring number of a set of numbers
• Syntax: MODE.SNGL(range)
• range: the range or set of numbers

## Option 1 – Use the Data Analysis tool

Note: If the Data Analysis button is on the Data > Analyze ribbon, then skip Steps 1 to 3 below.

### Step 1 – Open the Excel Options window

• Go to File > Options

### Step 2 – Manage the Add-ins

• Select Excel Add-ins from the Manage drop-down
• Click Go

• Select Analysis ToolPak
• Click OK

### Step 4 – Open the Descriptive Statistics window

• Go to Data > Analyze
• Click on the Data Analysis button
• In the window, select Descriptive Statistics
• Click OK

### Step 5 – Set the parameters

• Define the input range:
• Input Range: the range of the ‘Height (cm)’ column
• Tick Labels in first row
• Output Range: where the result is to be displayed
• Tick Summary Statistics
• Click OK

### Step 6 – Check the result

• The descriptive statistics are displayed for the dataset
• The Mean, Median and Mode are part of the statistics

## Option 2 – Use the functions

### Step 1 – Find the mean

• Select the cell where the result is to be displayed
• Type the formula using cell references:

=AVERAGE(Height (cm))

• Press Enter

### Step 2 – Find the median

• Select the cell where the result is to be displayed
• Type the formula using cell references:

=MEDIAN(Height (cm))

• Press Enter

### Step 3 – Find the mode

• Select the cell where the result is to be displayed
• Type the formula using cell references:

=MODE.SNGL(Height (cm))

• Press Enter

### Step 4 – Check the result

• The mean, median, and mode are displayed
• They match the values given in the Descriptive Statistics