How to Calculation Standard Deviation of the Numbers

  • riskosoft
    Asked on September 25, 2014 at 7: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 ?

  • Elton Support Team Lead
    Replied on September 26, 2014 at 2: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!

  • Elton Support Team Lead
    Replied on September 26, 2014 at 2: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!

  • riskosoft
    Replied on September 26, 2014 at 7: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 ?How to Calculation Standard Deviation of the Numbers Image 1 Screenshot 20

  • jedcadorna
    Replied on September 26, 2014 at 8: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/.

  • jedcadorna
    Replied on September 26, 2014 at 8: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.

    How to Calculation Standard Deviation of the Numbers Image 1 Screenshot 20