analyzing survey date

B

bren

I am trying to find out how to get frequencies for answers to survey
questions. For example, how many people said yes to question 3.
 
F

Fred Smith

If you have a few frequencies to determine, look a the Countif function. If you
have many, you're probably better off creating a pivot table. Post back if
you're having trouble with either of these.
 
G

Gary's Student

Fred has the right idea. Pivot tables are the best way to summarize this
type of data. They can summarize with several different functions and the
results can easily be converted to percentages or percentiles
 
Top