Explain the concept of percentiles in statistics, and how you would go about finding the nth percentile of a dataset? Can you write a code for finding the nth percentile of a dataset.

Question

Anonymous · Accepted Answer

If we have a sample dataset, then we say that n is in the 95% percentile if 95%
of the data is less than n.  For example the median is the 50th percentile.

Let's say we have a table, mytable with rows for each value of the data sample.
With rows as (select value, row_number(order by value) as row from mytable),
total as (select count(*) as mysum from mytable)
select value from rows, total
having round(row/mysum)=n

Explain the concept of percentiles in statistics, and how you would go about finding the nth percentile of a dataset? Can you write a code for finding the nth percentile of a dataset.

Practice this question with AI

Go Premium

Practice More Questions

Community Answers

Unlock Community Insights

Everything You Need to Ace DS Interviews