How to do Weighted AVG in smartsheet?

Shaira

We are having a feedback that tells us the rating per questions, as the image shows, it has the number of counts per rating.

Now, how do I get the Weighted Average if the number of respondents of the form keeps changing since it is an ongoing session (daily)?

Freymish

Not sure I understand why the number of respondents would affect the calculaton process. Maybe it would help to show how you are doing the calculation.