-
Keith_WhitakerAsked on October 27, 2020 at 8:29 PM
Form Calculation doesn't seem to offer these functions.
-
Dagmar_BReplied on October 28, 2020 at 1: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.
-
Keith_WhitakerReplied on October 28, 2020 at 4: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!
-
Jovanne JotForm SupportReplied on October 28, 2020 at 6: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.
-
Keith_WhitakerReplied on October 28, 2020 at 7:05 PM
Thanks for the confirmation.