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: 311

Filed under:
|

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

Related posts about excel

Related posts about graphs