Question: how do you calculate variance and standard deviation in excel?
Answer: Enter you data into Excel. ... 
If your data represents the entire population, enter the formula "=STDEV. ... 
The standard deviation will be displayed in the cell.