Analyze Data

G

Guest

I am trying to anayze the data from a survey that was handed out to 20 people
and was ranked 1 - 5. Number 1 as being the least need for improvement and 5
being the most need for improvement. How do I come up with a chart that will
analyze this data?
 
B

Bernard Liengme

Use COUNTIF to count the number of 1s, 2s etc
You need a chart for this?
best wishes
 
B

Bernard Liengme

Use COUNTIF to count the number of 1s, 2s etc
You need a chart for this?
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opposite of Countifs 2
Access Newbie trying to create Access Database for survey data 0
excel sum values if cell matches a value 1
Rank If - SumProduct - HELP PLEASE 1
Lining up rows based on values 1
Analyze with excel (change access date format) 4
Rank Formula 1
What is ray tracing ? 1

Top