Hi..that would be so handy but could you please explain about the normal scoring as well..recently heard it from a friend to not use find and replace option.
Hi, I'm not quite sure what you are asking. Are you asking how to code text responses into numbers? If so, in Sheets you should create a new column and then use an IF statement to automate the coding process. Hope that helps!
No. It sounds like your numbering is 0 to 4. If that’s the case (less common than scales starting at 1) you should just use your highest number and subtract your score from 4, so 4 reverse scored would be 0. If your scale is 1 to 4, you would use top score + 1 so it would be 5-4 and that would make your new value 1. Hope that helps!
This is very helpful. Thank you so much🤍
So helpful…thank you!
THANK YOU!
Thank you so much❤️❤️
Hi..that would be so handy but could you please explain about the normal scoring as well..recently heard it from a friend to not use find and replace option.
Hi, I'm not quite sure what you are asking. Are you asking how to code text responses into numbers? If so, in Sheets you should create a new column and then use an IF statement to automate the coding process. Hope that helps!
@@motherofturtles3297 Yeah, you interpreted it right.
Thanks a ton and even more for reverse scoring!!
@@kathajain9397 Excellent, and that is a great idea for another video :)
@@motherofturtles3297 Absolutely :))
hello my highest scoring is 4 and the result was -1 is it still okay the -1 ?
No. It sounds like your numbering is 0 to 4. If that’s the case (less common than scales starting at 1) you should just use your highest number and subtract your score from 4, so 4 reverse scored would be 0. If your scale is 1 to 4, you would use top score + 1 so it would be 5-4 and that would make your new value 1. Hope that helps!
@@motherofturtles3297 so lets say number is 3, number 3 does not change right? its still 3 is to 3 ?
That depends on your scale. 3 would remain 3 if your scale is 1 to 5. You should watch my video on conceptual reverse scoring.