Question: how to calculate variance and standard deviation on excel?
Answer: If you're using Excel 2007 or earlier, or you want your file to be compatible with these versions, the formulas are "=STDEVP(A1:A20)," if your data is the entire population; "=STDEV(A1:A20)," if your data is a sample from a larger population. The standard deviation will be displayed in the cell.