JMP User Community

Latest Discussions

How to correct sequence/order in a column with standard reference and if it does not follow over write it with some rules.

Dear All,

I recently asked a question how to fill missing values in a column and got/implemented the solution. But I am stuck again. This problem is the continuation of the same (2nd stage issue.)

Reference of previous problem -
https://community.jmp.com/t5/Discussions/How-to-fill-replace-text-between-two-cells-based-on-specific/m-p/581800#M78854
I want to generate a column "Device_State_Final_Corre...
HSS

Discussions |
Jan 4, 2023 9:15 AM

2088 views | 3 replies
Pause Script Until After User Manually Works on Data Table

Folks, I'm trying to pause my script so that a user can manually work on an open data table (manually examine data and add/delete rows or columns) before proceeding. I've tried using a dialog box to accomplish this, but I can't work on the data table until after the dialog box is accepted. Does anyone have any suggestions on how I can accomplish this? Clear Log();Names Default to Here ( 1 );dt...
terapin

Discussions |
Jan 4, 2023 9:08 AM

7506 views | 6 replies
how to sort and compare columns when data is not identical

I have data from two separate runs.data include: X,Y,ZI want to comapre results based on X,Y coordinates (Z is the results)the problem: for each run i get different coordinates. well, not completely different but not identical. within a range of +- 10.how can i sort the data and compare the results (it has to be X and Y, not one of them only).see table for example, (I've arranged the data in that ...
Ohad_s

Discussions |
Jan 4, 2023 7:21 AM

1806 views | 3 replies
Can I pause a script to allow a user to edit a data table

I currently have a script which if run as highlighted lines works perfectly. Highlighting the first lines, a data table is created (from an SQL Query) and the script stops.That table can then be edited (some rows are highlighted or deleted) and then the 2nd half of the script can be run. I'd like for a user to run this without having to highlight script lines, so I need a way to pause the script ...
pcarroll1

Discussions |
Jan 4, 2023 6:43 AM

3157 views | 2 replies
One hold out cross validation

Hi, I want to do one hold-out cross-validation for the random forest, but I don't know if JMP pro has this option or not. If it has where can I find it?
tuo88138

Discussions |
Jan 4, 2023 4:06 AM

10055 views | 10 replies

Previous
Next

Latest Discussions

how to sort and compare columns when data is not identical

I have data from two separate runs.data include: X,Y,ZI want to comapre results based on X,Y coordinates (Z is the results)the problem: for each run i get different coordinates. well, not completely different but not identical. within a range of +- 10.how can i sort the data and compare the results (it has to be X and Y, not one of them only).see table for example, (I've arranged the data in that ...
Ohad_s

Discussions |
Jan 4, 2023 7:21 AM

1806 views | 3 replies
One hold out cross validation

Hi, I want to do one hold-out cross-validation for the random forest, but I don't know if JMP pro has this option or not. If it has where can I find it?
tuo88138

Discussions |
Jan 4, 2023 4:06 AM

10055 views | 10 replies
Graph builder- x overlay % issue

Hi all,I tried to show the following data using graph builder,I need to display the % of every type in regards to the Overlay. for example-the type as 10 full, 10 partial, 10 low and 70 good-> I want the bar to show me 10% to Full/partial/low and 70% to goodright now when I change the summary statistics to % of total-> it display the % in regards to all x (and not 1 by 1)
Hamal22

Discussions |
Jan 3, 2023 5:31 AM

973 views | 1 replies
Correlation between the same test

HelloI want to find r correlation between the same test but the different periods.for example:I scored tests in April and October and I need to know the correlation between these periods. I find multivariate function in JMP but I need result in table not in graph.I need receive 2 columns Name of test and Correlation for each test.In excel I can use CORREL function, but didn't find something simila...
Dennisbur

Discussions |
Jan 3, 2023 5:19 AM

1469 views | 2 replies
Computing std devs for Control Charts?

Hi. I have a question for any 6-sigma folks out there. In the Quality and Process Methods section of the User Manual, under "Statistical Details for Control Chart Builder", the standard deviation seems to be approximated using the range. For example, for XmR charts, the standard dev formula is:where MR-bar is the average of the moving range and d2 is a value from a lookup table. I'm not unfami...
nikles

Discussions |
Jan 2, 2023 1:46 PM

7663 views | 13 replies

Previous
Next

Latest Discussions

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

811 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

951 views | 0 replies
C Stack Usage Error When Sending Code to R

Hello, I'm trying to invoke some commands in R using the R Submit function in JSL and am getting the error below. Is this an issue with JMP17 and R integration? It only happens when I invoke a specific package using JSL so it's hard for others to replicate w/o installing R and the package as well. I'm using JMP 17.0 and R 4.2.0. Never saw this error with JMP 16. "Error: C stack usage 4123778 is to...
vigslayer

Discussions |
Dec 15, 2022 8:14 PM

987 views | 0 replies
How to fix X Axis Settings for Operating Characteristic Curves

I'm playing around with different scenarios on an Operating Characteristic curve in which the fraction defective is very small (screen shot below). Every time I run a scenario, the x-axis automatically changes to a range that is way too wide to be useful and I have to change it back manually.Is there a way to make the x-axis setting constant? (I'm using Jmp Pro 16.1)Thanks!
The_Annie

Discussions |
Dec 15, 2022 2:29 PM

876 views | 0 replies
Response Screening Effect Size - logistic

Related to the previous post How to get "Effect size" column with Response Screening functionality , I am also wondering how effect size in the response screening platform is calculated, specifically for categorical Y vs continuous X. JMP help shows: "When Y is categorical and X is continuous, the effect size is the square root of the average ChiSquare value for the whole model test." Running b...
wgardnerQS

Discussions |
Dec 14, 2022 12:54 PM

944 views | 0 replies