First time using JMP
Hi guys,
For my master thesis, i am working on pupil diamanter measurement and my supervisor told me to install JMP Pro and she took one of my trial participants and cleaned up the raw data.
However, she wouldn't be able to meet me for some time and asked me to clean up the data like she has. The issue is that I never tried the program before. Now some of it makes sense with regards to deleting the columns, but for instance the blue things she has added, I don't know how she has done it, so perhaps anyone can help me, so i can start moving into the actual statistical analysis.
The first picture is the raw data, and the second part is the cleaned up version.
I can also send the two files, if need be.
Kind regards,
Ben




Advanced Statistical ModelingConsumer and Market ResearchData AccessData Blending and CleanupQuality and Process EngineeringRe: First time using JMPI suggest that you start by reading the document "Discovering JMP" which is under the Help pull down menu.
Re: First time using JMPI have to say that questions like this make me lament what passes for instruction these days. Your instructor offers no guidance other than "here's an example, you figure it out." That's not teaching. He/she doesn't need to tell you how to do it, but this is the other extreme - who needs an instructor that just tells you to figure it out. Did they need a PhD to do that?
Re: First time using JMPHello guys,
I can say i found out how to make them blue (numerical - continuous)
However, when I do that for some values, it just turns it into a black dot.
https://imgur.com/a/bybUPeN
It strangely doesn't do it in the timestamp values but for the others it do.
I then try to change the columns back to normal, but then the numbers previously just disappear?Re: First time using JMPJMP converts cells to missing values (the dots you are seeing), when the values in the cell can not be converted to a valid number.
You indicated that you could attach the files if necessary. That would be very helpful
Re: First time using JMPHAVE YOU READ THE EXPLORING JMP DOCUMENTATION! The Discussion Forum is here to help you, "help-yourself".
Would you happen to be able to attach the raw data. Given the table as you have processed it in JMP, there does not seem to be any issues.
Re: First time using JMPMy best guess is that what you need to do, is to copy and past into an Excel spreadsheet, all rows and columns from row 25 through row 5941.
Then save the spreadsheet to your hard drive.
Next, go back to JMP and then open the Excel spreadsheet into JMP.
There are several rows of data that appear to be wrongly lined up. You will need to go down through the rows, and copy and paste the offset rows back to where they belong. An example of this is row 50 and 51 in the original data table.
Once you have manually moved the various wrongly lined up rows, you can then delete all of the columns that are no longer needed to hold the invalid lined up data.
Finally, the graph comparing the pupil size vs time can be created using the Graph Builder platform
Graph=>Graph Builder
Re: First time using JMPHi, I think have the solution.
My supervisors JMP file, her numbers was written as 3,19, where I has my values as 3.19.
The difference seems to lie in "." & ",".
Is there a way I can replace all the "." in a column with ","?