General Question

srmorgan's avatar

How do I do this statistical calculation?

Asked by srmorgan (6773points) September 22nd, 2013

I took statistics over 35 years ago and I don’t remember this.

I have a population of data, 130 instances. My average is 1500 and my standard deviation =stdevp () is 611.
Which values are one standard deviation away from the mean and which values are two standard deviations away from the mean.

I can’t find a 2nd standard deviation function in Excel.

Thanks

Observing members: 0 Composing members: 0

2 Answers

drhat77's avatar

2 standard deviations for this population is 611×2 = 1222

drhat77 (6197points)“Great Answer” (2points) Flag as…
nikipedia's avatar

The good dr up there is correct. So the values that are 1 standard deviation away from the mean are the numbers between (mean – 1 standard deviation) and (mean + 1 standard deviation, and the values that are 2 standard deviations away are between (mean – standard deviation*2) and (mean + standard deviation*2).

Mean +/- 1 SD = 889 to 2111
Mean +/- 2 SDs = 278 to 2722

nikipedia (28098points)“Great Answer” (3points) Flag as…

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther