Thanks:  0
Likes:  0

# Thread: simple, basic Q regarding how to code data

1. 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. 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. 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. 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. 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.

## User Tag List

#### Posting Permissions

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