Hello Everyone,
I have a quick question. I am using Excel to do some statistical modelling and I am wondering if anyone knows if the PERCENTILE function in Excel has the ability to determine the most suitable probability distribution model that best describes the data set before giving an answer. No reference is made to the probability distribution model in the Excel help file on PERCENTILE function. Does anyone here definitively know how the PERCENTILE function works? Does it base the answer on the probabilty distribution function or does it simply order the data set and give the answer based on the rank? Any clarification is welcome.
Bookmarks