How to calculate the weighted average

1 year ago
3

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

Loading comments...