Reversing scores for likert /opinion scale questions | Community
Skip to main content
Answered

Reversing scores for likert /opinion scale questions

K

Hello,

Someone kindly explained how some question items could be reversed once transferred to a Google Sheet ot excel spreadsheet but I have a question!

Can you do reverse scoring (questions from 1-5 , but some of these have opposite scoring such as a 5=1, 2=4 etc) inside Typefrom using the scoring function?  

What would be the easiest way to do this - thanks!

Best answer by john.desborough

@Kristianlb - you would have to use the Advanced logic functions. create the necessary variables in the variables area and then in the logic area set up your rules. 

maybe something like this

  • create variable q1_to_flip = 0 and q2_to_flip=0
  • logic rules
    • If q1 is equal to 1, then add 5 to q1_to_flip; if q1 is equal to 2 then add 4 to q1_to_flip; if q1 is equal to 4, then add 2 to q1_to_flip; if q1 is equal to 5, then add 1 to q1_to_flip
    • same for q2 

i did not need to flip an answer of 3

now when the submit button is pushed. you will have all the question responses from the native questions and all the variables stored as well.. you will just need to deal with them in the back end. 

des

View original

    5 replies

    john.desborough
    Forum|alt.badge.img+6
    • john.desboroughCertified Partner
    • Certified Partner & Champion
    • 5270 replies
    • March 11, 2021

    @Kristianlb - you could do that with variables and logic/calculations for each question of your set that requires the transformation

    des

    If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
    K
    1 person likes this
    • K
      Kristianlb
    K
    • Kristianlb
    • Author
    • Explorer
    • 6 replies
    • March 11, 2021

    Thanks John! 

     

    So to do that am I selecting ‘Logic’ ‘simple’ and then the tab ‘score quiz’ to assign scores to questions or am I selecting ‘Advanced logic’ and then ‘variables’ or ‘branching and calculations’ ? 

     

    It’s not that obvious!!

     

    Thanks in advance

    john.desborough
    1 person likes this
    • john.desborough
      john.desborough
    john.desborough
    Forum|alt.badge.img+6
    • john.desboroughCertified Partner
    • Certified Partner & Champion
    • 5270 replies
    • Answer
    • March 11, 2021

    @Kristianlb - you would have to use the Advanced logic functions. create the necessary variables in the variables area and then in the logic area set up your rules. 

    maybe something like this

    • create variable q1_to_flip = 0 and q2_to_flip=0
    • logic rules
      • If q1 is equal to 1, then add 5 to q1_to_flip; if q1 is equal to 2 then add 4 to q1_to_flip; if q1 is equal to 4, then add 2 to q1_to_flip; if q1 is equal to 5, then add 1 to q1_to_flip
      • same for q2 

    i did not need to flip an answer of 3

    now when the submit button is pushed. you will have all the question responses from the native questions and all the variables stored as well.. you will just need to deal with them in the back end. 

    des

    If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
    K
    • Kristianlb
    • Author
    • Explorer
    • 6 replies
    • March 11, 2021

    Hi John,

     

    Okay that’s very clear! So either that ot doing it in Google Sheets/excel as you suggested last time?

     

    Thanks!

    john.desborough
    1 person likes this
    • john.desborough
      john.desborough
    john.desborough
    Forum|alt.badge.img+6
    • john.desboroughCertified Partner
    • Certified Partner & Champion
    • 5270 replies
    • March 11, 2021
    Kristianlb wrote:

    Hi John,

     

    Okay that’s very clear! So either that ot doing it in Google Sheets/excel as you suggested last time?

     

    Thanks!

    @Kristianlb - i would say yes to that. either one. personally, i would do it in the Google Sheet as I control that transform and logic at my end. While it would work in Typeform in the logic rules, it seems to add complexity to the form - firm believer in trying to keep it simple.

    just my thoughts. the good folks here from Typeform may have some better answers. 

     

    des

    If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...

    Reply


    Still need help?

    Don't be shy and ask the community.

    Ask your question here!
    Community T&Cs