Learn about how columns can vary in the same or opposite direction, which is known as correlation.
- [Instructor] Correlation is a measure…of how the values of two variables change…with respect to each other.…For example, we can see in this screen that,…as the value of units sold increases,…the value of revenue increases as well.…Correlation considers how two columns change value together.…When the variables increase in value together,…they are considered correlated.…We just saw an example of correlated…or positively correlated…with revenues increasing…as the number of units sold increase.…
When one value increases and another decreases,…then we call those values negatively correlated.…An example of negative correlation…is the relation between a discount…on the sale price of a unit…and the revenue generated from the sale of that unit.…
- Define variance and standard deviation.
- Calculate discrete percentiles.
- Calculate continuous percentiles.
- Analyze correlations.
- Explore linear models, such as linear regression.
Skill Level Intermediate
SQL: Data Reporting and Analysiswith Emma Saunders2h 16m Intermediate
Advanced SQL for Data Scientistswith Dan Sullivan1h 24m Advanced
1. Basic Descriptive Statistics
2. Percentiles and Frequencies
3. Correlations and Ranks
4. Linear Models
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.