Mar 31 2023
09:30 AM
- last edited on
Aug 03 2023
05:08 PM
by
TechCommunityAP
Mar 31 2023
09:30 AM
- last edited on
Aug 03 2023
05:08 PM
by
TechCommunityAP
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.
Jun 14 2024 03:47 AM
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
Few more variations to visualize NPS Data
Jun 14 2024 08:37 AM
@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)
Jun 14 2024 04:33 PM