JMP User Community

Latest Discussions

read and save a txt file from a subdirectory of a ZIP file

Hi,Can someone help. I tried many and still fail.I tried to loop through a list of zip folder to try to find specific txt file that is under a subdirectory of the zip folder. when I get the filelist in the zip folder, I saw the txt file as subdirector/mytxtfile_123.log. Below is my script, but it fails to download the txt file. there is IO problem where it complains "system cannot find the path s...
dadawasozo

Discussions |
Jan 5, 2023 7:23 AM

2160 views | 3 replies
Limits

Hello
I have a data table including LO Limit and HI Limit
but I don't know how to link this data of limits in my graphsFor example, when I would like to build a Variability graph, I can manually add limitsthrough "Reference Lines."But I didn't find an option how I can regularly link the limits from columns LO Limits and HI Limits by Test Name to any graphs in JMP.I would very much appreciate if you ...
Dennisbur

Discussions |
Jan 5, 2023 7:11 AM

2537 views | 3 replies
K means with fixed centers

Hello, is there a method to calculate k means for a dataset but have some centers pre-defined? That is, I have the following random data and want to find k=3 centers, but 2 of the centers are already fixed at a given location. Does the functionality exist in JMP 14.2.0? Thanks! Points:LabelXYPoint133Point244Point366Point45030Point56060Point67090Point79090Point89999Point9101101Point10102102 Find...
AvgRegression52

Discussions |
Jan 4, 2023 12:29 PM

3132 views | 3 replies
How to find the Max difference between two tests by counting number of cells between events.

I have attached a mini file.If the cell of a lot passes TEST 1 and TEST 2 its status is PASS.If a cell fails TEST 1 and TEST 2 its status is SAME.If a cell fails a test but passes the other test its status is DIFF.For each lot I am trying to determine the Max distance by cell count from a DIFF to its nearest SAME.What would be the best way to go about this?ThanksFiona
fionaweston

Discussions |
Jan 4, 2023 9:40 AM

1919 views | 3 replies
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

2081 views | 3 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

1804 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

10038 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

970 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

1466 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

7659 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

875 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

943 views | 0 replies