# Total up values for each Array (10-point) sub question and deriving stats

5 years 8 months ago - 5 years 8 months ago #62606 by nbv1
Hi,

I am going to tell you about the SURVEY structure before I ask the question.

I have one group that consists of 8 questions, which consists of approx.5 sub questions. In total, I have 41 sub-questions. which is under one group. These are Array (10-point) from 1 to 10.

Here is the question.

I was wondering if it is possible to find the total of each question and display the stats that show which questions have the highest rating.

Example : The following is one sub question.

Choice - Count (respondents)
1 - 0
2 - 3
3 - 0
4 - 0
5 - 0
6 - 1
7 - 1
8 - 0
9 - 0
10 - 0

The total would be 2*3 + 1*6 + 1*7 = 6+6+7 =19

Since, there are 41 sub-questions, the respondents answer all the sub-question. Each sub-question is going to have a different rating and hence the total is going to be different for each sub question.

I would like to know the total of each sub question and displayed in descending order.

Has anyone done this before or have a way doing it?

Hoping to hear from someone on this.

Cheers,
Last Edit: 5 years 8 months ago by nbv1.