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

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?

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.