Standard Deviation in Excel Help?

Question

What do I input into standard deviation aka what's number 1 and whats number 2?

I am examining the health of various populations and in each column from a-x I have the population total, number of hiv/aids infection, diabetes, etc. I have already calculated the mean under each disease/population column.

My professor said he wants to know the standard deviation, but I have no idea what it is!

Help, definition, assistance! Thanks!

Answer 1

This should do you:

http://www.cvgs.k12.va.us/DIGstats/main/Guides/g_StandardDeviationExcel.htm

Standard Deviation is the measure of how uniform, or dispersed your data points are, probably assuming a normal distribution (bell curve).

Answer 2

In Microsoft Excel the standard deviation is computed from STDEV( list of values ). For example, if you want the standard deviation for the values in rows 3 - 30 of column C, type

=STDEV(C3:C30)

in the cell you want to see that value

Answer 3

For the mean you used "=average(b1,b2,b3...)" for standard deviation use "=stdev(....)" of the same cells. Look under "Insert, Function" on the tool bar in Excel.

And read:
http://en.wikipedia.org/wiki/Standard_deviation

Answer 4

to not sure. i do no longer understand why you're including the .5 exponent. What you have completed is you have gotten the accepted deviation for each month, and then accelerated it via 12 (returned, i do no longer understand why you have a .5 exponent). i do no longer see the income of multiplying it via 12. i think of basically the STDEV(A1:A12) is sufficient, via incontrovertible fact that's supplying you with the accepted deviation of the each and each month from one month to the subsequent, for one 365 days. ultimate,