Average Calculator


'fa-times' | icon

[[translations.addRow]]


[[translations.average]]

calculatedAverage | number_format

In many different situations in life, you'll find yourself needing to calculate an average. Whether that be in a professional, school or personal capacity, calculating an average is a common math operation.

Are you looking for an online average calculator? Then look no further!

Thanks to our average calculator, you do not have to worry about working equations out in your head. With our tool, there is no risk of making a mistake. In addition, you will also find out information guide to answer all your questions about calculating averages.

How to find an arithmetic mean?

The arithmetic mean (also known as a simple mean) is the most commonly used way to calculate an average. This average is calculated by adding together the numerical values of a series of numbers, then dividing this answer by the amount of numbers there are. The equation is therefore as follows:

Good to know

Arithmetic mean = Sum of values / Total number

For example:

A class of 4 students receive the following grades in history:

SarahTomEmmaAymeric
15121411
Example of simple mean calculation

To calculate the average grade for the class, you would do:

(15+12+14+11) = 52 52/4 = 13

The arithmetic mean for the class's grade is 13.

Good to know

While you're here, do you want to calculate your gross net salary? Go to our tool to help you do just that!

How does our stastical average calculator work?

Using our average calculator is very simple.

For arithmetic mean, you just need to enter the values you want to average in the available boxes. This will give you the averages of all values.

For a weighted average, you must also enter the values you want to get the average for in the boxes provided. You must also enter their respective coefficients. In the end, you will get an average taking into account the weighting you gave each grade.

How to do an average calculation with a coefficent?

To calculate an average with a coefficient (also known as a weighted average), simply use our calculator tool found at the top of this page. However, to better understand how it works, go to the next section of this page.

Good to know

To calculate the number of days between two dates, use our easy and free tool!

How to calculate a grade point average?

Calculating a weighted average or a cumulative grade point average involves using a coefficient to give a "weight" to each score. Generally used in a high school or university situation, a cumulative weighted average takes into account a student's grades across all their classes. This allows for the calculation of their overall grade, and final GPA (grade point average).

The equation for calculating a weighted average is as follows:

Good to know

Weighted average = sum (values x their respective coefficient number) / sum of coefficient numbers

Example:

Juliette wants to calculate her overall average. Here are her scores and their coefficients:

SubjectCreditsCoefficent
Math114
History63
Sports152
Science173
Example of GPA calculations

GPA = (11 x 4) + (6 x 3) + (15 x 2) + (17 x 3) / (4 + 3 + 2 + 3) = 143 / 12 = 11,92

How to does calculating an average in Excel work?

To calculate arithmetic means in Excel, you must have an indicated function.

The calculation of arithmetic means is done with the =AVERAGE function. For example, to calculate an average of numbers located in calls A1 through to A20, you would need to select that entire range of cells after entering =AVERAGE (in the function bar above the table). Be sure to close the parenthesis so that the formula is valid.

When it comes to calculating a weighted average, you have several options.

Firstly, you can take the weighted average formula shown earlier up the page, and simply replace the values with the call numbers that correspond to them. Therefore, you need to create a table in Excel; one column for the values and the other for the corresponding coefficients.

You can also use the formulas =SUMPRODUCT and =SUM. You then have to enter the different matrices, being careful that they are all the same size.

As you can see, these are not necessarily the easiest ways to work out an average calculation. So why not use our average calculator at the top of this page?

An expert will respond
Your name is required
Comment's content is required.