Like this? Feel free to share / copy / exploit / save the cartoon. See other powerpoint cartoons as well
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.
2 Responses to “on vlookup()”
Hi Chandoo,
Can u pls send me the font used in text in the above cartoon. Pls send the font to sumeet_ivy@yahoo.com and sumeet_soft@yahoo.com. I liked the font and I want it.
[...] [originally posted on 5th May 2008] [...]