How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT) -  Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Learn how to calculate weighted average in Excel (Using the Function SUMPRODUCT). Or how Do you calculate a weighted average? I will also answer, how do I calculate weighted average in Excel for two columns? And what is the formula for some product in excel?   Here are the formulas outline in the video.   Calc Weighted Average (slow method)  =C5*$C$2+D5*$D$2+E5*$E$2+F5*$F$2   Calc Weighted Average (fast method)  =SUMPRODUCT(C5:F5,$C$2:$F$2)    How do you calculate a weighted average?,How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT),How do I calculate weighted average in Excel for two columns?,What is the formula for the SUMPRODUCT in Excel?,

Transcript

00:00The conventional way to calculate the weighted average mark will be equal

00:03midterm multiplied by weight of the midterm press F4 to make the cell into

00:08a fixed reference plus final year exam multiplied by the weight F4 plus

00:15project result multiplied that by the weight press F4 to make it fixed

00:20reference plus final remedial exam multiplied that by the weight and press

00:25F4 and hit enter that will give you the weighted average and then after that

00:29apply the rest of rows for the rest of the students as you can see there's a

00:33lot of typing going on the fastest way and the most easiest way would be to use

00:37some product like this and the first argument on some product will be the

00:41whole row of the results comma the second argument will be the weighted average

00:46make sure you press F4 to make it fixed reference so they can apply to the rest

00:49of row close parenthesis hit enter and then apply the same formula to the rest

00:54of the row so they can calculate the weighted average for all the students

How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT) - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended