weiging average vs concentration

Can you please help me how to create graph lie the following


Y axis is: weighted average
X axis: Percent reduction change at optical density 450 nm

I have uploaded an excel file, %reduction was already calculated (X axis), not sure or would like to learn how to calculate Weighted Average

Greatly appreciate your help