Methods to merge 1-5 pt scale CSAT scores with 1-5 variable scale responses

Rod_Pestell · 2021-06-02T21:42:38+00:00

Hi All,I'm after some guidance... I have a new question which I want to back fill with some data from an older version of the question. The new question is a 5pt likert scale (very disat. / fairly disat. / neither sat or disat. / fairly sat. / very sat. & recode values of 1, 2, 3, 4 and 5 respectively). The old question is 12 questions with the same 5pt likert scale. To get an overall score with the old question I calculated an average (of available (see this link: https://www.qualtrics.com/community/discussion/comment/35074#Comment_35074)). This was the best solution in order to get to an aggregate value. Now that we have the new question (which is a question asking about the overall experience rather than its parts), I'd like to think it's possible to back fill the new question using the calculated aggregate from the old question.I understand the new question has a specific silo style of answers (this is what likert is as I understand it) that the responder can select, recoded to 1, 2, 3, 4, 5 whilst the old question calculated aggregate will be a variable scale between 1 and 5. However when you comes to CX dashboarding it, we tend to just use an average metric and not display the breakdown of the 1,2,3,4,5 choices.Given that, do you think it's ok to map over the old aggregate data so that we have a continuous set of data? I would place a footnote explaining the source of the old data.Are there any key caveats I need to be aware of when merging data like this.ThanksRod Pestell

Methods to merge 1-5 pt scale CSAT scores with 1-5 variable scale responses | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded