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 - MySQL Tutorial
From the course: MySQL for Advanced Analytics: Tips, Tricks, & Techniques
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.