Is there a general formula for Weighted average? I have a row of numerical
data, from 1 to 5. If it's 1, the weight is 0%, 2 - 25%, 3 - 50%, 4 - 75%, 5
- 100%. Is there a formula which I can do this?

Thanks