View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmstut jmstut is offline
external usenet poster
 
Posts: 1
Default 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!