How did you derive that formula?

if i have these values, where would i plug them into this equation you
provided?

volume records with values Sum of values avg.
97,194 7,581 37600.42 4.96

"vezerid" wrote:

The formula for weighted average in this case is:
=(200000*5+1000000*4.5)/(200000+1000000)

HTH
Kostis Vezerides