Quantiles result from JMP are different from Python
Hi JMP community, I'm trying to build a JMP script to calculate the quantiles 97.5. The issue here is my reference data is using Python in which return a different number. Below is an example: Python P97.5: 2561.35 (equal to PERCENTILE.INC in Excel)JMP P97.5: 2581.375 (equal to PERCENTILE.EXC in Excel) My JSL code: Summarize(
dt1,
group_by = By( :group ),
group_p975 = Quantile( :data, 0.975 )
);
I...