+ Reply to Thread
Results 1 to 3 of 3

Problems charting my Masters Likert data

  1. #1
    Registered User
    Join Date
    01-04-2010
    Location
    Manchester, Englang
    MS-Off Ver
    Excel 2007
    Posts
    2

    Problems charting my Masters Likert data

    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.
    Attached Files Attached Files

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

    Re: Problems charting my Masters Likert data

    You could plot the response to each question as a series on a bubble chart. The first columns (x value) is response {-2,-1,0,1,2}, second column is question number (to get vertical separation of the series), third column (number of responses) is bubble size.

    To start, though, I'd rearrange the data in datrabase fashion, one record per row.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    01-04-2010
    Location
    Manchester, Englang
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Problems charting my Masters Likert data

    Thanks for the reply.

    Have managed to get the data represented in a 3d horizontal cluster bar chart with my data tabulated beneath with corresponding likert scale, repsonses and percentgaes too which I think looks pretty good but will have a go at using the bubble chart too now.

    Many thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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