Weighted Average with the SUMPRODUCT Function in Excel - Weighted Mean

How would you calculate weighted percentile scores? Can this be done?

Hi.. I need help. I need to calculate the final mark between 2 papers. Paper 1 40 marks for 50%. Paper 2 60 marks for 50%. I used the formula in the video but get 131% in total instead of 100%. Could you help me out please?

Life Saver bro

I didn't get one point. At the end, you divided sumproduct function by sum of the weights which are always 100%. We know that dividing something with 100% we will get the same thing. Then why did you put the total of weights in the denominator of the fraction?
Thanks in advance!

I have been assigned some tasks by one of my professors. And what you have shown and explained in the video is exactly what I need. Thanks for saving me as the deadline is approaching! Thank you so much!

THANK YOU!!!! SO helpful. Appreciate it

I studied and immediately applied in my work. Love it. Many thanks. :)

Hey i wanna learn how to find price of something in different weight like example 1k of apple is 1$ but need to determine price of 300g using excel

What if you have hidden cells? how do you doge those?

Character In the video It's great, I like it a lot $$

Never thought I would meet Kuro here teaching us about weighted average 🤣🤣🤣

please show Beta distribution

Super useful! You saved my afternoon! Thank you!!!!!!!!!!

Thanks

My problem for the weighted average of steel indices as shown in our agreement - like this : -
(iii) Adjustment for Steel Component
Price adjustment for increase or decrease in the cost of Steel procured
by the contractor under different schedules of BOQ shall be paid in
accordance with the following formula:
Formulae-I (for all schedules of BOQ except bill/schedule-2 B & 2
C):
Vs = Ps / 100 X RI X (S1-S0) / S0
Vs = Increase or decrease in the cost of work on the date under
consideration due to changes in the rates for Steel.
S0 = The weighted average of index Numbers of Wholesale
Prices in India by Groups and Sub Groups (Averages) for
(i) MS Bright Bars under Mild Steel -Long
Products sub-group (weight=1)
(ii) Angles, Channels, Sections, steel
(coated/not) under Mild Steel -Long Products
sub-group (weight=2)
(iii) Mild Steel - Flat products sub-group
(weight=1)
published in RBI (Reserve Bank of India) Bulletin / website of the
office of the Economic Adviser in the month on the day 28 days
prior to the closing date of submission of Bids.
S1 = The weighted average of index Numbers of Wholesale Prices
in India by Groups and Sub Groups (Averages) for
(i) MS Bright Bars under Mild Steel - Long Products subgroup
(weight=1)
(ii) Angles, Channels, Sections, steel (coated/not) under
Mild Steel - Long Products sub-group (weight=2)
(iii) Mild Steel - Flat products sub-group (weight=1)
published in RBI (Reserve Bank of India) Bulletin / website of the office
of the Economic Adviser in the month on the day 28 days prior to the
last day of the period to which a particular interim payment certificate is
related.
Ps = Percentage of Steel component of the work.
BASE DATE IS 25 MARCH'2019)

Hope you will understand it properly and will give proper solution that how to get "weighted average of MS Bright Bar, e-Mild Steel - flat product and Angle channels ..)
bs negi

👌👌

I use this all the time as a mine engineer to calculate copper grades.

how to explain something in four minutes what my excel book tried to do with 15 pages: ^

Thank you so much. This was super important for us when it came down to my daughter’s grades. You made it all so clear. 🤓

Dumb vidoe

Christian Bale?

"Average.weighted" function is enough for me.

Please make videos on Primavera P6 schedule development to till its completion for a project.

No need to divide by the sum of the weights because the weights are percentages.

Thanks, Man, it is helpful

This only works if %100 of assignments have already been submitted. You need to be using SUMIF instead of SUM in the denominator to factor in pending assignments. =SUMPRODUCT(C4:C8,D4:D8)/SUMIF(C4:C8,">=0",D4:D8). I get that this is a tutorial, but using SUM is just plain lazy and asking for careless mistakes.

Great vid! Is there a way I can add an additional element for calculating remaining grade average needed. E.g. Ass 3 and 4 haven't been completed yet...

nice video, helpful

Such a powerful function

Love your teaching! simple and short. looking forward to more of your videos bro.

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%

I use the weighted average allt the time as a business controller because it is often more relevant than the usual average in our business. The way you demonstrate it's use is much more efficient than my way so thank you! It really helps :-)