JMP User Community

Latest Discussions

Regex Extract numbers and decimals

I have a column and I need to extract the numbers from the strings in each row. The numbers could be decimals or not. I am using this formula: Regex( :PIPE_LENGTH, "[^(\d+\.\d+)]", "", globalreplace ) Examples:String: Length = 3.5". Completed by John.Expected: 3.5Actual: 3.5.. Example 2:Completed for CEC. Pipe depth- 4.5" (MER)Expected: 4.5Actual: .4.5() Why are the extra periods and parentheses...
john_along

Discussions |
May 14, 2020 2:50 PM

22247 views | 6 replies
How do I reference a column value as a reference line on a control chart?

Hi, I'm trying to create a script which generates control charts which plots net yields by WO that references a planned yield entry in the %Planned Yield. Since I'd like to create a chart for each product in my data table, and there is a different planned yield for each product, I need to create a reference to the %Planned Yield Column. I have created a script so that the control chart will genera...
ayuan6

Discussions |
May 14, 2020 9:33 AM

1703 views | 1 replies
Need help with modeling

I have a 2 part mixture model with 1 process variable and i need help analyzing it please. See attached:FM% and SM% are 2 parts that = 100%The process variable is Combined GTResponse is Gloss 60Any help is greatly appreciated, is there any association here?
Ghosted

Discussions |
May 14, 2020 8:46 AM

1617 views | 1 replies
3D bar charts in JMP

Is there an option in JMP to create 3D bar chart? I want similar to this picture.
billi

Discussions |
May 14, 2020 5:58 AM

4459 views | 3 replies
Two way repeated measures ANOVA results

Hello everyone, I hope you can help me.I designed an experiment using two different genotypes (WT and TG) of mouse and they both were fed with either a control diet (Crtl) or a high-fat diet ( HFD). I measured the weight of each mice for several weeks and would like to statistically analyze the results. For this approach since I have 2 factors, and time I decided to use the Two way repeated measu...
Franco13

Discussions |
May 13, 2020 11:19 PM

3803 views | 4 replies

Previous
Next

Latest Discussions

How do I reference a column value as a reference line on a control chart?

Hi, I'm trying to create a script which generates control charts which plots net yields by WO that references a planned yield entry in the %Planned Yield. Since I'd like to create a chart for each product in my data table, and there is a different planned yield for each product, I need to create a reference to the %Planned Yield Column. I have created a script so that the control chart will genera...
ayuan6

Discussions |
May 14, 2020 9:33 AM

1703 views | 1 replies
Need help with modeling

I have a 2 part mixture model with 1 process variable and i need help analyzing it please. See attached:FM% and SM% are 2 parts that = 100%The process variable is Combined GTResponse is Gloss 60Any help is greatly appreciated, is there any association here?
Ghosted

Discussions |
May 14, 2020 8:46 AM

1617 views | 1 replies
Compositional data analysis

Hello All,1 - Are there any good examples or any option in JMP Pro to run compositional data analysis before I run PCA and modeling with the compositional data to predict some responses? Let's say I have 20 variables (powder oxides found by X-ray fluorescence, some of which can be zero that need to be imputed, if I use, for example, R, before centered log-ratio transformation), and the summation o...
Amir_H

Discussions |
May 13, 2020 10:08 PM

2463 views | 2 replies
Retrospective Power Analysis

Hi,I've just performed a t-test that was inconclusive, so I was using the retrospective power option to get a feel for whether it's worth performing additional tests.So, I select Power from the One Way Analysis red triangle and get the retrospective power options.The table has the alpha, sigma and N direct from the existing data. But the table shows a delta of half the difference in means observe...
jfs

Discussions |
May 13, 2020 9:32 AM

3270 views | 3 replies
Interpreting PLS regression coefficients for a binary categorical variable

I used Fit Model with the Partial Least Squares personality to create a model for a continuous dependent variable. Explanatory variables include several continuous variables and a categorical variable with two options, A or B. I understand that option A and B are treated as separate dummy variables. When I run the fitting, the regression coefficient for option A is about -0.4 and the regression co...
blumarble

Discussions |
May 13, 2020 8:41 AM

3117 views | 3 replies

Previous
Next

Latest Discussions

How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4678 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2222 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

2036 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1673 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1609 views | 0 replies