JMP User Community

Latest Discussions

Selecting latest Date for same ID

Hi all,I have a problem here trying to figure out. I'm still new in JSL thus I'm stuck.
I have this table that gives me the ID of an item, the date it was processed and so on. For same ID, multiple reprocess could've been done and it causes the timestamp of DateTime to double/triple. I want to clean up my table and only maintain the ones with latest DateTime for same ID. I know i should use loop fo...
Leyahans

Discussions |
Feb 6, 2023 12:11 PM

1593 views | 2 replies
Substituting a space for underscore in a character string

Hi:

I have a long description of a product that includes a bunch of underscores __ which I don't want. I'd like to replace them with spaces instead.

I've tried using substr(substitute(columnname, "_",""),1, 999) but that just makes the entire field blank.
I've also tried the reverse (substitute(substr....) same problem. Help!

JMP 17 FWIW.
RandomMapsFox62

Discussions |
Feb 6, 2023 11:43 AM

2594 views | 2 replies
Data Dispersion

Hello,I have about 80K tests with numeric results.Some of the tests look ok, without too much dispersion data, and some of them are a lot.I need to detect the tests that have a vast range of dispersion data.Visually I can see it by the graph, but the problem is I have 80K test, and I need a mathematical formula that will detect and show me the test with the huge distribution.I tried calculating th...
Dennisbur

Discussions |
Feb 6, 2023 9:57 AM

1595 views | 4 replies
How to perform capability analysis on data that is the same

Hi everyone. I'm trying to run a capability analysis on some sets of data (n=30) where the values do not vary. As far as I am aware, this is not possible. Do I need to treat those sets of data as attribute? Please advise. Thank you!
BBucklen

Discussions |
Feb 6, 2023 9:45 AM

2179 views | 4 replies
correlation coefficient (Rho) in weibull distribution

Hi, how can i get the correlation coefficient (Rho) in Weibull distribution from JMP? by Life distribution i JMP, i can get Alpha and Beta which corresponding to value b, n in picture below. here is the definition of Correlation Coefficient
The correlation coefficient, usually denoted by ρ (Rho), is a measure of how well the linear regression model (the probability line) fits the data. In the ca...
taoc

Discussions |
Feb 6, 2023 8:40 AM

2599 views | 2 replies

Previous
Next

Latest Discussions

Selecting latest Date for same ID

Hi all,I have a problem here trying to figure out. I'm still new in JSL thus I'm stuck.
I have this table that gives me the ID of an item, the date it was processed and so on. For same ID, multiple reprocess could've been done and it causes the timestamp of DateTime to double/triple. I want to clean up my table and only maintain the ones with latest DateTime for same ID. I know i should use loop fo...
Leyahans

Discussions |
Feb 6, 2023 12:11 PM

1593 views | 2 replies
Data Dispersion

Hello,I have about 80K tests with numeric results.Some of the tests look ok, without too much dispersion data, and some of them are a lot.I need to detect the tests that have a vast range of dispersion data.Visually I can see it by the graph, but the problem is I have 80K test, and I need a mathematical formula that will detect and show me the test with the huge distribution.I tried calculating th...
Dennisbur

Discussions |
Feb 6, 2023 9:57 AM

1595 views | 4 replies
How to perform capability analysis on data that is the same

Hi everyone. I'm trying to run a capability analysis on some sets of data (n=30) where the values do not vary. As far as I am aware, this is not possible. Do I need to treat those sets of data as attribute? Please advise. Thank you!
BBucklen

Discussions |
Feb 6, 2023 9:45 AM

2179 views | 4 replies
correlation coefficient (Rho) in weibull distribution

Hi, how can i get the correlation coefficient (Rho) in Weibull distribution from JMP? by Life distribution i JMP, i can get Alpha and Beta which corresponding to value b, n in picture below. here is the definition of Correlation Coefficient
The correlation coefficient, usually denoted by ρ (Rho), is a measure of how well the linear regression model (the probability line) fits the data. In the ca...
taoc

Discussions |
Feb 6, 2023 8:40 AM

2599 views | 2 replies
Data Filter - Zoom Settings

When I open a data filter and use "zoom to Selection" to restrict the displayed ranged, I can generate a J'SL code which looks like the one below. Unfortunately, when I run the JSL code, the Data Filter is opened without the range restriction (Jmp 17.0): Is there anything that I can do to get the range restricted? dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Data Filter( Location( {175, 175...
hogi

Discussions |
Feb 5, 2023 11:41 PM

1433 views | 4 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

801 views | 0 replies
Choice experiment: probability profiler baseline assumptions

Dear community, For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data. Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...
Declan_JMP

Discussions |
Jan 23, 2023 3:54 AM

1616 views | 0 replies
Can we find some tutorials videos in YouTube?

Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!
Matheus_Plana

Discussions |
Jan 15, 2023 10:27 AM

1657 views | 0 replies
Data puzzles via Hanukkah of Data is underway

If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
XanGregg

Discussions |
Dec 19, 2022 11:21 AM

826 views | 0 replies
Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
Lavik17

Discussions |
Dec 19, 2022 10:20 AM

965 views | 0 replies