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!