Microsoft Forms - Inverted Likert Scale

Copper Contributor

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. 

3 Replies

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 Microsoft Excel & Office 365.

 

And if you are comfortable with Google Sheets, you can find it here.

 

Thanks

 

Likert Scale Chart for survey data

Qaiser_j_0-1718361989952.png

 

 

Few more variations to visualize NPS Data

Qaiser_j_1-1718361989961.png

 

 

 

Qaiser_j_2-1718361990476.png

 

 

@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)

@Rob_Elliott 

 

Noted! in this case can I remove this?