Enter your data in a single row or column
Use `=VAR.S(range)` for sample variance
Use `=VAR.P(range)` for population variance
Replace `range` with your cell range, such as `A1:A10`
Press Enter to calculate the variance
Use `=VARA(range)` if your data includes logical values or text
Use `=VAR.S(A1:A10)` for a sample
Use `=VAR.P(A1:A10)` for a population