Calculations

I have a quiz that is divided into sections. Each section has 4 questions. Each question has a response and associated value.

I would like to calculate the average for each section. Each question is set up in a drop down answer list with 5 options as a response where the customer has to select one response. Each response has a value/score associated with it. The number field gets me really close to what I am looking to do:

({Question One:1:value} + {Question Two:2:value} + {Question Three:3:value} + {Question Four:4:value}) / 4

The problem is that the value is not the value the customer entered as their response for each question. It is the value listed in the string above.

What do I need to do to make the scoring work based on the customer's selected answer?

Hi Rob,
I just emailed you the quiz in 2 formats. The unscored version and the copy where I am attempting to get the scoring working correctly. The unscored version is live and I am manually scoring it and sending results to quiz takers.

I also emailed you an example that includes 2 completed quizzes from 2 quiz takers showing how I am manually scoring the quiz.

A bonus for me would be to convert the scores to the word representing that numerical score. I.E. if overall score is 4, then that would equate to Satisfied. If a section score is 2 then that is Unsatisfied. I will manually have to send the score key to the quiz takers unless there is a way to send the corresponding word value.

THANK YOU!