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
.jpg)
Comments
Post a Comment