VARP function
Calculation — variance based on the entire population.
Compatibility
Where can you use it?
Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.
Scenario in the workbook
Verify a legacy population variance calculation using the entire set of readings.
A worked example from the workbook
| Row | A | B | C |
|---|---|---|---|
| 6 | Period 1 | Period 2 | Period 3 |
| 7 | 2 | 4 | 6 |
| 8 | 3 | 3 | 3 |
| 9 | 0 | 3 | 6 |
Record 1
=VARP(A7:C7)Expected result2.666666667
See the inputs and instructions for all 3 examplesSyntax
VARP(number1,[number2],...)
Copyable formulas
English Excel · en-US
=VARP(A7:C7)Turkish Excel · tr-TR
=VARS(A7:C7)Compatibility function for older workbooks.
Worked examples
Verify a legacy population variance calculation using the entire set of readings.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B | C |
|---|---|---|---|
| 6 | Period 1 | Period 2 | Period 3 |
| 7 | 2 | 4 | 6 |
| 8 | 3 | 3 | 3 |
| 9 | 0 | 3 | 6 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =VARP(A7:C7) |
2.666666667 |
| Record 2 | =VARP(A8:C8) |
0 |
| Record 3 | =VARP(A9:C9) |
6 |