MySQL VARIANCE() function

VARIANCE() function

MySQL VARIANCE() function returns the population standard variance of an expression. It considers the entire dataset rather than just a sample. Variance is a statistical measure that indicates the spread or dispersion of a dataset.

This function is useful in -

  • It's essential for understanding the distribution of data.
  • High variance indicates greater dispersion, while low variance suggests data points are closer to the mean.
  • Variance can identify outliers or extreme values in dataset. Unusually high variances might signal data quality issues or anomalies.
  • In finance and investment, variance is used to assess the risk associated with an investment.
  • Variance can be used to analyze the consistency of performance metrics. It might indicate how consistent the product quality is.
  • Variance analysis is crucial in scientific experiments and research. It helps assess the reliability of results and the consistency of measurements.
  • In industries like manufacturing, calculating variance can be part of quality control processes.
  • Variance can be used to compare different datasets or groups.
  • Variance analysis can play a role in forecasting future outcomes by considering historical variability.



Where expr is an expression

MySQL Version: 8.0

Example: MySQL VARIANCE() function

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

Sample table: purchase


SELECT  VARIANCE(total_cost)              
FROM purchase;


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

Previous: VAR_POP()
Next: Introduction of MySQL functions and operators

Follow us on Facebook and Twitter for latest update.

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook