https://community.jmp.com/t5/Discussions/JMP-formula-for-Percentile-INC/m-p/588454#M79342 <P>Hi,</P> <P>The formula: Col Quantile (:Column, k) should return the same as Excel. If you need to subset within a column, use the expanded formula:&nbsp;Col Quantile (:Column, k, :By Column).</P> <P>&nbsp;</P> <P>Best,</P> <P>TS</P> Tue, 10 Jan 2023 15:21:31 GMT Thierry_S 2023-01-10T15:21:31Z https://community.jmp.com/t5/Discussions/JMP-formula-for-Percentile-INC/m-p/588380#M79336 <P>What is the JMP formula for Percentile.INC? I have an excel sheet that is not matching up with jmp.</P> Thu, 08 Jun 2023 16:43:51 GMT https://community.jmp.com/t5/Discussions/JMP-formula-for-Percentile-INC/m-p/588380#M79336 UpliftElk866 2023-06-08T16:43:51Z https://community.jmp.com/t5/Discussions/JMP-formula-for-Percentile-INC/m-p/588454#M79342 <P>Hi,</P> <P>The formula: Col Quantile (:Column, k) should return the same as Excel. If you need to subset within a column, use the expanded formula:&nbsp;Col Quantile (:Column, k, :By Column).</P> <P>&nbsp;</P> <P>Best,</P> <P>TS</P> Tue, 10 Jan 2023 15:21:31 GMT https://community.jmp.com/t5/Discussions/JMP-formula-for-Percentile-INC/m-p/588454#M79342 Thierry_S 2023-01-10T15:21:31Z