simple, basic Q regarding how to code data

author411

New Member
Joined
May 9, 2002
Messages
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.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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?)
 
Upvote 0
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!
 
Upvote 0
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 :) )
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,288
Members
448,563
Latest member
MushtaqAli

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top