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