likert scale

Hi Excel Community, My function is set to not count any "N/As" but it's not working. N/As are being counted as 3. The likert scale of 3 should only be returned when "influential" is stated in the column. Here is the function I typed in: =IFERROR(LOOKUP(AQ8,{"Definitive","Influential","Not...

Hi folks... I have a simple evaluation. 4. Strongly Agree 3. Agree 2. Disagree 1. Strongly Disagree Example: I have 10 evaluations with each evaluation having 14 questions and 140 total potential selections. The totals of my counts come to: 4. 100 3. 20 2. 10 1. 10 How can I crunch...

I created a clear stacked bar chart in excel to display Likert scale responses (strongly disagree to strongly agree) for a questionnaire. However, when placing the disagree and strongly disagree values below zero, i still have negative values on the x axis. I want the x axis to display 0-100% on...

Let me apologize in advance if I'm doubling up a previous post. I tried searching for similar things and did not come up with anything. I am using Excel 2010 and Windows 7. I'm trying to set up a pivot table with several row headings: Country, city, site name. I have a survey with several...

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 nor disagree 3, agree 4, strongly agree 5. and the results for question 1 is 1 2 2 3 3 2 4 4 5 5 6 1 7 3 8 4 9 4 10 5 11 2...