Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

HELP! How do I analyse this and make a chart?

  • 13-05-2011 12:01am
    #1
    Efie
    Closed Accounts Posts: 8 ✭


    Your Question
    HELP! How do I analyse Frequency and make it into a chart?
    I have to make a chart out of this and I have never been so confused in my life, I have SPSS but havent the slightest idea how to use it so it's not really any help. its based on the amount of times a teacher carries out a certain art activity with the class. I need to make a chart out of this:

    ................Very Frequent....Quite Freq.......Sometimes.....Hardly Ever.....Never
    Painting
    Gluing
    Cutting
    Modelling
    Messy play

    20 people said the painted very freq.
    13 said quite freq.

    16 said gluing very freq.
    26 said quite freq.
    5 said sometimes
    2 said hardly ever

    12 said cutting very freq.
    9 quite freq
    8 sometimes
    4 hardly ever

    15 said modelling very freq.
    11 quite freq.
    5 sometimes
    2 hardly ever

    2 said messy play very freq
    14 quite freq
    10 sometimes
    7 hardly ever

    Nobody said never for anything.

    The table was originally a question in a survey i did, and the participant had to tick the appropriate box, so the numbers are the amount of participants who ticked that box.
    PLEASE PLEASE PLEASE HELP. I'm desperate!


Comments

  • #2
    hivizman
    Registered Users, Registered Users 2 Posts: 1,163 ✭✭✭hivizman


    You don't need the power of SPSS - this is something that you can do in Excel.

    First, you need to set your data out in a table. This should have five rows, labelled with the five activities, and five columns, labelled with the five possible responses (you could abbreviate these to fit into the column width - I used "VFreq", "QFreq", "Sometimes", "Rarely" and "Never"). Then enter the responses into the appropriate cells in the 5x5 table.

    Next, highlight the 6x6 cells consisting of the headings, activities and response values.

    Then click on the "Chart Wizard" icon on the task bar. This brings up a menu of various chart types. The best to use is actually the default choice "Clustered Columns". Click "Next". You will get a small view of the chart and the choice of rows or columns. Choose columns. If this is the chart you want (and based on your description it should be), then simply click on "next" until the chart appears as an object in the worksheet.

    If you want, you can experiment with other chart presentations, but I think that the clustered column layout is most relevant.

    Good luck!


  • #3
    Efie
    Closed Accounts Posts: 8 ✭Efie


    Thank you so much! i got it eventually! I wasnt sure if there was a specific way of analysing a frequency scale or not so i completely panicked! Thank you!


Advertisement