Five fictional queue times are 5, 10, 15, 20, and 25 minutes. Enter them in B2:B6 and use =PERCENTILE.INC(B2:B6,0.9).

Locate the cutoff between the last two observations

The inclusive position is 1+0.9*(5-1), or 4.6. That is 60% of the way from the fourth value, 20, to the fifth value, 25. The expected result is 23 minutes.

The 90th percentile is 60 percent of the way from 20 to 25.

Illustrated interpolation. The cutoff can fall between observed times.

Test the endpoints and write down the sample size

Change the second argument to 0 and 1 in scratch cells. The results should be 5 and 25. Report the sample as “90th percentile: 23 minutes across 5 observations.” Use the same percentile convention before comparing periods, and check for blank or text inputs.

A scratch formula with k = 0 returns 5, and k = 1 returns 25.

Illustrated endpoint check. Use the same input range.

Microsoft’s PERCENTILE-INC function reference