Skip to main content

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! 

@Tomas - welcome to the community

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


@Tomas - welcome to the community

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:?

 


@Tomas - essentially yes, you are on the right track but need a little adjustment to the logic

  • 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

 


@Tomas - essentially yes, you are on the right track but need a little adjustment to the logic

  • 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! 


Hey @Tomas! Don't forget to let us know if it worked and to share the link of your form! Have a nice week! :wink:


Hey @Tomas! Don't forget to let us know if it worked and to share the link of your form! Have a nice week! :wink:

Hey @Gabi Amaral  @john.desborough ,

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! :pray_tone1:


Hey @Tomas! Don't forget to let us know if it worked and to share the link of your form! Have a nice week! :wink:

Hey @Gabi Amaral  @john.desborough ,

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! :pray_tone1:

Well, I did it! :fist_tone1:

It was a struggle! Thanks again so much for your help! 

Here is the link of my form:

 


@Tomas - congratulations.. glad you got it to work out.. keep the faith! what you learned you can leverage over and over again in other typeforms.. 

 

cheers

 

des


Hey @Tomas! I couldn't agree more with John! 

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! :wink:


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”???


@Gabi Amaral @john.desborough 

 

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 @john.desborough 

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? 🙏
 



 

 


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