Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I use excel to tabulate survey results | Excel Worksheet Functions | |||
how can I use excel to tabulate survey results | Excel Worksheet Functions | |||
survey results tally | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) |