how to analyse likert scale data in spss

By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. Survey questions that ask you to indicate your level of agreement, from strongly agree to strongly disagree, use the Likert scale. Step-by-Step Procedure to Analyze Likert Scale Data in Excel Step 1: Create Survey Form and Make Dataset Step 2: Count Blank and Non-Blanck Responses of Likert Scale Data Step 3: Count All Feedback from Dataset Step 4: Calculate Percentage of Each Feedback Step 5: Make Report on Likert Scale Analysis Step 6: Generate Final Report with Charts Your starting point for summarising Likert scale data with SPSS will be a dataset similar to the one shown inFigure 1, below. 0 Take your sum of squares treatment and divide it by (the treatment degrees of freedom) how many groups you have minus one. X = (x - a) / (b - a) We might code the responses as follows: strongly agree = 1, agree = 2, undecided = 3, disagree = 4, and strongly disagree = 5. And with the help of the SUM function, we are going to calculate the total number of people participating. As a masters student analysing data like this for the first time, this guide has been a saviour. How to: Analysing 5-Point Likert Scale with ANOVA, We've added a "Necessary cookies only" option to the cookie consent popup. In other words, it is a wide range of possible answers instead of just binary black and white answers. Binning answers from a Likert-scale question. Thanks for the info I have been looking for discussions about merging likert scales, and also youtube videos bust they all use means but do not explain why, this is the first time I heard using median, which makes a lot of sense. For example you can have age categories as "18 to 25", "26 to 30", "30 to 35" and so on. Step 2: Enter your question in the label row. >>Is it ok to do that and then use an independent samples T-test to compare the means of the two groups? I am sorry your advisor is out of reach, but you should really talk to him or her, if they are statistically competent this looks like it needs lots of help. For example : 1 - Very important 2 - Important Step - 4 - Select your measure ( Scale or Ordinal or Nominal); this describes the level of importance. 3 4.0 (all were significantly different). If you want to read up on Likert scales before you go on, you can find some information in this post. >>I also measured behavioral intentions with 12 questions also answered on a 7pt Likert scale. Is there a proper earth ground point in this switch box? never 0 rarely 1 sometimes 2 often 4 always 5. A sample dataset of 12 people participating in the survey will look like this. Now take your individual values and subtract them from the grand mean. Once you have collected all the data, keep the excel file ready with all data inserted using the right tabular forms. This is the kind of question that would be best answered by your supervisor. I have a 5 Independent variables which are sub-classified in to two,three and four.And i have around 34 dependent variables.These independent variables are classified on 5 Likert scale,which include Strongly Agree, Agree,Neutral,Disagree and Strongly.So, i want to analyse the differences among groups by using infrential statistics.So, which test is best to use? For any surveys, we are going to need to fill up a form first. This is the kind of question that your advisor or mentor will be better qualified to answer. years of service), but I have no idea how that can be valuable. Or would a comparison of the question categories suffice?) Level up your tech skills and stay ahead of the curve. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. See disclaimer. Hope that helps. That means that they can tell us how to rank responses (strongly agree is more agreement than agree) , but they do not give us information about the distance between them (strongly agree is not twice as much agreement as agree). How to Analyse Data Using SPSS: 6 Steps (with Pictures) - wikiHow I have seen and used grouping frequently in market research. Sometimes also referred to as a satisfaction scale, this scale generally consists of multiple choices for questions. I must analyse my Likert Scale data with ANOVA to get the significance (using the ANOVA is the requirement). The Mann Whitney test is a safer choice here. Why does Mister Mxyzptlk need to have a weakness in the comics? All I need to do is what I did minus the multiplication? Read More: How to Analyse Qualitative Data from a Questionnaire in Excel. In this article let us study the features of Likert scale. Using SPSS to analyse Likert Scale Data | ResearchGate Consumerbehaviour SA A N D SD Total SPSS will automatically generate a new variable, which will appear at the end of your dataset. Interesting advice thank you endstream endobj startxref If we accept the decimal results, does this not negate the reasons why we are using medians (rather than mean) for the ordinal data? Suppose, for example, we ask respondents how much they agree or disagree with ten actions taken by Congress. Research question:Is there a difference between female and male police officers male rape myth acceptance in South Africa?The MRMS is a 22-item questionnaire which measures participants acceptance of untrue or stereotypical beliefs regarding male rape (I'll be using the MRMS).Participants respond to the questions by choosing an option from a 6-point Likert scale ranging from strongly disagree (1) to strongly agree (6).The following demographic data will be collected: Gender, age, ethnicity, years of service, as well as place of residence. wikiHow is a wiki, similar to Wikipedia, which means that many of our articles are co-written by multiple authors. hYmo6+bwRC4[[IKcg~w'dv5C\Hx$3K& %gBH|zH%ST1-i%!5ReKlB3JTT)_%Ls #BCj%7x!c-K8%Z(qvsvJbH|q]-O/7IqZ]-/H9PO8I//.Qsq8ar1 /d=qj Times it by how many people who have answered that question category. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a6\/Analyse-Data-Using-SPSS-Step-1.jpg\/v4-460px-Analyse-Data-Using-SPSS-Step-1.jpg","bigUrl":"\/images\/thumb\/a\/a6\/Analyse-Data-Using-SPSS-Step-1.jpg\/aid4786345-v4-728px-Analyse-Data-Using-SPSS-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"