Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charting survey responses
A coworker has a survey she is sending out where one of the questions is to
rate your preference between 7 methods of contact (eg mailout, brochure, telephone call, etc) with 1 being most preferred and 7 being least preferred. She needs to chart this to see which method of contact is the most preferred. How can she chart something like this? I tried to help but the best I could think of was a bar or line chart where the highest column would be the least preferred (eg 7 people respond with '7' to that category = 49 points). Your help is appreciated! -- Thanks, GillianHG |
#2
|
|||
|
|||
On the assumption that bigger is better, I'd change your scale. first,
for each of the seven choices, I'd compute my averages. Then I'd use a formula like this to compute a score for each choice: Score = (7-Average)/6 The highest possible score is 100%, the lowest is 0%. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ GillianHG wrote: A coworker has a survey she is sending out where one of the questions is to rate your preference between 7 methods of contact (eg mailout, brochure, telephone call, etc) with 1 being most preferred and 7 being least preferred. She needs to chart this to see which method of contact is the most preferred. How can she chart something like this? I tried to help but the best I could think of was a bar or line chart where the highest column would be the least preferred (eg 7 people respond with '7' to that category = 49 points). Your help is appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
How to compile marketing survey form result into a chart | Excel Worksheet Functions | |||
Tabulating Survey Results | Excel Discussion (Misc queries) | |||
Charting time? help please... | Charts and Charting in Excel |