- We shifted, uneventfully that is. New house is demanding a considerable amount of travel, add to it lack of internet, that should explain the reason for nopost days.
- My plans for CalvinFund have taken a neat shape and currently the unbooked profits stand at 4-5%. But I am going to stop it and buy the book instead, thanks to my savings from the weeklong trip to Ireland.
- Office work has been hectic in a different way. I am trying to juggle along.
- Suddenly I am having difficulty in blogging, as if some monster under my bed is sucking away the creative juices when I am snoring. May be time for a break?
Weighted Average in Excel [Formulas]
Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.
What is weighted average?
Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”
Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.