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