Analyze Survey Questions

M

Michael

Previous posted on microsoft.public.excel ......

Hi Folks - I need to provide counts and percentages of survey data. If
Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many
1's, 2's, etc., plus calculate the percentage of the counts to the total
number of answers.

The data looks like this:

Q1 Q2 Q3 ...... etc.
1 2 5
2 3 2
5 1 4

etc.

In the past, I have inserted a blank column between the questions, then used
COUNTIF to count the answers in the Question column, and I have used the
blank column to calculate the percentages. It takes a awhile to setup, so I
was hoping there might be a better way using a pivot table. Any ideas?
Thanks.

Michael
 
G

Guest

Hi Michael

It may be that the worksheet function Frequency is helpful here to analyse
the numbers of the answers with bins_array 1, 2, 3, 4, 5.

Anthony
 

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

Analyze Survey Questions 3
Counting Survey Questions 2
Histogram/Frecuency for Multiple Response Questions 1
Analyze Survey Results in Access - Matrix form 0
excel sum values if cell matches a value 1
Analyzing survey results 6
How can I count deviations between two rows? 3
Excel Average dates help 0

Top