+ Reply to Thread
Results 1 to 2 of 2

Likert Data Analysis in Excel

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Likert Data Analysis in Excel

    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). Kruskal-Wallis 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!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Likert Data Analysis in Excel

    Once you decide what you need, we can probably help you implement it in Excel. But for help with the former, you might be better off with a math or statistics forum (e.g., http://mathforum.org/math_help_landing.html, http://www.statisticsforum.com/, http://www.talkstats.com/)
    Last edited by shg; 10-28-2013 at 01:48 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 07-04-2012, 09:30 AM
  2. Likert scale analysis - before and after
    By maggiec in forum Excel General
    Replies: 0
    Last Post: 05-17-2011, 06:38 PM
  3. Problems charting my Masters Likert data
    By GAZCOOPER22 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2010, 12:44 PM
  4. Likert Scale Excel Template
    By davidknight in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2009, 04:28 AM
  5. Likert scale analysis and pivot table consolidation
    By komic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2009, 03:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1