Weighted Average

How can we create a weighted average?
The easiest way to do this would be to assign a weight to each row, typically done with a switch statement like this:

From here we multiply the Weight by the values we want the weighted average for.

Lastly, we divide the sum of the Weighted Values by the Sum of the weights


Added Formulas

Added average