How to calculate standard deviation of these numbers?

Question

45.50092764
28.54510184
21.98143406
17.91780822
16.22381477
15.14356283

------------

I have a lad report, I know how to use excel to calculate to get the result but I don't know how to get the result by calculating without excel.

Answer 1

add them up, divide by 6 - that's mean.

subtract mean from every number, square each result, add them up, divide by 5, take square root.

6 is how many numbers you have. 5=6-1; you can divide by 6 in the last step too, but it is less precise.

Also, a statistician will say that 6 observations is way too few to do the kind of statistical analysis that uses standard deviation.

Answer 2

Um, what grew to become into the advise? the standard deviation by using itself would not quite advise something. yet, this sounds very severe, such as you in line with threat have undesirable records (i.e., you made a length blunders). you may tell from observing your numbers: are they in each and every single place? Or are you handling enormous (nutrition) energy or little (technological information) energy? (Stupidly, a million nutrition calorie = one thousand technological information energy) in the event that they're the small energy, that's probable completely superb. the standard deviation tells you techniques a lot your numbers bounce around.

Answer 3

Find the average of the numbers, call it m. Subtract each datum (x1, x2, ...) from m, and square what you get. (m - x1)², (m - x2)², and so on. Find the average of these squares, Σ(m - xi)²/6. Finally, take the square root. That's the std dev.

Answer 4

ick, I don't think there is a way? Does using your calculator instead of excel count as work, that's how we did it.

Answer 5

first of all, you have to determine the mean. then for each data we can formulate it as

add (x-y)^2 from x1 to xN
then divide above line's result by N
then sqrt

x=data
y=mean
N=data amount