How To calculate Weighted Averages in Excel

In this video I explain how to calculate a weighted average in Excel.
The formula is very simple:
sumproduct(values_array,weights_array)/Sum(weights_array).
Check out my video on how to do the same thing in r, which is much easier: • How to calculate weigh...
Let me know if you have any questions, comments or requests.
I'll try and upload the example video as soon as i can :)

[@jennaspier3158]

This video just saved my entire homework assignment! I could not figure out how to do this, no matter where I looked, including on the Microsoft support website! Thank you sooooo much for this video. You totally saved my grade!

[@simplyexcel5251]

Yay :) happy it helped. let me know if you have any ideas for other videos that can be helpful

[@jimeverette3588]

This is exactly the way to show how to do a function. simple and fast. Great Job!

[@leahcopeland5561]

Just what I needed & straight to the point. Thanks!!!

[@1018ckitt]

gosh, thank you. I didn't need all the other 15 minute videos to not give me the formula.
A+++++

[@simplyexcel5251]

1018ckitt thanks! let me know if there are other topics you'd like short videos on. The channel is kinda dead, but i'm looking to start again.

[@Jacomko]

Subscribed, you Sir deserves the internet

[@simplyexcel5251]

Thank you :) !

[@tommunro1168]

Thanks, exactly what i was looking for.

[@uj313]

Thanks.. its short and efficient formula :)

[@elvindeleon4274]

Hi, what if one of the values intends to be low i.e. lower the better. For example, the second row in your example pertains to 'number of errors'. in that case the lower value you get the better. how do you calculate this in the weighted average together with all others that goes for higher numbers?

[@asifrazzaq5937]

Great Help, Thank you so much :)

[@armani_chosen4209]

Thanks a lot, this really helped me in my six sigma project

[@thearchdeacon]

Done in 46 seconds. Thanks

[@iztirabk5135]

Waow SimplyExcel well done, we need simple and easiest way as you did....

[@simplyexcel5251]

Thank you!
is there any other specific you'd like to see a video on?

[@Robertpemz]

How it can be applied for rank weight for instance a value

[@nitzanpincu7477]

excellent. thanks! :)

[@joseluiscarreno5682]

Claro, preciso y conciso...Gracias

[@simplyexcel5251]

+JoseLuis Carreño Thank you for the comment :)

[@rubenhuertagranados1549]

Good video, just what i want to know, not like other videos of 15 minutos to explain the same.
Thanks

[@jasonspurlock2332]

Save rate 35% loyalty 35% voc 20% mob 20%. How would I find the balance score for these metrics ?

[@goldlionist]

Hi. Thanks for the video!
But, I have a simple doubt regarding ranges.
If instead of definite values, I had a range of values (income range), and the weights (% respondents within that range) were for the range, how could I find the weighted average in this case?
Thanks!

[@simplyexcel5251]

+Jyotsna Gupta Hi! Thanks for you comment.
This is a tricky question, since in this case you don't really have all the data. You only have categorical data of the ranges. So an actual mean is pretty impossible to calculate. the proper thing to do would be just give each of the category an order value (like 1 for the lowest, and 5 for the highest..assuming there are only 5), and then calculate it the same.
It's important to notice that the only thing you'll be able to infer is which category has the mean, and not the actual mean...

[@goldlionist]

Thanks for this :)

[@elisalocurcio8531]

Hi Jyotsna, can you calculate the % value, calculate the total of the range and then the total of the weights, and then calculate the percentage report between the two?

[@wubayehualemu7959]

so how can i calculate weight average of soil nutrient in soil profile?

[@francischitsika7947]

thanks so much

[@dinalynannrosal4223]

is it the value is per pc?

[@Subweesh]

The weight i have is Percentage, how can i do it?

[@XRAYTID]

So a bit more complex of a weighing that I need and I have struggled with it for a while.
I basically have two separated weighted categories which each have 3 internal weighted categories but everything combines for one single score. I could not get the sum product function to align with the answer that populates from our automatic dashboard system .
Example:
Total percentage of score is 100% broken into two main categories at 70 and 30 percent
Category 1: 70% weight
Sub Category 1 weight: 40% of the total 70%
Sub Category 2 weight: 35% of the total 70%
Sub Category 3 weight: 25% of the total 70%
Category 2: 30% weight
Sub Category 1: 33.3% of the total 30%
Sub Category 2: 33.3% of the total 30%
Sub Category 3: 33.3% of the total 30%

[@lavanyaks3826]

How to add secondary axis in excel charts

[@lamyaalmousa]

How to calculate the weights??

[@ashwinrebbapragada7626]

Thanks.

[@guyfox113]

When I highlight an array the function returns #NAME

[@tonystork6708]

This is supposed to work. I dunno why there is an error with my work when percentages are multiplied with whole numbers.