How can I give a numerical value to a radio button?

[trainer07]

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!

 

[Dave Peterson]

You may want to look at this survey form from Debra Dalgleish's site:
http://contextures.com/xlForm01.html

 

[MartinW]

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

 

[MartinW]

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

 

[Rick Rothstein \(MVP - VB\)]

Where is the value of 3? Anyway, to answer your question... I presume these
OptionButtons are grouped in some way (otherwise your user would be able to
select more than one at a time). Because only one OptionButton can be
selected at a time, just multiply each OptionButton's value (0 if not
selected, 1 if select) by its value and sum them up... the value returned
will be the OptionButton's value. Let's assume the OptionButton's are named
this way...

Strongly Agree button --- Opt1
Agree button ------------ Opt2
Disagree button --------- Opt3
Strongly Disagree ------- Opt4

Then the value the user selected can be found like this...

UsersValue = 5 * Opt1.Value + 4 * Opt2.Value + 2 * Opt3.Value + Opt4.Value

Remember... only one of the Opt{n}.Values will be 1 and the rest will be 0.

Rick