# MySQL VAR_POP() function

## VAR_POP() function

MySQL VAR_POP() function returns the population standard variance of an expression. Population variance is a statistical measure that quantifies the average squared deviation of values from the mean in a dataset.

This function is useful in -

- VAR_POP() quantifies the spread or dispersion of values around the mean (average) in a dataset.
- The population variance helps you understand the variability or dispersion of data points within the entire population.
- When analyzing data, VAR_POP() helps assess the distribution of values and provides an indication of the typical deviation from the mean.
- Population variance is used in inferential statistics to make inferences or predictions about the entire population based on the characteristics of the sample.
- Population variance can use to compare the variability of different populations or datasets and assess their similarity or difference.
- Population variance is used to assess the significance of differences between groups or populations.
- Population variance is used to calculate confidence intervals for population parameters.

** Syntax**

VAR_POP(expr);

Where **expr** is an expression.

**MySQL Version:** 8.0

**Example: VAR_POP() function**

The following statement returns the population standard variance of 'total_cost' from purchase table.

Sample table: purchase

Code:

```
SELECT VAR_POP(total_cost)
FROM purchase;
```

Output:

mysql> SELECT VAR_POP(total_cost) -> FROM purchase; +---------------------+ | VAR_POP(total_cost) | +---------------------+ | 99472.222222 | +---------------------+ 1 row in set (0.00 sec)

**Previous:**
SUM() with group by

**Next: **
VAR_SAMP()

**Weekly Trends**- 100 Python Projects for Beginners with solution
- Mastering NumPy: 100 Exercises with solutions
- SQL Tutorial
- SQL Inner Join
- Python Exercises, Practice, Solution
- Python Interview Questions and Answers: Comprehensive Guide
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript HTML Form Validation
- Java Collection Exercises