How to plot survey results on Excel?
- by Mulone
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