I have survey data that I need to get a average for - Customers were to
select 1-5 for a answer and I now have totals for each of those responses.

1 not satisfied 6
2 7
3 14
4 15
5 very satisfied 20

The answer needs to be a number between 1-5 for the weighted average of the
totals.

Can someone please help