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