Likert Scale Excel Template 


Likert Scale Excel Template  Excel 
View Answers 
Hi Everyone
I'm about to start my educational action research project and I would really appreciate some advice! My research questionnaires have eight Likert scaled questions. Is there an Excel template available that will allow me to enter the sum for each of the Questions, which in turn will produce a bar chart?
My Likert Scale is: Disagree / Somewhat Disagree / Neutral / Somewhat Agree / Agree
Your advice and guidance would be really appreciated as I am very new to this.
Regards
David
I'm about to start my educational action research project and I would really appreciate some advice! My research questionnaires have eight Likert scaled questions. Is there an Excel template available that will allow me to enter the sum for each of the Questions, which in turn will produce a bar chart?
My Likert Scale is: Disagree / Somewhat Disagree / Neutral / Somewhat Agree / Agree
Your advice and guidance would be really appreciated as I am very new to this.
Regards
David
Similar Excel Tutorials
Scale Data for Printing in Excel  Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
Changing Any Element in a Chart in Excel
In this tutorial I am going to go through the Layout tab in more detail and show you how to build up chart layouts ...
In this tutorial I am going to go through the Layout tab in more detail and show you how to build up chart layouts ...
Helpful Excel Macros
Create a Bar Chart With a Macro in Excel
 Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data
 Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data
Get Values from a Chart
 This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
 This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Create a Line Chart with a Macro in Excel
 Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
 Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Create a Column Chart with a Macro in Excel
 This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
 This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
Delete All Chart Sheets in Excel  Only Chart Sheets are Deleted  Not Embedded Charts
 Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
 Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Similar Topics
