Question: how to calculate the standard deviation in excel 2007?
Answer: To find standard deviation of a population, use the STDEV. P function in Excel 2010 and later; STDEVP in Excel 2007 and earlier. If you want logical or text values to be included in the calculation, use either STDEVA (sample standard deviation) or STDEVPA (population standard deviation).