-
Rabia FaisalAsked on November 3, 2022 at 9:46 PM
how to calculate survey responses, scale of 1-5
-
Marlon_T Jotform SupportReplied on November 4, 2022 at 12:46 AM
Greetings,
Thank you for contacting Jotform Support. I understand that you'd like to create a computation for your scale survey form. In order to assist you with the detailed steps, could you please provide the form link where you'd like to apply these fields?
Let me show you how to do it:
- Insert a Form Calculation Widget to your form
- Click on the Widget Settings (the Wand icon) and then click on the Three Dots icon at the bottom of the numeric pad
- Find the function avg(), and then include all the star rating fields inside the parenthesis(), separated by a comma.
Result:
Give it a try and let us know if you need any help.
-
rabiafaisalReplied on November 4, 2022 at 1:50 AM
This is my form I need to calculate weighted average based on number of
responses
(no. of responses * 1 + no. of responses * 2 + no. of responses * 3 + no.
of responses * 4 + no. of responses * 5)/no of responses
for each of knowledge trait
... -
KrisLei Jotform SupportReplied on November 4, 2022 at 2:23 AM
Hi,
Thank you for providing additional information about your form. I can see that you have assigned the calculation values for each column:
To clarify, the calculation value is multiplied based on the user's selection for each trait, correct? For example, if the user selects Unsatisfactory for all the Knowledge traits, the computation would be:
(Historical Context = 1 (assigned value for Unsatisfactory) * 1 ) +
(Local Context = 1 (assigned value for Unsatisfactory) * 1 ) +
(Analytical Thinking = 1 (assigned value for Unsatisfactory) * 1) +
(Computer Skills = 1 (assigned value for Unsatisfactory) * 1)
Then the total would be 4 then, which will be divided by the number of responses. Is that correct? My apologies for the confusion, but can you elaborate more on "the no. of responses" you are referring to?
Once we hear back from you, we'll be able to help you with this.
-
rabiafaisalReplied on November 4, 2022 at 2:35 AMby No. of responses i mean the number of people filled the form
suppose only 3 people filled thi form then the calculation will be
Historical Context = (1 (assigned value for Unsatisfactory) * 1 + 2
(assigned value for Needs Improvement) * 1 + 3 (assigned value for
Satisfactory) * 1 + 4 (assigned value for Very Good) * 0 + 5 (assigned
value for OutStanding) * 0)/3
this will be (1*1+ 2*1+3*1)/3
(1+2+3)/3
6/3 = 2
same goes for Local Context, Analytical Thinking, and Computer Skills
... -
Jeric JotForm SupportReplied on November 4, 2022 at 2:50 AM
Hi rabiafaisal,
Thanks for reaching back to us. If I got is right, you are referring to the user who fill out the form separately. Unfortunately, the system won't be able to fetch the number of responses of the form to be included in the calculation. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better? -
rabiafaisalReplied on November 4, 2022 at 3:00 AMYes, I wanted to get the number of users who filled out the form for my
calculation.
Anyways, thanks for your help.
... -
CJ_GReplied on November 4, 2022 at 3:12 AM
Hello rabiafaisal,
Thanks for your response. I'm afraid it is not possible to use the number of responses inside the form for calculation. However, you may integrate your form with Google Sheets and then create the formula inside the Google sheet using Google Sheet functions.
Give it a try and let us know if you need help.