Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: simple, basic Q regarding how to code data

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am used to SPSS for data analysis and forgetful. Any help

    Basically, I want to create charts (I know how to do this with Wizard) but I don't know how to code the data.

    I have 33 surveys of yes and no answers. I want to create pie charts to show the responses visually. How do I code and then create the carts to show, for example, 5% of users answered yes, 50% answered no?

    Any help is apreciated. Please forgive my ignorance. I am at the office, using Excel for Dummies, which is NO help.

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not quite sure what "code the data" means. You mean you want to know to sum up all of the "yes" answers and all of the "no" answers?

    What cells is you data in? i.e. is it in Column A in rows 1 to 50 or something?

    (SPSS? What are you? studying to be a counsellor? HR?)

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    right, the data is in column d, rows 1 - 33. I am attempting to chart the responses to a survey. The answers are "yes" and "no."

    What I don't know how to do is how to go from yes or no, as entered on the sheet, to show that the "yes" answers represent, for example, 50% of users.


    Actually, I used SPSS in my studies of urban planning. Now, I am working in communications, trying to illustrate how viewers use our web site. THANKS!

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, we'll put in two formulas, one will contain the total number of "yes"'s and the other will contain the total number of "no"'s.

    I used cells F1 and F2 for "yes" and "no" respectiveyl, but you can use any cells you want. Here's the "yes" formula:

    =COUNTIF(D1:D33, "yes")

    Here's the "no" formula:

    =COUNTIF(D1:D33, "no")

    You can then make your chart based on the value of the two cells.

    HTH

    (My wife's a counsellor and uses SPSS, that's why I asked )

  5. #5
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dear Mark,

    THANK YOU, I knew I was missing something really obvious!

    So, for suveys in which I have 7 different ansewrs, I can do the same - tally the responses and chart. I've got it!

    I know how to label the chart and such.

    This web site rocks. I am sure I'll be back again.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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