Charting survey responses

[GillianHG]

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!

 

[Jon Peltier]

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/
_______