I have data from a questionnaire that incorporated a Likert scale which I would like to chart but am having difficulties incorporating everything I want in one chart, i.e. i would like the number of responses indicated along with these response figures as a percentage that ive already calculated using formula in excel under the likert scale of strongly disagree, disagree, undecided, agree and strongly agree which would all be indicated in different coloured bars. How can i get all the three pieces of data i have on my spreadsheet into a graph. I can either get the responses and likert scale as the legend or the percentages corresponding to the likert scale as the legend.
Also what graph would be best to display my data.
Furthermore i would it be possible to separate this data once all displayed in a graph according to the respondents age to the number of responses for each scale along with the percentage.
I would appreciate any help.
Gareth
I have attached my raw data so i hope someone can help me with a solution.
Also what graph would be best to display my data.
Furthermore i would it be possible to separate this data once all displayed in a graph according to the respondents age to the number of responses for each scale along with the percentage.
I would appreciate any help.
Gareth
I have attached my raw data so i hope someone can help me with a solution.
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
12 1
and i want a bar chart/pie chart which shows 5 bars/ 5 pie slices of strongly disagree to strongly agree. showing the stats of these above results.
please help.
i have ms excel and spss, i have option to use any one of them.
please.
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
12 1
and i want a bar chart/pie chart which shows 5 bars/ 5 pie slices of strongly disagree to strongly agree. showing the stats of these above results.
please help.
i have ms excel and spss, i have option to use any one of them.
please.
Hello everyone,
I have a problem that I couldnt figure out.
For example, the values (5 Likert scale) I have in the first column:
strongly agree
agree
undecided
disagree
strongly disagree
disagree
disagree
agree
undecided
agree
.
.
.
.
.
etc.
And each value has a rep. number.
strongly agree=1
agree=2
undecided=3
disagree=4
strongly disagree=5
What I want to do is, for example
if the first cell is "agree", in the next colum it should be seen as "2";
in the second cell, if the value is "strongly disagree", it should be "5".
Is there a formula to do this? I really appreciate any help.
Molly.
I have a problem that I couldnt figure out.
For example, the values (5 Likert scale) I have in the first column:
strongly agree
agree
undecided
disagree
strongly disagree
disagree
disagree
agree
undecided
agree
.
.
.
.
.
etc.
And each value has a rep. number.
strongly agree=1
agree=2
undecided=3
disagree=4
strongly disagree=5
What I want to do is, for example
if the first cell is "agree", in the next colum it should be seen as "2";
in the second cell, if the value is "strongly disagree", it should be "5".
Is there a formula to do this? I really appreciate any help.
Molly.
Hi all,
I am analysing the responses from a questionnaire that I sent out to two different groups ie contractors and developers to find out their opinions on the research subject matter. It was based on the likert scale. I used the ttest to compare whether they is much of a difference in their responses. The responses to the questionnaire were as follows: Strongly Agree Agree Neither Agree nor Disagree Disagree Strongly Disagree I have given the following numbers to each response
Stongly Agree = 5 Agree = 4 Neither Agree nor Disagree = 3 Disagree =2 Strongly Disagree =1 The responses from the following 11 questionnaires from the following two groups are as follows
Developer
4
1
2
4
4
5
5
4
4
5
4
I worked out the mean of this group to be 3.81 and the standard deviation to be 1.19.
Contractor:
4
4
3
4
4
2
4
4
4
4
4
I worked out the mean to be 3.72 and the standard deviation to be 0.61 for this group.
I tried to use the ttest and came up with an answer of 0.22. I am not sure if this is right however.
I do not know if I used the ttest properly or how to explain whether the answer is significant or not. In addition I am not sure that I used the correct test.. should I have used the chisquare test?
Would someone please please explain this to me.
Hoping that someone can help,
Joe
I am analysing the responses from a questionnaire that I sent out to two different groups ie contractors and developers to find out their opinions on the research subject matter. It was based on the likert scale. I used the ttest to compare whether they is much of a difference in their responses. The responses to the questionnaire were as follows: Strongly Agree Agree Neither Agree nor Disagree Disagree Strongly Disagree I have given the following numbers to each response
Stongly Agree = 5 Agree = 4 Neither Agree nor Disagree = 3 Disagree =2 Strongly Disagree =1 The responses from the following 11 questionnaires from the following two groups are as follows
Developer
4
1
2
4
4
5
5
4
4
5
4
I worked out the mean of this group to be 3.81 and the standard deviation to be 1.19.
Contractor:
4
4
3
4
4
2
4
4
4
4
4
I worked out the mean to be 3.72 and the standard deviation to be 0.61 for this group.
I tried to use the ttest and came up with an answer of 0.22. I am not sure if this is right however.
I do not know if I used the ttest properly or how to explain whether the answer is significant or not. In addition I am not sure that I used the correct test.. should I have used the chisquare test?
Would someone please please explain this to me.
Hoping that someone can help,
Joe
Can someone help me by giving step by step instructions on how to do 5 points Likert scale on excel? and if possible, how to merge results to come out as 3 points scaleagree,disagree,no view if i felt the need to?
Hi,
I'm new to the forum  though I have browsed and found the resources helpful for a long time. Thank you to all who contribute here.
I have an issue with some data that I can't see covered elsewhere. I have conducted a study on whether 3 different groups of students found our mobile website useful towards learning. The survey covers a range of areas, from content of the site, to whether mobile learning has improved their ability to study.
In total I have 16 Likert type questions  all with a scale of Strongly Disagree, Disagree, Neutral, Agree and Strongly Agree.
Immediately, I can observe from the whole sample (all 3 groups  n=601) that the results will be skewed to the right (Agree/Strongly Agree) for nearly all 16 Likert questions.
I'm unsure what type of tests I can use to illustrate whether there was a significant difference between the 3 groups of participants (biology/geography/maths students). KruskalWallis seems like an option, but I don't know how to apply this to Likert type data using Excel.
Of the 601 sample, the group sizes are not equal. 281 are biology students, 267 are geography students and 53 are maths students. Does this affect what test I can use?
I have already created charts for each question, comparing the 3 groups % response to the question.
However, I'd like to take this further, and not quite sure how. I'd like to treat my data as ordinal rather than assuming it is interval.
From the extensive reading I have done, this would have been easier with only 2 groups of students, but I have what I have.
Any ideas would be greatly appreciated!
Dear All,
I am new to this and hope you can help me out.
I have an excel document which has multiple columns. One of the columns have the value(words) agree, disagree and neutral.
My question is what can I do that these words automatically referers to a number for eg: agree=1, disagree=2, neutral=3 and so on.
Thank You so much for your help.
I am new to this and hope you can help me out.
I have an excel document which has multiple columns. One of the columns have the value(words) agree, disagree and neutral.
My question is what can I do that these words automatically referers to a number for eg: agree=1, disagree=2, neutral=3 and so on.
Thank You so much for your help.
Hi all
I am new to this site and what a great forum. I found the following link very useful to create a chart from the likert scales.
http://www.excelforum.com/excelchar...gachart.html
But, I would like to change the legend as per the graph from Strongly disagree to strongly agree in that order. I tried just moving them around in the data table, but it seems to move the whole graph and so, the original graph gets distorted. Any ideas how this might be done or is it not possible. Thanks.
Raja
I am new to this site and what a great forum. I found the following link very useful to create a chart from the likert scales.
http://www.excelforum.com/excelchar...gachart.html
But, I would like to change the legend as per the graph from Strongly disagree to strongly agree in that order. I tried just moving them around in the data table, but it seems to move the whole graph and so, the original graph gets distorted. Any ideas how this might be done or is it not possible. Thanks.
Raja
Hi
My knowloedge using Excel is pretty basic and I would like any advice on how to accomplish the following task:
 An excel file contains two sheets.
 On sheet one, we have an option to select (from a list box) an answer out of five choices:
