Data Analysis

I would like to have a discussion regarding the use of Excel's Percentile function when the data are highly correlated and not independent.