Percentile formula limited to lookup value in array in separate sheet

I have a dataset in Sheet 1 where the data forms a long vertical-scrolling list, i.e.

Percentile formula limited to lookup value in array in separate sheet

I have a dataset in Sheet 1 where the data forms a long vertical-scrolling list, i.e.

Excel: Percentile formula limited to lookup value in array in separate sheet

I have a dataset in Sheet 1 where the data forms a long vertical-scrolling list, i.e.