In statistical terms, how do you interpret percentiles, and how would you compute the nth percentile in a data sample? Can you code this?

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

In statistical terms, how do you interpret percentiles, and how would you compute the nth percentile in a data sample? Can you code this?

Answers

Unlock Community Insights

Try Free AI Interview

Google

Product Manager

Meta

Product Manager

Meta

Engineering Manager

Amazon

Data Scientist