| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i create option Boxes for a survey on excel?? | Excel Discussion (Misc queries) | |||
| How do I analyze data from a survey in excel | Excel Worksheet Functions | |||
| How to apply survey weightings | Excel Discussion (Misc queries) | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
| Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) | |||
Threaded Mode
