About 38,300 results
Open links in new tab
  1. Pivot Table for Likert Scale Type Questions - MrExcel

    Oct 24, 2015 · To clarify and correct my initial mistake about the labeling of the questions: The Likert scale questions are labeled as PER1_1, PER1_2, PER1_3, all the way up to PER1_10. …

  2. Pivottable: How to use Likert-type Answers as Cols, Questions

    Jul 28, 2014 · Pivottable: How to use Likert-type Answers as Cols, Questions as Rows, count of Question responses as Values? Domoromo Jul 28, 2014 likert scale pivot table 2010

  3. Reverse scoring for likert scale | MrExcel Message Board

    Jun 25, 2018 · Hello, I am analyzing data from a survey (1= Not Interested, 5= Very Interested) in which some questions have reverse scoring (5=Not Interested, 1= Very Interested). I am …

  4. Converting text likert scale to numbers and getting a ... - MrExcel

    Jul 25, 2017 · Pivottable: How to use Likert-type Answers as Cols, Questions as Rows, count of Question responses as Values?

  5. Likert Scale to Percentages of Particpants - MrExcel

    Dec 2, 2018 · I was given a data set with a Likert scale (rating 1-5). The data set has around 270 participants, and 8 questions (all with the rating of 1-5). The data has been coded (so it looks …

  6. Agree-disagree bar chart/pie chart HELP NEEDED PLEASE

    May 23, 2011 · I'm analyzing the results of a survey with Likert's scale. that if i'm analyzing 12 questionnaires. and the scale is strongly disagree 1, disagree 2, neither agree ...

  7. Pivot table for a survey (How to select count of "Agree ... - MrExcel

    Feb 10, 2010 · Pivottable: How to use Likert-type Answers as Cols, Questions as Rows, count of Question responses as Values?

  8. Change range of x axis on Excel Pivot Chart 2016

    Apr 18, 2017 · Hi, I have a column chart of a likert scale (0-5). Problem is, people only answered 3 and 4. I cannot figure out how to force the pivot table to include 0,1,2,3,4,and5. Please help! …

  9. Anatomical heat map in excel? | MrExcel Message Board

    Apr 1, 2022 · I have another table that includes body part fielded by both name of employee and a likert scale pain score. 1-5. Five being unbearable pain, 1 being minor or tolerable.

  10. COUNTIF (COUNTIFS?) with 'Fuzzy' Criteria - MrExcel

    Dec 20, 2010 · I conducted a survey with Likert-type questions ("Strongly Disagree" to "Strongly Agree", using a 1 to 5 scale in the spreadsheet). Row 1 is column headings, Each row from 2 …