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