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

Hi Shweta,

Do you mean the additional score with that amount of responses in order to
achieve CSAT = 4.65?
Then it will be 4.65*response - score.
let say A1 = 706 (score), B1 = 153 (response), your formula should be
"=4.65*B1-A1 & " fig. required to be 4.65"

"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

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