weighted mean
kalyan,
This will give the weighted average of the values in C (weights in B) for those values where column
A is equal to 44: change all instances of 4000 to the actual last row.
=SUMPRODUCT((A2:A4000=44)*B2:B4000*C2:C4000)/SUMIF(A2:A4000,44,B2:B4000)
HTH,
Bernie
MS Excel MVP
"kalyan" wrote in message
...
is there any way to calculate the weighted mean in excel?
e.g weighted mean from A2:A4 = (B2*C2+B3*C3+B4*C4)/(B2+B3+B4)
this is just an example, i have a huge data of thre columns `A, B and C`. i
need to calculate the weighted mean of column C WITH column B at different
ranges matching with column A, such as for all the same values of column A
(SAY 44) calculate the wiehted mean of corresponding values of column C (12,
4, 5,8) with B (3, 9, 5, 6).
|