Insightful post indeed! You are completely right, To calculate as weighted percentile we need two values. One column with the data and one column with the weight. The permanent rule in statistics is that the 100th weighted percentile is the largest data value at any cost and in any situation. Thanks for sharing.