View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MartinW[_2_] MartinW[_2_] is offline
external usenet poster
 
Posts: 168
Default How can I give a numerical value to a radio button?

P.S. I forgot to mention that you can also sum the amount of Yes's
for each question.

The quality of the result is reliant on the quality of the questions.
A well structured survey will provide the trainer with a very valuable
tool that will highlight exactly where he/she needs improvement
and also exactly where he/she has got it right.

HTH
Martin



"MartinW" wrote in message
...
Hi,

Those sort of surveys don't actually tell you what you want to know.
They tend to end up as a study of human nature. You will get lots
of 3's and plenty of 2's and 4's and a few 5's and 1's. Almost every
time your average will end up around 3 (maybe 2.5 to 3.5).
Despite what we all think of ourselves, in a group situation
we generally end up as sheep.

A far better way to assess your group is to use a lot of very precise
direct yes or no questions.

Did the trainer speak clearly? Yes No
Was the trainer clear for the "entire" presentation? Yes No
When fielding questions from the group did he repeat the question
clearly so that the entire group could hear it? Yes No
etc. etc.

You structure your questions so that a Yes is always positive
and a No is always negative. To analyse the results you just sum
the amount of Yes's in each survey and plot the results on any
of the myriad of charts that excel has to offer.

Jon Peltier has a huge selection to choose from here.
http://peltiertech.com/Excel/Charts/ChartIndex.html

HTH
Martin

"trainer07" wrote in message
...
I am building an evaluation sheet in Excel and want to know how I can give
a
numerical value to a radio button. For example, one of the question
reads,
"The trainer spoke clearly". and the option buttons read: Stronly
Agree,
Agree, Disagree, Strongly Disagree. I want to give the following values
to
each answer option: Strongly Agree = 5, Agree = 4, Disagree = 2,
Strongly
Disagree = 1 . My ultimate goal is to find the average score for all the
questions. Any assistance would be appreciated.
Thanks!