From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

# AVERAGE function MS Excel

### What is AVERAGE function in Excel?

The AVERAGE function in Excel calculates the average of a set of values. It takes the sum of the values and divides it by the number of values in the list. The result of the function is the average of the values.

### Description

The AVERAGE function in Excel calculates the average of a set of numbers. It is a simple and useful tool for totaling up values quickly and easily. The function can be used to quickly find the mean of a set of numbers. Calculate the average of a range of values or a specific set of numbers, such as a subset of a larger dataset.

The function is beneficial because it allows users to quickly calculate an average without having to manually add up each value. Additionally, it can be used to quickly compare different subsets of data and identify differences or correlations between them.

### AVERAGE Function Syntax

=AVERAGE(number1, number2, …) ### How to use AVERAGE function MS Excel in your workbook:

1. Open the Excel file containing the data you want to calculate.
2. Select the cells.
3. Click theHome tab in the ribbon at the top of the window.
4. Select theAverage icon in theEditing section of the ribbon.
5. TheAverage dialog box appears on the screen.
6. Verify that the correct cells are selected.
7. Select theOK button to apply the formula.
8. The average of the selected cells will be displayed in the cell where the formula was applied.

How to calculate AVERAGE function on Excel?
1. Enter your data into a column in Excel.
2. Select the data you want to find the average of.
3. Click the “Insert” tab, then click “Function” in the “Formulas” group.
4. Select “Average” from the drop-down list.
5. Click “OK” to insert the AVERAGE function.
6. The average of the selected data will be displayed in the cell.
Where is AVERAGE used for?

Average is used to measure the central tendency of a set of data. It is used in statistics, mathematics, and finance to quantify the average or central value of a set of data points, such as the mean, median, and mode. It is also used to calculate the average of two or more numbers, or to compare different sets of data.