Strongly agree
Agree
Neither agree or disagree
Disagree
Strongly disagree
Once an answer is selected I would like to populate cells in sheet 2 with the number equivalent:
1  Strongly agree
2  Agree
3  Neither agree or disagree
4  Disagree
5  Strongly disagree
I think a lookup table could possible do this??
Thanks
My knowloedge using Excel is pretty basic and I would like any advice on how to accomplish the following task:
 An excel file contains two sheets.
 On sheet one, we have an option to select (from a list box) an answer out of five choices:
Strongly agree
Agree
Neither agree or disagree
Disagree
Strongly disagree
Once an answer is selected I would like to populate cells in sheet 2 with the number equivalent:
1  Strongly agree
2  Agree
3  Neither agree or disagree
4  Disagree
5  Strongly disagree
I think a lookup table could possible do this??
Thanks
First I would like to say thank you for the great help I received from this forum, especially from Andy Pope. I dont know why my thread from July 7 is not here any more, but anyway  the answer I received was of great help.
The last time I had problems with presenting the results of a LikertScale in a graph, showing values for such things as Very important, Important, Neutral etc. Now I know how to "cut" the "neutral" by half  but if I want to show the results of two different likertscales sidebyside in a graph (please see the attached sheet), I get a different picture.
Could anyone help me with this problem?
The last time I had problems with presenting the results of a LikertScale in a graph, showing values for such things as Very important, Important, Neutral etc. Now I know how to "cut" the "neutral" by half  but if I want to show the results of two different likertscales sidebyside in a graph (please see the attached sheet), I get a different picture.
Could anyone help me with this problem?
Hi all.
My survey has 15 questionnaires and 50 respondents. The questions are all multiple choice and some contained open ended answers.
For example:
***Q1 Q2 Q3 Q4 Q5 Q6
***Yes Yes  No  Agree  Neutral  No
***No  Yes  Yes  Disagree  Neutral  Yes
***No  Yes  No  Agree  Disagree  Yes
Is there any way to count if:
The total number of people in who either answer 'yes' or 'no' in Q1, also answer either 'agree' or 'disagree' in Q2' and so on.
I have tried countifs function, like =countifs("B2:B51,"Yes","C2:C51,"No",D2:D51,"F2:F51,"Agree",G2:G51,"Yes") and so on....
but it is time consuming. There are so many options because the respondents answers are varies.
Any suggestions?
(p.s. sorry about my level of English)
for example, i have a column
A1
strongly agree
agree
strongly disagree
neutral
agree
disagree
strongly agree
i need a present in a chart, how many "strongly agree", how many
"disagree", etc, based on how many occurance of them in the column, and
use the "strongly agree", "Disagree"...as the label.
what is the most suitable chart type, and how to set the labels?
and most important, how to get the counts?
as i am not very experienced in Excel, hope someone can save me!
A1
strongly agree
agree
strongly disagree
neutral
agree
disagree
strongly agree
i need a present in a chart, how many "strongly agree", how many
"disagree", etc, based on how many occurance of them in the column, and
use the "strongly agree", "Disagree"...as the label.
what is the most suitable chart type, and how to set the labels?
and most important, how to get the counts?
as i am not very experienced in Excel, hope someone can save me!
Hi,
I was wondering if someone could help to figure out how to consolidate different worksheets to analyze likert scale surveys using pivot tables
Thank you,
komic
I was wondering if someone could help to figure out how to consolidate different worksheets to analyze likert scale surveys using pivot tables
Thank you,
komic
Hello,
I am working on a survey where I have 5 results and 4 respondents. I am trying to simplify creating a formula for each of the sets of data. Here is the formula under each response.
SUMPRODUCT(($2:$2="Traditionalist"),($3:$3=1))
2 is for the respondent and 3 is for the question number, 1 is for Strongly Agree, 2  agree, to 5 where it is strongly disagree.
Here is the layout.
Strongly Agree Agree Neutral Disagree Strongly Disagree Traditionalist 0 1 0 0 0 Baby Boomer 2 0 2 0 0 Gen X 1 1 0 0 0 Gen Y 1 0 0 0 1 Strongly Agree Agree Neutral Disagree Strongly Disagree Traditionalist 0 1 0 0 0 Baby Boomer 1 1 2 0 0 Gen X 2 0 0 0 0 Gen Y 0 0 0 0 2
Now, the part I need to change all the time is the 2 for the respondent to change from traditionalist to baby boomer, etc. then the #3 to the next question #4 and the 1 across from strongly agree to Disagree.
Any way to simplify. Or do I need to do the teadious way.
I am working on a survey where I have 5 results and 4 respondents. I am trying to simplify creating a formula for each of the sets of data. Here is the formula under each response.
SUMPRODUCT(($2:$2="Traditionalist"),($3:$3=1))
2 is for the respondent and 3 is for the question number, 1 is for Strongly Agree, 2  agree, to 5 where it is strongly disagree.
Here is the layout.
Strongly Agree Agree Neutral Disagree Strongly Disagree Traditionalist 0 1 0 0 0 Baby Boomer 2 0 2 0 0 Gen X 1 1 0 0 0 Gen Y 1 0 0 0 1 Strongly Agree Agree Neutral Disagree Strongly Disagree Traditionalist 0 1 0 0 0 Baby Boomer 1 1 2 0 0 Gen X 2 0 0 0 0 Gen Y 0 0 0 0 2
Now, the part I need to change all the time is the 2 for the respondent to change from traditionalist to baby boomer, etc. then the #3 to the next question #4 and the 1 across from strongly agree to Disagree.
Any way to simplify. Or do I need to do the teadious way.
Hello. I apologize if this has been answered before, but I cannot find it on the forum. I have a data set similar to the following (though much bigger), and I cannot get the data to display in a useful form. It was a survey.
Quest 1 Quest 2 Quest 3
Cust 1 Agree Disagree Agree
Cust 2 Neutral Agree Agree
Cust 3 Agree Neutral Neutral
Cust 4 Agree Agree Neutral
I'd like to end up with a pivot table such as:
Agree Neutral Disagree
Quest 1 3 1 0
Quest 2 2 1 1
Quest 3 2 2 0
When I change the fields, the Agrees, Neutrals, and Disagrees nest inside each other and things get very confusing. Do I need to rearrange my data (which could take hours) or is there a way to "count" the answers without creating an individual pivot table for each question (which is what I'm currently doing.)
D
Quest 1 Quest 2 Quest 3
Cust 1 Agree Disagree Agree
Cust 2 Neutral Agree Agree
Cust 3 Agree Neutral Neutral
Cust 4 Agree Agree Neutral
I'd like to end up with a pivot table such as:
Agree Neutral Disagree
Quest 1 3 1 0
Quest 2 2 1 1
Quest 3 2 2 0
When I change the fields, the Agrees, Neutrals, and Disagrees nest inside each other and things get very confusing. Do I need to rearrange my data (which could take hours) or is there a way to "count" the answers without creating an individual pivot table for each question (which is what I'm currently doing.)
D
hello
i have collected feedback regarding the usage of timesheet as a part of my MBA project.
the feedback is in MS EXCEL.
I would like to do some data analysis and put the data in form of charts.
pie charts are too elementary.
my professor insists in statistical tools which i dnt have.
the questions are given and the employees were asked to give the opinion on based of 5 point scale.
Strongly Disagree 1
Disagree 2
Undecided 3
Agree 4
Strongly Agree 5
what can i do in excel? I have no clue about it...
pls help me out...
i have collected feedback regarding the usage of timesheet as a part of my MBA project.
the feedback is in MS EXCEL.
I would like to do some data analysis and put the data in form of charts.
pie charts are too elementary.
my professor insists in statistical tools which i dnt have.
the questions are given and the employees were asked to give the opinion on based of 5 point scale.
Strongly Disagree 1
Disagree 2
Undecided 3
Agree 4
Strongly Agree 5
what can i do in excel? I have no clue about it...
pls help me out...
Dear All,
I am new to this and hope you can help me out.
I have an excel document which has multiple columns. One of the columns have the value(words) agree, disagree and neutral.
My question is what can I do that these words automatically referers to a number for eg: agree=1, disagree=2, neutral=3 and so on.
Thank You so much for your help.
Atty
I am new to this and hope you can help me out.
I have an excel document which has multiple columns. One of the columns have the value(words) agree, disagree and neutral.
My question is what can I do that these words automatically referers to a number for eg: agree=1, disagree=2, neutral=3 and so on.
Thank You so much for your help.
Atty
Hi,
I was hoping someone could shed some light on my following problem i'm having in excell 2003.
I'm trying to have a horizontal bar chart with 6 text descriptions on the y axis and a 5point scale on the x axis (strongly disagree to strongly agree).
My data for the description are just 1 to 5 (corresponding with the 5point scale). what I wanted was to display the mean score for each descriptor on the y axis, but when I do this I cant change the x axis to the 5point scale.
I tried using custom text on the x axis (e.g [=1]"strongly disagree"; [=2] etc...,) but it wont go further than 2 customer text labels for some reason.
If anyone would be able to lend some advice on how i can do this it would be appriciated.
Cheers,
Martin
I was hoping someone could shed some light on my following problem i'm having in excell 2003.
I'm trying to have a horizontal bar chart with 6 text descriptions on the y axis and a 5point scale on the x axis (strongly disagree to strongly agree).
My data for the description are just 1 to 5 (corresponding with the 5point scale). what I wanted was to display the mean score for each descriptor on the y axis, but when I do this I cant change the x axis to the 5point scale.
I tried using custom text on the x axis (e.g [=1]"strongly disagree"; [=2] etc...,) but it wont go further than 2 customer text labels for some reason.
If anyone would be able to lend some advice on how i can do this it would be appriciated.
Cheers,
Martin
Hello everyone!
I'm after some help please.
I have 500 product evaluation forms each of which contain people's answers to 14 questions about a new product they have just trialled. I need to find the quickest way to get this data onto excel so it can do the rest of the work for me. I've got all my charts etc set up but the obvious missing link is the info. I'll give you an example of how the form is set up:
Question
Was the device comfotable to use?
The user then ticks one of 5 boxes
Strongly Disagree, Mostly Disagree, Neutral, Mostly Agree, Mostly Disagree
In an ideal world, I would like to have a user form on screen in which i can run through and enter the data using option buttons. This bit I can do no problem. The problem I have is what code I use to collate the data from the form onto 1 worksheet that keeps a score of (for example) total number of answers to this question that scored a 'strongly agree' etc etc etc.
What I would like to end up with is a worksheet has the 14 questions listed down the left, then across the top the 5 possible answers with a final column that totals the number of recipients....obviously the hope is that if this works, that final column reads '500' for all 14 questions.
If there is anyone out there who can help me, I can't tell you how gratefull I'd be!
Any questions, just let me know!
Thanks
Dom
I'm after some help please.
I have 500 product evaluation forms each of which contain people's answers to 14 questions about a new product they have just trialled. I need to find the quickest way to get this data onto excel so it can do the rest of the work for me. I've got all my charts etc set up but the obvious missing link is the info. I'll give you an example of how the form is set up:
Question
Was the device comfotable to use?
The user then ticks one of 5 boxes
Strongly Disagree, Mostly Disagree, Neutral, Mostly Agree, Mostly Disagree
In an ideal world, I would like to have a user form on screen in which i can run through and enter the data using option buttons. This bit I can do no problem. The problem I have is what code I use to collate the data from the form onto 1 worksheet that keeps a score of (for example) total number of answers to this question that scored a 'strongly agree' etc etc etc.
What I would like to end up with is a worksheet has the 14 questions listed down the left, then across the top the 5 possible answers with a final column that totals the number of recipients....obviously the hope is that if this works, that final column reads '500' for all 14 questions.
If there is anyone out there who can help me, I can't tell you how gratefull I'd be!
Any questions, just let me know!
Thanks
Dom
I'm getting a compile error when i try to assign a macro to a button to begin a survey. attached is my sample. I still have work to do but i was trying to get the basic function working. any advise? Thanks!
(im not good with vba and i was following these instructions:
HTML Code:
http://unfetter.me/howtocreatealikertquestionnaireexceluserformmac/
Hi,
I have a large amount of data to put into a pivot table that relates to questionnaire responses. The responses are agree, agree strongly, neither agree nor disagree, disagree and disagree strongly. The columns relate to individuals to whom the responses refer. Putting one question and its answers into a table is no problem. I end up with the count of the answers at individual level, e.g. 3 agree strongly, etc. I run into problems when I try to create a table with multiple answers they end up next to each other rather than underneath each other, the result is that the table becomes wider and wider (there are 21 questions).
Is there a way of doing this?
I have a large amount of data to put into a pivot table that relates to questionnaire responses. The responses are agree, agree strongly, neither agree nor disagree, disagree and disagree strongly. The columns relate to individuals to whom the responses refer. Putting one question and its answers into a table is no problem. I end up with the count of the answers at individual level, e.g. 3 agree strongly, etc. I run into problems when I try to create a table with multiple answers they end up next to each other rather than underneath each other, the result is that the table becomes wider and wider (there are 21 questions).
Is there a way of doing this?
I want to turn this:
Agree strongly Agree slightly Neither agree nor disagree Disagree slightly Disagree stongly Staff are helpful and courteous 64 17 2 0 1
into this:
Agree strongly Agree slightly Neither agree nor disagree Disagree slightly Disagree stongly Staff are helpful and courteous 76.19% 20.23% 2.38% 0.00% 1.19%
What would be the formula?
Thanks,
Cuba.
Agree strongly Agree slightly Neither agree nor disagree Disagree slightly Disagree stongly Staff are helpful and courteous 64 17 2 0 1
into this:
Agree strongly Agree slightly Neither agree nor disagree Disagree slightly Disagree stongly Staff are helpful and courteous 76.19% 20.23% 2.38% 0.00% 1.19%
What would be the formula?
Thanks,
Cuba.
I have a bunch of qualitative data to analyse across different geographical regions and most questions asked require an either agree, strongly agree, disagree, strongly disagree and undecided answers. Can someone please advise how best to count each of the responses for each region and each question...I am doing it manually by filtering each response and this is taking forever. Any help much appreciated. Thanks, Ivana
Hi there,
I need to analyse a survey with 10 different questions. The users answered by clicking: Agree, Disagree, neither nor etc... Furthermore their working location (5 different) is part of the survey. The raw data is as the following: Coloumns > different Questions with scores (agree, disagree etc) above, Rows > Location of every user.
I wanted to create a pivot with the different questions in the rows and the scores (filtered by the location) as percentages above. Hopefully you can help me.
Thanks!
Hi please can someone help me?
Please view the attachment example. I am doing some Survey Analysis and have had to convert the text answers to those surveys questions into numbers.
1= Agree
2= Tend to agree
3= Neutral
4= Tend to disagree
5= Disagree
I now want to do an average of columns D to L in row 847 but as I used an IF formula to convert the text to numbers is won't let me average the cells as there is a formula in it.
I also want to do a ranking in row 849 based on the average in row 847. The lower the average the higher the ranking. This way I can analyse where we need to implement an improvement process.
Can anyone help me please?