Excel | Mean (Average) Functions Overview – Types, Formulas, Explanation and Examples

By | 2. 11. 2019

Let’s start with what the average means. In terms of descriptive statistics, the average is a certain reference (typical) value. It is a property of the data set that we are investigating. It belongs to the so-called measures of central tendency. If we have a large amount of data, we can describe the data with some measures of central tendency – this includes different types of means, median, mode, etc. In this article, we will focus on the mean and its types.

Types of Means (Average) and Excel Functions

6 basic types of means describe the data:

  • Arithmetic mean
  • Weighted arithmetic mean
  • Moving average
  • Geometric mean
  • Harmonic mean
  • Quadratic mean
Rate this post
Category: Excel functions

About Jan Zedníček

My name is Jan Zedníček and I work as a freelancer. I have been working as a freelancer for many companies for more than 5 years. I used to work as a financial controller, analyst and manager at many different companies in field of banking and manufacturing. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.