From the course: MySQL for Advanced Analytics: Tips, Tricks, & Techniques

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Descriptive statistics

Descriptive statistics - MySQL Tutorial

From the course: MySQL for Advanced Analytics: Tips, Tricks, & Techniques

Start my 1-month free trial

Descriptive statistics

- [Instructor] One of the most popular and basic analysis that is done in every data science project is to do descriptive statistics for the variables in question. In this video, I will show you how to do that with MySQL. Let us now open the exercise file Descriptive Statistics that contains the commands and SQL for this case. Fortunately, MySQL does come with a great stack of statistical functions. MySQL supports functions for Min, Max, Variance, and Standard Deviation. They can also be used to find statistics for any numeric variable. Alternatively, you can also use these functions to do additional computations and formulas, like we do here for covariance in line number 12. We summarize this data by salary range to do these statistics by that range. So let us go and execute this SQL statement. So what you see here under results is that we have here the duration column summarized by salary range. We have the mean for the duration column, the minimum value, maximum value, the…

Contents