simple, basic Q regarding how to code data

author411 · May 10th, 2002, 10:16 AM

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.

Mark O'Brien · May 10th, 2002, 10:24 AM

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?)

author411 · May 10th, 2002, 10:58 AM

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!

Mark O'Brien · May 10th, 2002, 11:13 AM

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

)

author411 · May 10th, 2002, 11:25 AM

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.

May 10th, 2002, 10:24 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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?) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 10th, 2002, 11:13 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 ) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 10:16 AM	#1
author411 New Member Join Date: May 2002 Posts: 3	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.

May 10th, 2002, 10:58 AM	#3
author411 New Member Join Date: May 2002 Posts: 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!

May 10th, 2002, 11:25 AM	#5
author411 New Member Join Date: May 2002 Posts: 3	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.