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

Rod_Pestell - Since there were 12 Likert questions earlier, the average score for each response could be a decimal value between 1-5. (for. eg. 2.67). However, the new question can only store whole numbers (i.e., 1, 2, 3 ,4 and 5). Are you going to round off the average of the 12 questions and merge it with the new CSAT question?

https://www.qualtrics.com/community/discussion/comment/38085#Comment_38085Hi Mishraji,

Thanks for replying. The thought was to either leave it as a decimal place and only use an average metric in the dashboards or to work out whether a calculated score of eg. 2.5 should either be rounded up to 3 or rounded down to 2. I'm siding with the former option (keep the decimals) but would be interested to know best practise to change to a whole number.

Thanks

Rod

Rod_Pestell - So the data from the 12 Likert questions cannot be merged into the current CSAT question unless rounded off, correct?

Rod_Pestell Mishraji Very interesting thread here -- my two cents would be that I would round to the higher number. That said, in reporting I'm more comfortable reporting Likert values at least to one decimal value, because there is such a difference between a rating of 2 and a rating of 3, particularly for decently large data sets. That might be an argument for performing your analysis and join in Tableau, SAS, or SPSS which could accommodate decimals.

https://www.qualtrics.com/community/discussion/comment/38140#Comment_38140yes... if I don't want to leave it as decimals.

https://www.qualtrics.com/community/discussion/comment/38141#Comment_38141Hi AdamK12 , thanks for your reply.... the end value (as an average) would inadvertently be 1 or 2 decimal places as it's an average of all the 1's, 2's, 3's, 4's or 5's that responders provide. I am talking about whether to convert (round) a pre-averaged value (from the old question) to a 1, 2, 3, 4 or 5 first in the new question.

Thanks

Rod Pestell