|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-27-2005, 01:05 PM
|
|||
|
|||
|
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
05-27-2005, 05:05 PM
|
|||
|
|||
|
Re: Charting survey responses
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!
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
