Is there a widget to calculate median and mode for a list of numbers within a form?

  • Profile Image
    Keith_Whitaker
    Asked on October 27, 2020 at 08:29 PM

    Form Calculation doesn't seem to offer these functions.

    Screenshot
  • Profile Image
    Dagmar_B
    Answered on October 28, 2020 at 01:58 AM

    Hello,

    You are right, the widget does not offer those two results.

    Could you tell us what form you are referring to if you want to use them on a specific form?

    However, you could create a workaround using the fields you would like to get the mode or the median of and create a set of Conditional logic by which other hidden fields for the answers and count them that way.

    https://www.jotform.com/help/57-smart-forms:-conditional-logic-for-online-forms

    Let's say you have answers A,B,C,D,E on a few fields, and they always have the same value (A=1,B=2,...)

    With a hidden field for each number and a condition to add one if that answer is checked each time. You have then 5 fields that you can compare to see where the desired results lay.



  • Profile Image
    Keith_Whitaker
    Answered on October 28, 2020 at 04:00 PM

    Thanks, Dagmar.

    Here's a simple example of the type of form I have in mind: https://www.jotform.com/build/202984483690062. There are three Likert-scale questions followed by (hidden) form calculation blocks.

    What I want to do is to identify the median and mode across multiple individual respondents' responses. (E.g., for question 1, half of respondents answered "Strongly Agree." Or for question 2, the greatest number of responses was "Disagree.")

    Maybe that is something I will have to do in Excel once I download the collected responses. Or is it possible to do that calculation within JotForm's Submission page or Report Builder? That would save me the step of downloading to Excel, building the function in Excel, and then uploading the results into Report Builder.

    Thanks for any additional insight!



  • Profile Image
    Jovanne_A
    Answered on October 28, 2020 at 06:42 PM

    Hi, thank you for getting back to us.

    If you are planning to have the median and mode against all responses' scores, unfortunately, that is not possible with our Form Calculation widget or in the Report Builder.

    The efficient way to do this is to download the submissions to Excel, create a function in Excel to find the median and mode, and then upload the results into Report Builder, as you have mentioned.

    I hope this will help. Let us know if you have further questions.

  • Profile Image
    Keith_Whitaker
    Answered on October 28, 2020 at 07:05 PM

    Thanks for the confirmation.