Analyze Survey Questions
 

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

Analyze Survey Questions
 

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

"Michael" wrote:

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