Hi folks,
I am using Jump to make a dot plot, somehow the result is different from the Excel plot. As shown below, Figure 1 is Jump plot, the region within the red circle is intermittent dot. Figure 2 is Excel plot, the region within the red circle is a continuous plot. I am attaching the Excel raw data, could anyone help me debug the Jump plot? Thanks.
I'm not familiar anymore with excel plotting but for me they aren't "continuous". If you increase the plot size you might start seeing difference
or make plot smaller in JMP and the white area will disappear
Hi jithi,
Could you use the following Excel file to replot. The previous Excel file that I uploaded was not the correct one.
The interesting thing is that Excel file plot has a smooth line within the red circle region. However, the jumper plot seems to have multiple Y values to each X at that red circled region. Please advise it. Thanks.
Hi @TDK_Long,
I'm fairly certain this is a rounding artifact from Excel's export. Looking at line 1207 in the .csv file, there are only 3 significant figures in the X column (1.03E+01 in Excel = 10.3 in JMP). I'm assuming your original Excel file has more significant figures, but is only displaying 3 of them, and Excel is exporting the 3 figures/digits into the .CSV file. This will cause the intermittent dots in JMP, because JMP doesn't have this information that Excel isn't exporting.
If this assumption is correct, then changing the number format in Excel before exporting will allow more detail (a smoother line) in JMP.
Hi Jed,
Thanks for your detailed explanation. Now I understand the root cause is t he scientific numbers are rounded. I can get a smooth plot in the Jump. Much appreciated.
