Hello,
can you give me some advice, please?
I have 20 questions in Typeform with 1-5 answer choices (I use the "Opinion Scale" type). After filling in all the answers, I need to calculate the arithmetic average of the answers and then display a rating page at the end of the questionnaire based on the resulting number. (there is always a different final page for number 1,2,3,4 and 5)
In excel I would use the formula "=AVERAGE(A2:E21)", but how to calculate it in Typeform?
Thank you for your help!
Answered
How to calculate the arithmetic average of the answers?
+1Best answer by john.desborough
- create a variable call it v_total as numeric with default of 0
- in q1 your logic rules would be something like this:
- if q1 = 1 then add 1 to v_total
- if q1 = 2 then add 2 to v_total…
- repeat for for each question - this will add the selected number from each answer to the variable
- then at the end you create this logic rule:
- if v_total is greater than 0 then divide v_total by X (where X is the number of questions)
- then you can use the @recall function to display the average - @v_total will now be the average (total of all the points divided by the number of questions
hope that helps
+6- Certified Partner & Champion
- 5294 replies
you need to add the scores into a subtotal variable and then divide by the number of questions - it is a simple series of logic rules to put in place inTypeform but it would be nice to have functions like that available, i agree
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
1 person likes this
+1john.desborough wrote:
you need to add the scores into a subtotal variable and then divide by the number of questions - it is a simple series of logic rules to put in place inTypeform but it would be nice to have functions like that available, i agree
des
Thanks for the reply, John.
I'm afraid I don't understand, though. I haven't set up rules yet, I've only produced simple forms so far.. can you please describe this in more detail - where do I set up the rules and how? I have browsed through the tutorials, but this is nowhere to be found.. :-(
I am sending a screenshot with one question. I should probably define somewhere what happens when a specific number is selected, right?
Do I have to set the "if - than" rule again for each question for all numbers? like this:?
+6- Certified Partner & Champion
- 5294 replies
- Answer
- create a variable call it v_total as numeric with default of 0
- in q1 your logic rules would be something like this:
- if q1 = 1 then add 1 to v_total
- if q1 = 2 then add 2 to v_total…
- repeat for for each question - this will add the selected number from each answer to the variable
- then at the end you create this logic rule:
- if v_total is greater than 0 then divide v_total by X (where X is the number of questions)
- then you can use the @recall function to display the average - @v_total will now be the average (total of all the points divided by the number of questions
hope that helps
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
+1john.desborough wrote:
- create a variable call it v_total as numeric with default of 0
- in q1 your logic rules would be something like this:
- if q1 = 1 then add 1 to v_total
- if q1 = 2 then add 2 to v_total…
- repeat for for each question - this will add the selected number from each answer to the variable
- then at the end you create this logic rule:
- if v_total is greater than 0 then divide v_total by X (where X is the number of questions)
- then you can use the @recall function to display the average - @v_total will now be the average (total of all the points divided by the number of questions
hope that helps
OK, now it's a little bit clearer to me. I will try it. Thanks for the help!
+5Hey 
+1Gabi Amaral wrote:
Hey
Hey
I am sorry, I'm still lost.
My form can already add up the points for all the questions, that's great. But I don't know what to do next.
If I set the rule "if v_total is greater than 0, then divide v_total by X (where X is the number of questions)", it will calculate the average, but the @recall function still shows 0 - I don't know how to set it.
On the next page I need to set the @recall function to display the rounded average to whole numbers.
I need to set the rule "if @recall is equal to X , then jump to page 'Resume X'" (where X is the number 1,2,3,4 or5)
Thank you for your time, I really appreciate it! 
1 person likes this
+1Tomas wrote:
Gabi Amaral wrote:
Hey
Hey
I am sorry, I'm still lost.
My form can already add up the points for all the questions, that's great. But I don't know what to do next.
If I set the rule "if v_total is greater than 0, then divide v_total by X (where X is the number of questions)", it will calculate the average, but the @recall function still shows 0 - I don't know how to set it.
On the next page I need to set the @recall function to display the rounded average to whole numbers.
I need to set the rule "if @recall is equal to X , then jump to page 'Resume X'" (where X is the number 1,2,3,4 or5)
Thank you for your time, I really appreciate it!
Well, I did it! 
It was a struggle! Thanks again so much for your help!
Here is the link of my form:
+6- Certified Partner & Champion
- 5294 replies
cheers
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
+5Hey
Wishing you the best of luck with your form and the next ones as well. Make sure to share them with us as soon as you build new ones. Hope you have a great day! 
Everyone you meet is fighting a battle you know nothing about. Be kind. Always. =)
1 person likes this
I have the same issue, but I can´t find out, how to display the average score in the end? How do I do that. When I use the recall-function, it only allows me to choose my “totalscore”???
creating a new subtotal variable when type form has built-in scoring seems really laborious.
Why can’t we use @score, assign values to our all of our options using the interface type form has already built, and then *only on the last question* do something like:
if score > 0, set mean_score to score/n?
I understand I could follow the steps here to manually recreate the value assignment and division, but I have a 7-option likert survey across many, many questions (and multiple surveys on which I want to auto-score and display). This will take forever with the logic builder.
Hi
I have a similar problem, and now I’m stuck to calculate an average, multiply that value and then send the user to a different ending page.
To be specific, I have a multiple choice question and I assigned a value to each answer to add up into a variable subtotal.
This is the formula:
Final Score = AVERAGE (SUM OF ALL ANSWERS) * 10
ie.
The sum of all the 34 answers = 32
The average is .94 (32/34)
I multiply .94 * 10 = 9.4
9.4 is my final score and based on this I assign a different ending page. (In total I have 4 possible endings, in which I want to show the final score)
Here is a screen of my rules.
I am struggling in doing that formula while putting the logic conditions of the ending. (I am using a statement question). Since I already have a set of conditions, I don’t know exactly where to set the rule of multiply by then and then divide by 34.
Can you help me? 🙏
1 person likes this
So, this was very helpful for me, thanks.
However, I had different categories that I wanted to present the average for not just one final average.
When applying your answers above I needed to make sure to apply the division of v_total on the last question of each category for the @recall function to work correctly on my ending page.
Hope that helps others who are searching for average of categories :)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.