Solved

Average calculation

Forum|Forum|5 years ago
November 29, 2020
4 replies
2395 views

ABP

Hi there! I have a survey with 30 questions with the same answer scale (strongly disagree (1) ..., totally agree(5)). I need to calculate the average of 10 questions, for example, but when I try to create a new variable, I select function Average, but my 30 variables (questions) doesn't appear in the combo box for X, Y, etc. Just appear 3 other random variables like "progress", " latitude of location", "longitude of location". Can you help me, please?

Best answer by IsabelPosada_Voce

Hello ABP
You should try with Scoring, assign the score only to the questions that you want to get the average , once you have set up this, go to your survey flow and at the end of the survey create an Embedded Data Field, the name could be AverageQ and with the piped text assign the value that correspond to the average or mean.
Another option is to go to the data&analysis section, go to some column, click on create a new field, go to formula and create the average there, assign to each variable a question and divide it by the number of questions that you have.

Let me know if it works :)

A

ABP
Author
Forum|Forum|5 years ago
November 29, 2020

Hi there! I have a survey with 30 questions with the same answer scale (strongly disagree (1) ..., totally agree(5)). I need to calculate the average of 10 questions, for example, but when I try to create a new variable, I select function Average, but my 30 variables (questions) doesn't appear in the combo box for X, Y, etc. Just appear 3 other random variables like "progress", " latitude of location", "longitude of location". Can you help me, please?

Like

+57

IsabelPosada_Voce
QPN Level 5 ●●●●●
Answer
Forum|Forum|5 years ago
November 30, 2020

Hello ABP
You should try with Scoring, assign the score only to the questions that you want to get the average , once you have set up this, go to your survey flow and at the end of the survey create an Embedded Data Field, the name could be AverageQ and with the piped text assign the value that correspond to the average or mean.
Another option is to go to the data&analysis section, go to some column, click on create a new field, go to formula and create the average there, assign to each variable a question and divide it by the number of questions that you have.

Let me know if it works :)

Isa