Question: how to find standard deviation and variance in excel?
Answer: Ensure your data is in a single range of cells in Excel.
If your data represents the entire population, enter the formula "=VAR. ... 
The variance for your data will be displayed in the cell.