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