Forum Discussion

commsmanger's avatar
commsmanger
Copper Contributor
Mar 31, 2023

Microsoft Forms - Inverted Likert Scale

I created a survey in MS Forms using the Likert Scale feature. When creating the form I had the responses in the following order: Strongly Disagree, Disagree, Neutral, Agree, and Strongly Agree.  Somehow on a few of the questions, the order of those responses was transposed. Meaning the order was reversed i.e. Strongly Agree, Agree, Neutral, Disagree, and Strongly Disagree. After the survey was live and some people had taken the survey, I went in and corrected the order, but now my data seems skewed. Previously questions leaning positively are now negative.

 

Does changing the order of the responses on the Likert scale change the data captured? i.e. Agree is now Disagree, etc. 

microsoft forms
Survey

3 Replies

  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Jun 14, 2024

    Hi commsmanger 

     

    I attached sample charts created on survey data. Data refresh in the chart automatically as you change your data selection.

     

    I regularly create these charts with the following tool. Hope you will like it.

     

    You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

     

    And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

     

    Thanks

     

    Likert Scale Chart for survey data

     

     

    Few more variations to visualize NPS Data

     

     

     

     

     

    • Rob_Elliott's avatar
      Rob_Elliott
      Bronze Contributor
      Jun 14, 2024

      Qaiser_j Qaiser_j your answer doesn't make any reference to the Microsoft Forms likert question type so doesn't answer the OP's question.

       

      Rob
      Los Gallardos
      Microsoft Power Automate Community Super User.
      Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources