Learn about continuous percentiles and how to compute them.
- [Instructor] The discrete percentile function…returns the value of the first value…that exceeds the percentile in an ordered list of values.…This function will always return a value…that's in the dataset.…Now, if you're more interested in knowing…the boundaries of the percentile buckets,…then the continuous percentile function can tell you that.…The boundaries are equal size,…and the values and the columns don't necessarily fall…exactly on those boundaries.…When that happens, the continuous percentile function…interpolates the boundary value.…
Let's look at an example.…Let's select the percentile,…and instead of using discrete…we use the continuous percentile,…and let's work with a 95th percentile.…And that's within the group…that's specified by order by revenue.…So this is similar to what we saw on the previous video,…except now, we're using percentile continuous,…instead of percentile discrete.…
So let's give this an alias.…We'll call that percentile 95 continuous revenue.…Let's compare this to the discrete percentile,…
- 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.