MySQL includes some built-in functions for calculating statistics. We covered SUM, AVG, MIN, and MAX earlier in the chapter. Let's learn about a couple of built-in functions that are helpful in calculating statistics.
Using statistical functions
Learning how to use built-in statistical functions
To calculate standard descriptive statistics, you can use the following built-in functions in addition to the ones previously learned:
- VARIANCE—This gives you the variance of your data, which calculates what the difference is for each point and the mean of all the points. If zero is returned, then all the data points are the same. A larger value returned means that individual data points are farther from the mean.
- STDDEV...
