topic Re: First time using JMP in Discussions

First time using JMP

Ben1 — Sat, 10 Jun 2023 23:35:54 GMT

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

Re: First time using JMP

txnelson — Sun, 22 Aug 2021 04:44:03 GMT

I suggest that you start by reading the document "Discovering JMP" which is under the Help pull down menu.

Re: First time using JMP

Craige_Hales — Sun, 22 Aug 2021 10:48:28 GMT

In particular, read about modeling types and formulas. It looks like you are already using them. Assigning the correct modeling type (continuous, ordinal, nominal) to a column will help when you choose an analysis platform. Making new columns as a formula of existing columns can simplify your work.

There is also a hidden column, with a mask.

Re: First time using JMP

dale_lehman — Sun, 22 Aug 2021 11:12:50 GMT

I 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 JMP

ron_horne — Sun, 22 Aug 2021 21:15:15 GMT

Hi @Ben1 ,

@dale_lehman is right, you are learning the old fashion (hard) way. Thrown into the water and now it is sink or swim. Some teachers used to take pride in this method.

If you are asking for personal guidance send me a PM. instead of going through the whole book i can show you the exact features you need in a call.

Re: First time using JMP

Ben1 — Mon, 23 Aug 2021 16:22:55 GMT

Hello 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.

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 JMP

txnelson — Sun, 22 Aug 2021 23:57:05 GMT

JMP 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 JMP

Ben1 — Mon, 23 Aug 2021 16:23:35 GMT

Okay, So here are the files:

The trial Ben file is the "cleaned-up" data, which is what my master supervisor wants me to do.

The M30 file is my attempt of doing, what she did:

Other than that, she also made GRAPH on the top left corner, so if anyone could tell me how it is done, I would be appreciative.

And yes, it does suck when you are thrown in to that kind of water, because my turn-in is on the 15th of September, and I'm gonna meet her on Wednesday, so I would like to have all my participant data cleaned up before Wednesday (23 participants). The good thing though, once you can clean one participant's data, you can clean the others as well.

After the data is cleaned, I am probably gonna have to do a anova analysis and a statistical analysis like this:

I am super thankful for the help, i receive from you guys. You are helping out a desperate master thesis student.

Re: First time using JMP

txnelson — Mon, 23 Aug 2021 19:19:42 GMT

HAVE 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 JMP

Ben1 — Mon, 23 Aug 2021 23:45:20 GMT

This is the raw data file, as you requested.

Re: First time using JMP

txnelson — Tue, 24 Aug 2021 03:00:59 GMT

My 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 JMP

Ben1 — Fri, 27 Aug 2021 09:59:39 GMT

Hi, 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 ","?

Re: First time using JMP

txnelson — Fri, 27 Aug 2021 10:51:25 GMT

You can go to

Edit=>Find

There you can specify to replace all of your "." in your table with ",".