Question: how to calculate variance and standard deviation using 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.