How do you do reverse scoring for likert type rating questions? | Community
Skip to main content
Answered

How do you do reverse scoring for likert type rating questions?

K

Hi

I have created a series of likert scale questions from an established measure and about a third of the items need to be reversed ( 5 should be 1 etc) 

Can I do this? 

thanks! 

Best answer by john.desborough

@Kristianlb - i created a second tab in the Google Sheet and used that to do the transforms: don’t monkey with the main tab that is automatically created and used by the Typeform integration

Look for the post by @Lasse here that talks about this issue. 

What i did was use logic that along this line:

  • on MY tab, in my cell My_Q1_Response, i used logic like this: if (maintab:Q1 is 5, 1, if(maintab:Q1 is 4, 2, if(maintab:Q1 is 3, 3, if(miaintab:Q1 s 2, 4 if(maintab:Q1 is 1, 5, “error”)))))
  • and then copied this across to the other responses that need transforms.
  • for all the cells in which you have the correct values on the main tab, use the arrayformula function to pull all the data across to the second tab… 

don’t copy the logic statement as it is just words and not the correct statement in Google Sheets BUT it is close, just to give you the idea of how i did the transform

 

hope this helps

 

des

View original

    john.desborough
    Forum|alt.badge.img+6

    @Kristianlb  - from a user here.

    I had this issue and the workaround (for me) was to push the data from the typeform into a Google Sheet and transform the responses to the ‘opposite scale’ for reporting purposes. 

    not perfect but a viable solution for me. 

     

    des

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

    Thanks John, that’s a good plan as the client will be familiar with google sheets anyway. 

    How did you actually do that calculation? I have about 150 responses and the survey has over 30 questions with 15 of them reversed…

    thanks 
     

     

    john.desborough
    1 person likes this
    • john.desborough
      john.desborough
    john.desborough
    Forum|alt.badge.img+6

    @Kristianlb - i created a second tab in the Google Sheet and used that to do the transforms: don’t monkey with the main tab that is automatically created and used by the Typeform integration

    Look for the post by @Lasse here that talks about this issue. 

    What i did was use logic that along this line:

    • on MY tab, in my cell My_Q1_Response, i used logic like this: if (maintab:Q1 is 5, 1, if(maintab:Q1 is 4, 2, if(maintab:Q1 is 3, 3, if(miaintab:Q1 s 2, 4 if(maintab:Q1 is 1, 5, “error”)))))
    • and then copied this across to the other responses that need transforms.
    • for all the cells in which you have the correct values on the main tab, use the arrayformula function to pull all the data across to the second tab… 

    don’t copy the logic statement as it is just words and not the correct statement in Google Sheets BUT it is close, just to give you the idea of how i did the transform

     

    hope this helps

     

    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

    Just seen this response - that’s really helpful John. Thanks so much for taking the time to do that!

     

    Liz
    john.desborough
    2 people like this
    • Liz
      Liz
    • john.desborough
      john.desborough

    Reply


    Still need help?

    Don't be shy and ask the community.

    Ask your question here!
    Community T&Cs