I'm trying to display the "mode" of multiple questions

  • Profile Image
    Hashmi_Sam
    Asked on November 21, 2020 at 06:07 PM

    Hello,


    I have a survey with multiple questions that answer in numbers. I am hoping to have a final question (or result) that shows the mode of previous questions.


    For example, if the answers to the first four questions is 1,2,2,7

    Then, I want to automatically calculate the mode, or the most common number, from the answers of these questions (which is 2).

    This is different than the average of the answers (which is 3).


    Is there anyway I can do this?

  • Profile Image
    gerardw
    Answered on November 21, 2020 at 10:07 PM

    I have been checking your requirement, but the closest we have is using a count() function in a Form calculation widget. But this only counts the selections you have made in the multiple-choice field.

    It is, however, not possible to directly calculate the mode using this option.

    You will need to download the submissions as an excel file and then use the functions on EXCEL.