How to calculate the weighted average


 






Hello, My Dear Friends, !! In this video, I will show you how to calculate the weighted average. Watch the video till the end Thanks.


Here,s how to calculate the weighted average :

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Step 1: To calculate the weighted average in Excel, you must use the SUMPRODUCT and SUM functions using the following formula: =SUMPRODUCT(X:X, X:X)/SUM(X:X) This formula works by multiplying each value by its weight and combining the values.


Chapters: 

0:00  Introduction 

0:12  Calculate the weighted average in Excel 

1:43  Happy Ending


Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel.


#initial #solution #calculate #weighted #average








 

Comments

Popular posts from this blog

How to change your youtube email