How To Get Variance In Excel?

Use `=VAR.S(range)` for sample variance

Use `=VAR.P(range)` for population variance

Select an empty cell

Type the variance formula with your data range

Press Enter

Replace `range` with your actual cells, such as `A1:A10`

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 an entire population

Suggested for You

Trending Today