Likert Scale Weighting in Excel

#1
Hi - I am trying to weight customer satisfaction data in Excel and am hoping that someone will be able to confirm if I am on the right track. Customers score their satisfaction on a 5-point Likert scale of very satisfied to very dissatisfied and I need to weight the response so that it is representative of the customer base.

The below example shows how the survey response compares with the customer base as well as the satisfaction scores without weighting and the scores with weighting. Have I done this correctly? Any advice you can give would be greatly appreciated! Thank you in advance.

Weighting.png