• 2. 2. 2020
  • Ing. Jan Zedníček - Data Engineer & Controlling
  • 0

Weighted arithmetic mean is a statistical value of broad use not only in mathematics or statistics. If you need to calculate weighted arithmetic mean in Excel, here is a guide

How Works Function SUMPRODUCT and Weighted Arithmetic Mean in Excel

Example: Lets have few loans where every loan has different principal and interest rate. The task is to calculate average interest rate of loans.

Basic arithmetic mean gives us 9,8% which does not make sense since all loans have different weight (exploitation). Basic arithmetic mean influences last loan only up to 1 000 with high interest rate.

Solution is to use weighted arithmetic mean where the weights is Principal. Function SUMPRODUCT is used to do just that. It will give us the correct rate for the whole loan portfolio.

Rate this post

Ing. Jan Zedníček - Data Engineer & Controlling

My name is Jan Zedníček and I have been working as a freelancer for many companies for more than 10 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.

🔥 If you found this article helpful, please share it or mention me on your website

Leave a Reply

Your email address will not be published. Required fields are marked *