Learn More:- https://www.exceltutorial.net/videos/133/weighted-average/

🧑‍🏫 Statistical Functions Playlist:- https://youtube.com/playlist?list=PLhvn6aQRdimWkjAu5tBtC37DayKJ_mWg1

In this video we will learn how to calculate weighted Average in excel using SUMPRODUCT and SUM function in excel.

The SUMPRODUCT function in Excel calculates the product of all the arrays passed to it as arguments. The SUM function in Excel simply adds up all the numbers passed to it as arguments.

In our example, we will have two arrays: one with student grades and another with the weights associated with those grades. We want to find the weighted average of the grades.

Write an article about how weighted average is a way of combining grades from different courses. Let's say you want to calculate your GPA using weighted average, but you have taken four college level courses and two high school level grades.

Using weighted average, the grades from each course are added together and then each grade is assigned a weight or value. The weighted average is then calculated by multiplying each grade by its weight and then adding together all of the weighted grades.

Table of Content; 00:00 Introduction 01:00 Weighted Average in Excel 05:30 Conclusion

Other Playlists:-

Financial Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimU1umiFNnQrVugsq_TJ6LDD

Cell References in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVC65nzr2BebSN9kPSdK6qH

Logical Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimWBCKHNrLEqubXDMaHeINU1

Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW

Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz ... https://www.youtube.com/watch?v=zvuoUIgO-VI