VARP

 The VARP function in Excel is used to calculate the variance of a population based on the entire set of numbers. Variance measures how far a set of numbers are spread out from their average value. Below are 10 examples of how to use the VARP function, including sample data and formulas.

Example 1: Basic Usage

Data:
A1:A5 = {10, 20, 30, 40, 50}

Formula:
=VARP(A1:A5)

Result:
250

Example 2: Variance of a Small Dataset

Data:
B1:B3 = {5, 7, 9}

Formula:
=VARP(B1:B3)

Result:
2.6667

Example 3: Variance with Negative Numbers

Data:
C1:C4 = {-2, 0, 2, 4}

Formula:
=VARP(C1:C4)

Result:
5

Example 4: Variance of a Single Column

Data:
D1:D6 = {12, 15, 14, 13, 16, 11}

Formula:
=VARP(D1:D6)

Result:
2.9167

Example 5: Variance of a Row

Data:
E1:J1 = {3, 6, 9, 12, 15, 18}

Formula:
=VARP(E1:J1)

Result:
22.5

Example 6: Variance with Decimal Numbers

Data:
F1:F5 = {1.2, 2.3, 3.4, 4.5, 5.6}

Formula:
=VARP(F1:F5)

Result:
2.024

Example 7: Variance with Zero Values

Data:
G1:G4 = {0, 0, 0, 0}

Formula:
=VARP(G1:G4)

Result:
0

Example 8: Variance with Text and Numbers (Text Ignored)

Data:
H1:H5 = {10, "Text", 20, 30, 40}

Formula:
=VARP(H1:H5)

Result:
125

Example 9: Variance with Logical Values (TRUE=1, FALSE=0)

Data:
I1:I4 = {TRUE, FALSE, TRUE, TRUE}

Formula:
=VARP(I1:I4)

Result:
0.1875

Example 10: Variance with Mixed Data Types

Data:
J1:J6 = {10, "Text", 20, TRUE, 30, FALSE}

Formula:
=VARP(J1:J6)

Result:
125

Explanation:

• VARP calculates the variance based on the entire population.

• If the data contains text or logical values, they are ignored in the calculation.

• Logical values (TRUE/FALSE) are treated as 1 and 0, respectively.

• The formula for variance is:

  $$\text{VARP}=\frac{\sum (x_i-\mu {)}^2}{N}$$

  where $\mu$ is the mean of the population and $N$ is the number of data points.

These examples should help you understand how to use the VARP function in various scenarios.