How to plot survey results on Excel?
Posted
by Mulone
on Super User
See other posts from Super User
or by Mulone
Published on 2010-06-01T16:38:35Z
Indexed on
2010/06/01
16:44 UTC
Read the original article
Hit count: 337
Hi all, I would like to plot the average of these data sample:
1. Contribution to the project
2. Affiliation with project owners
3. Level of expertise
4. Learning Curve
Yes No 3 2
No No 3 2
No No 4 3
No No 5 3
No No 3 3
Yes Yes 5 4
No No 4 3
No No 3 2
No Yes 2 4
No No 5 2
No Yes 5 No answer
No No 2 2
No No 3 3
...
Basically I know how to do the average of each numeric column, but I have a few questions for you:
- If the column contains non numeric values (e.g. "no answer") the average doesn't work. Is there a workaround for this?
- How can I count the yes/no results and plot only a percentage?
Thanks for any hints! Mulone
© Super User or respective owner