Question

how to calculate weighted average in excel

Answer 1

average in excel
----------------------------------------------------------------------------------------------------------------


Here are some steps
:-

1. Go in Excel and type the following date

A1: Cost ******* B1: Cases
A2: ₹20 *********B2: 10
A3: ₹.30 ******** B3: 40




2. Now, Type the formula below in any blank cell.

=> =((A2*B2)+(A3*B3))/SUM(B2:B3)



===================================================




Note :-
There are 2 formulas for that

1) =((A2*B2)+(A3*B3))/SUM(B2:B3)

2) =SUMPRODUCT(A2:A3,B2:B3)/SUM(B2:B3)


________________________________________________________

Answer 2

Heya,

your answer is here -

calculate the weights and then count the weights how many times it come and then divide.

HOPE IT HELPS YOU