1 Reply Latest reply on Nov 4, 2011 8:07 AM by philmodjunk

    standard deviation from .....

    KoosVanRaalte

      Title

      standard deviation from .....

      Post

      the formula is needed for the following result:

      1:
      Mainstream is 1 standard deviation of the average
      average is 56
      what number is the standard deviation?

      2
      Passion is two standard deviations of the average
      average is 56
      what number is 2 standard deviation

      3:
      extreme is 3 standard deviations of the average
      average is 56
      Which number is the 3 standard deviation

      4:
      Indifferent is 2 standard deviations below the avarage
      average is 56
      What number is two standard deviations below the avarage

      How do I set this in the database? make it work ?

        • 1. Re: standard deviation from .....
          philmodjunk

          Do you just have the average or the data used to compute the average? Without the original data, you can't determine the standard deviation. Different number sets with very different standard deviations can have the same mean (average) so you can't work backwards from the average.

          If you have the original data in separate records, you can use a summary field to compute the standard deviation.