Calculate the avreage in a survey result

  • jmunozr3
    Asked on June 16, 2024 at 4:33 PM

    Hello, I am creating a survey and people have to answer in a scale form 1 to 5 but what I need is to let people see the results at the end of they responding, also, there are 16 questions in a scale from 1 to 5, I need the results to be sum and finally divided by 16, how do I do this? is it possible?

    link: https://form.jotform.com/241676266640057

  • Mafe_M JotForm Support
    Replied on June 16, 2024 at 5:40 PM

    Hi jmunozr3,

    Thank you for reaching out to Jotform Support. I checked the form and looks like it is already set up. In order to get the average, you will need to use the avg() math function. You will add it to the existing formula in the form calculation widget. Let me show you how:

    1. In Form Builder, click the form calculation widget and click the wand icon.
    2. Click the purple f(x) button and search for average.
    3. Use avg() math function.
    4. Click Save to apply the changes.

    Calculate the avreage in a survey result Image 1 Screenshot 40The formula will be like this:

    =avg((4. 1.Recurso contextualizado + 5. 2. Material adecuado/adaptado al nivel de inglés +6. 3. Diseño intuitivo + 7. 4. Precisión lingüística + 9. 5. Promueve el pensamiento crítico  + 10. 6. Actividades práctica +11. 7. Adaptabilidad (diferentes estilos de aprendizaj + 12. 8. Evaluación y/o retroalimentación + 14. 9. Accesibilidad (Disponibilidad del recurso)  + 15. 10. Adaptabilidad (Se puede utilizar en diferentes + 16. 11. Interactividad + 17. 12 Fácil navegabilidad  +  19. 13. Actividades de gamificación + 20. 14. Divertido y dinámico + 21. 15. Promueve la participación activa del estudiant + 22. 16. Explicación del tema))/ 16


    Also, please make sure that you will be using a period for the decimal point and not commas. Let show you how:

    1. In Form Builder, click the form calculation widget and click the wand icon.

    2. Click the gear icon for options.

    Calculate the avreage in a survey result Image 2 Screenshot 51

    3. Uncheck the tick box form, Use Commas for Decimal Point.

    4. Click Go Back and click Save to apply the changes.

    Calculate the avreage in a survey result Image 3 Screenshot 62

    Give it a try and let us know how it goes.

  • jmunozr3
    Replied on June 17, 2024 at 11:50 AM

    Thank you so much, I appreciate it.

 
Your Answer