This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
JMP's Col Quantile function matches Excel's Percentile.exc function. According to Microsoft, the Percentile function is only included for backwards compatability. When I changed your Excel file to the newer .exc version, I got the same answers in both Excel and JMP.