Averaging survey results
 

I would like to find the average response to a particular survey question
over the course of a three month period and show it as a %. So for the
following data what was the average response to Question #1. I know that in
January 33% of the respondents answered A, another 33% B, and another 33% C.
But how do I calculate the quarterly average response %?

Question #1:
A B C D F
January 1 1 1
February 11 2
March 6 3

Many thanks for your help!

Averaging survey results
 

=SUM(B3:B5)/SUM($B3:$D5), format the cell as percentage, and copy across to
the other two columns.
--
David Biddulph

"jmstut" wrote in message
...
I would like to find the average response to a particular survey question
over the course of a three month period and show it as a %. So for the
following data what was the average response to Question #1. I know that
in
January 33% of the respondents answered A, another 33% B, and another 33%
C.
But how do I calculate the quarterly average response %?

Question #1:
A B C D F
January 1 1 1
February 11 2
March 6 3

Many thanks for your help!