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.
What is the average speed of this road trip? [Solution & Discussion]
Last week, we had an interesting homework problem – What is the average speed of this road trip?
We received more than 150 answers. But to my surprise, 57 of them are wrong. So today, lets learn how to calculate the average speed correct way.
CP007: aweSUM() – Overview of SUM functions in Excel
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 7th session of Chandoo.org podcast, lets make you aweSUM().
Imagine for a second that Excel cannot add up numbers. And no it cant subtract them either. What would that look like?
A glorified Notepad. That’s right. Excel’s ability to add up numbers, along with features like formulas, charts, pivot tables & BHATTEXT() are what make it such a lovely software. May be not the BHATTEXT(), but we all agree that Excel is so versatile and useful because it can add up numbers (and perform other calculations) with ease.
But how well do you know the SUM formulas of Excel?
In this podcast, you will learn,
- Special personal fruit announcement 😛
- + operator
- Status bar & total rows in tables
- Auto Sum feature
- SUM() function
- SUMIFS function
- Special cases of SUMIFS function
- SUBTOTAL & AGGREGATE functions
- Other summing functions – SUMPRODUCT etc.
Formula Forensics 022. Sum the Odd Numbers between 1 and 100
How can we Add Up the Odd numbers between 1 and 100 ?
Formula Forensics. No 007 – Sumproduct
One of the most asked questions within the posts and Forums at Chandoo.org is, How Does Sumproduct work ?
Today in Formula Forensics we take at look at just that with a few worked examples.
Formula Forensics No. 002 – Joyces Question
Formula Forensics # 002 – Joyces Question
This is the second post of a new regular weekly series at Chanoo.org, Formula Forensics, where we will examine how a formula works from the inside out with a worked example to help you understand its formation.
Last week we looked at Taruns problem and analysed a formula to solve his problem
This week we look at Joyce’s Problem…
Sum of Values Between 2 Dates [Excel Formulas]
Lets just say, you run a nice little orange shop called, “Joe’s Awesome Oranges“. And being an Excel buff, you record the daily sales in to a workbook, in this format. After recording the sales for a couple of months, you got a refreshing idea, why not analyze the sales between any given 2 dates? […]