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

# standard deviation from .....

### 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 .....

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.