topic oh my - so many different methods to calculate percentiles in Discussions https://community.jmp.com/t5/Discussions/oh-my-so-many-different-methods-to-calculate-percentiles/m-p/4059#M4059 <HTML><HEAD></HEAD><BODY><P><A class="jive-link-external-small" href="http://www.amstat.org/publications/jse/v14n3/langford.html">http://www.amstat.org/publications/jse/v14n3/langford.html</A></P><P></P><P>Gosh - I did not realize there were so many different ways to calculate percentiles! I just noticed my results from Excel (formula =percentile (array, percentile) and JMP (quantile plots and data) differed, and that led me to the above website, which identifies about 12 or more different methods! I am at a bit of a loss, for I often use results from both programs (obviously that has to change). Or I calculate percentiles in Excel when summarizing data and run stats in JMP later - which means two different methods were used.</P><P></P><P>The above publication recommends one alternative that is given in SAS, which I believe is a bit different than the JMP method.</P><P></P><P>I suppose the best solution would be if there was a way to make the same calculation in JMP and excel, since those are the programs I mostly use. Is there?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 29 Nov 2011 16:55:23 GMT deer_dog 2011-11-29T16:55:23Z oh my - so many different methods to calculate percentiles https://community.jmp.com/t5/Discussions/oh-my-so-many-different-methods-to-calculate-percentiles/m-p/4059#M4059 <HTML><HEAD></HEAD><BODY><P><A class="jive-link-external-small" href="http://www.amstat.org/publications/jse/v14n3/langford.html">http://www.amstat.org/publications/jse/v14n3/langford.html</A></P><P></P><P>Gosh - I did not realize there were so many different ways to calculate percentiles! I just noticed my results from Excel (formula =percentile (array, percentile) and JMP (quantile plots and data) differed, and that led me to the above website, which identifies about 12 or more different methods! I am at a bit of a loss, for I often use results from both programs (obviously that has to change). Or I calculate percentiles in Excel when summarizing data and run stats in JMP later - which means two different methods were used.</P><P></P><P>The above publication recommends one alternative that is given in SAS, which I believe is a bit different than the JMP method.</P><P></P><P>I suppose the best solution would be if there was a way to make the same calculation in JMP and excel, since those are the programs I mostly use. Is there?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 29 Nov 2011 16:55:23 GMT https://community.jmp.com/t5/Discussions/oh-my-so-many-different-methods-to-calculate-percentiles/m-p/4059#M4059 deer_dog 2011-11-29T16:55:23Z