What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to Calculation Standard Deviation of the Numbers

    Asked by riskosoft on September 25, 2014 at 07:46 PM

    I need to use the calculate form and use the standard deviation for my work.

    Can you explain to me how i can make it ?

    Standard Deviation Deviation
  • Profile Image
    JotForm Support

    Answered by EltonCris on September 26, 2014 at 02:31 AM

    Hi,

    We do not have direct solution for this but let me check and verify it first if the calculation wizard is capable to handle standard deviation.

    Stay tuned for updates. Thanks!

  • Profile Image
    JotForm Support

    Answered by EltonCris on September 26, 2014 at 02:39 AM

    Looks like it's possible but it requires few calculation widgets to get it done.

    Kindly check and clone this form so you can see the hidden calculation fields and formulas.

    http://form.jotformpro.com/form/42680933363963?

    Try it with 2 and 3 numbers and compare the results. I am using this calculator: http://www.mathsisfun.com/data/standard-deviation-calculator.html

    Hope this helps!

  • Profile Image

    Answered by riskosoft on September 26, 2014 at 07:37 AM

    Thank you for your message, but i have a différent Result with EXCEL

    Look i have calculate the standard deviation with EXCEL and When i look your FORM the result is Different, What do you think ?

  • Profile Image

    Answered by jedcadorna on September 26, 2014 at 08:34 AM

    I'm still trying to understand the formula of STDEV so I'm not sure which is the correct one. Can you please show the sample formula in your Excel so we test using the calculation wizard.

    Here's how I understand the formula.

    Number 1 + Number 2 / 2

    Number 1 - 2 (mean)

    Number 2 - 2 (mean)

    Diff of num 1 - 2 Squared + Diff of num 2 - 2 Squared

     

    Calculate the standard deviation:

    Sum of Squared 1 + Squared 2 / mean - 1

     

    Here is my reference http://standard-deviation.appspot.com/.

  • Profile Image

    Answered by jedcadorna on September 26, 2014 at 08:40 AM

    I used an online calculator to compute for STDEV and it seems the formula created by my colleague Elton is fine. Please try inputting a number here http://easycalculation.com/statistics/standard-deviation.php.