Calculate the average in Excel – that’s how it works!

Excel’s average is an important and useful function that helps you analyze medium performance, the trend or development of data. In this blog article you will discover everything you need to know about Excel’s average, from calculation to different species. You will also receive some practical suggestions and suggestions on how to effectively use Excel’s average.

How to calculate the average at Excel

The media function calculates the arithmetic means of a series of numbers specified as topics. The topics They can be numbers or covers for cells that contain numbers. Text, values ​​of truth and empty cells are ignored, but 0 is counted.

In order to calculate the average at Excel, it is possible Formula = Media (Number1: Number2) use. An example would be = medium (A1: A10) if the average value must be determined in the A1 area: A10.

You can also proceed as follows: first of all, select a cell in which the result should appear and write = media. The parenthesis comes right (now you can Report the cellsOf those who mean having before closing the bracket again). Finally, press sending and you’re done.

If a topic contains an error value or text that cannot be converted into a number, the function returns an error. In order to treat the truth values ​​and text as numbers, you can use the average function. In order to calculate the average of the numbers that meet certain conditions, the functions can Average or average value be used.

How can the average value in Excel be interpreted?

The average in Excel gives you an indication of the central trend of a series of data. Show them like them The data are distributed by a central value. The more the data are closer to the average, the lower the spread or the variability of the data. The more the data are from the average, the greater the dissemination or variability of the data.

The average in Excel can also help you recognize trends or models in data. For example, you can Calculate and compare the average for different periodsTo see if the extraordinary data are closed or decreased. Or you can calculate and compare the average for different groups or categories to see if there are significant differences between groups.

I notify: The average in Excel is only one of the many possible dimensions for the central trend of a series of data. Other dimensions are z. B. the median or mode. The median is the median value of a series of ordered data, the most common value mode of a series of data. Depending on the distribution and the type of data, it may make sense to use one of this dimensions rather than the average value.

How do you adapt the average in Excel?

As already mentioned, there are different types of average values ​​that can be used according to the situation. By default, the average function calculates the arithmetic means of a series of data, ie All numbers are immediately weighted. However, there are situations where you want to use geometric means, harmonious half or weighted means.

The geometric means are the Radice N-TE from the product of all numbers. It is often used to calculate medium rates such as growth rates or interest rates. To calculate the geometric means in Excel, you can Formula = geomettel (number 1; number2; …) use.

The harmonious medium is the reciprocity of arithmetic through the mutual values ​​of all numbers. It is often used to calculate the average values ​​if the numbers are expressed as quotients, such as: B. speed or conditions. In order to calculate harmonious half of excel, the formula is recommended = Annoying (Zahl1; Zahl2; …).

The weighted agent is the arithmetic medium in which each number is multiplied by a certain weight. It is often used to calculate the average values ​​if the Have different importance or relevanceLike B. Gradi or prices. To calculate the weighted average in Excel, turn the formula = Som Product (Numbers; Ponderation)/Somma (weighting) A.

On purpose: Arithmetic means, geometric means and harmonious half are in a certain mutual relationship. For each series of positive data, the harmonious remedy is smaller or equal to the geometric means, which in turn is smaller or equally the arithmetic agent. This relationship is called Hölder’s inequality.

How can the average be displayed in Excel?

Another way to use the average in Excel is to view it. You can do the average as a line or point in a diagramTo compare it with the actual data. This can help you recognize deviations, abnormal values ​​or data trends.

To view the average in Excel, you must first have one Create diagram with your data. To do this, mark the data and click on Inserts> Recommended diagrams. Then select the type of diagram suitable for your data, e.g. B. A line diagram, a column diagram or a dispersion diagram.

Let’s take that Example of column diagram: First of all, add a new column to your table in which calculations the average of the Y values. Then expand your new column by moving in the marking of the data series. Now click on the new columns and change the type of diagram in line so that it is no longer shown as a pillar.

I notify: If you want to view the average in a diagram, you should also make sure that the letters of the axis and the legend are clear and understandable. You should also add a suitable header and a brief description for the diagram to explain to the reader what the diagram shows and what the meaning means.

A useful function

The average in Excel is a versatile and powerful function that offers you many ways to analyze and present your data. In this blog article we showed you how you can calculate, interpret, adapt and view the average in Excel.