I assume you want the score of 4.65 based on the number of responses
received. this is simply 4.65 * 2nd column number

153 711.45
44 204.6
85 395.25
250 1162.5
120 558




"Shweta Srivastava" wrote:

Hi there,

Please help me with the following issue.

I maintain a worksheet which aims to achieve customer satisfaction rate to
be 4.65


For example:

Total Total Customer Satisfaction
Target for
Score Responses (CSAT) rate (CSAT=4.65)
706 153 4.61 (706/153) ? fig. required to be 4.65
192 44 4.36 (192/44) ? fig. required to be 4.65
359 85 4.22 (359/85) ? fig. required to be 4.65
500 250 2.00 (500/250) ? fig. required to be 4.65
500 120 4.17 (500/120) ? fig. required to be 4.65


What function/formula can give me the figures to achieve the above mentioned
CSAT Target to 4.65?


Regards,
Shweta