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!