JMP User Community

Latest Discussions

Lag based on Month

Our goal is to create a 1 month lag column (rather than by row). The LAG(M/Y) column output of 01/2000 should line up with 02/2000 in the M/Y column, etc. Attached is a tiny subset example of water use by m/y; whereas, our full table contains more than 59 million rows. The full table consists of water use for more than 430,000 customers for each each month over many years. We're open to all s...
Dukowitz62

Discussions |
Aug 19, 2021 6:29 PM

1773 views | 1 replies
Adding reference lines to a log scale

Hi,I'm hoping someone has a solution to my issue. I am using graph builder and adding two continuous variables to the Y axis - both require the same log scale. This works okay with a scale from 0.1 to 1e+10 until I try and add the reference lines. I have lines to add at 475000 and 4750000 - which when I add and look at the preview appear to be fine (see screenshot)however when I click OK - I get t...
Zoe_Betteridge

Discussions |
Aug 19, 2021 4:08 PM

1067 views | 1 replies
ELI5: D/I/A Optimal designs

Hi JMP Community, ELI5 stands for Explain like I'm 5 years old. I need some support explaining the differences between D-Optimal, I-Optimal and A-Optimal designs to colleagues which do not have strong mathematical backgrounds and cannot easily intuit the definitions in the JMP manual (I don't have a strong mathematical background either!). Is there a way to explain what each of the D-Optimal, I-O...
Donald46

Discussions |
Aug 19, 2021 3:46 PM

8434 views | 7 replies
JMP 2016 very slow

I just started using JMP with a large data file. Things like row selection and Summary tables were incredibly slow or would not operate at all. I thought this was a file size issue but tried doing the same things using JMP 15 and the same functions worked almost immediately. So this was an issue related to JMP 16 and not file size. Is there a fix?
PTR50

Discussions |
Aug 19, 2021 12:15 PM

5501 views | 6 replies
Robust Optimization - maximize desirability based on feedback from simulation?

Consider a system where an optimal point is at the edge of an acceptable operating envelope. If attempting to run there, small changes in controlled variables can lead to poor results in some fraction of the total runs. It is possible to use the optimization built into the profiler to find optimal conditions, and to use simulation to find more robust target operating conditions, but can they be ...
ih

Discussions |
Aug 19, 2021 11:59 AM

1944 views | 2 replies

Previous
Next

Latest Discussions

Adding reference lines to a log scale

Hi,I'm hoping someone has a solution to my issue. I am using graph builder and adding two continuous variables to the Y axis - both require the same log scale. This works okay with a scale from 0.1 to 1e+10 until I try and add the reference lines. I have lines to add at 475000 and 4750000 - which when I add and look at the preview appear to be fine (see screenshot)however when I click OK - I get t...
Zoe_Betteridge

Discussions |
Aug 19, 2021 4:08 PM

1067 views | 1 replies
Imputing Values Below Limit of Detection (LOD)

Hi all, What seems as if a seemingly easy function, isn't available in JMP especially for those involved in forensic chemistry/toxicology. We are often presented with data that is below an instrument threshold (LOD). To compare the results with multivariate statistics we need to impute the values. What this imputed value should be is a point picked out from a distribution in log space since our da...
MikeDereviankin

Discussions |
Aug 19, 2021 6:29 AM

1795 views | 2 replies
Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1216 views | 0 replies
Set desirability - Maximize desirability VS Simulation experiments

Hi there,I need your support please to find the optimal conditions which allow having the highest Y1 (yield) while keeping Y2 (impurities) lower than 70.Both responses have equal importance.I’ve tried with “maximize desirability” after setting desirability. When we set desirability, we have 4 options (maximize, minimize, target and none).For Y1: I’ve selected “Maximize”For Y2: I am left with the o...
JMPdiscoverer

Discussions |
Aug 17, 2021 8:01 AM

1307 views | 2 replies
Set Property for Missing Data

Quite certain this is a simple fix for those in the "know" however, i have been struggling to figure it out. I have a pass_fail column when i am doing my limits and need to figure out how to assign "Fail" to missing data.I use the same table to plot distributions so assigning a random number to the missing data could cause problems. Thanks in Advance Column( dt_split, N Cols( dt_split ) ) << Set P...
Yngeinstn

Discussions |
Aug 17, 2021 4:33 AM

1306 views | 2 replies

Previous
Next

Latest Discussions

Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1216 views | 0 replies
Projects Window List in JMP 15 for Mac -- Reorder?

I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses. There is a flow to the findings which I'd like to order in that Window List. Is this possible? I can't click and drag an entry for a window up or d...
datanaut

Discussions |
Aug 16, 2021 6:38 AM

611 views | 0 replies
请问JMP有哪些模型可以用于预测股票价格的未来走势？

这是个异想天开的问题: 大家都说股票价格的未来走势预测是艺术、不是科学。
但我还是想看看JMP具体哪里模型能用于这方面。我尝试过使用决策树、随机森林、xgboost。
还使用了DOE制作了均匀试验表来进行分类统计。
虽然这不是一个很好的问题、但还是非常期待专家们的回答。非常感谢！
lala

Discussions |
Aug 2, 2021 1:01 AM

704 views | 0 replies
Categorizing term lists for Word Cloud display and/or filtering

Hi all, I have a word cloud based on unstructured text from journal articles. Many of these terms fall into common categories, e.g.: 1) tree species, 2) bird species, or 3) geographic locations. Many of these grouped terms are relevant to my user group, but difficult to locate amongst the large number of terms in my corpus (particularly when uncommon terms don't show up in the Word cloud). I was w...
caseylott

Discussions |
Jul 29, 2021 12:32 PM

896 views | 0 replies
Partial redundancy analysis in JMP

I need to check the effects of three explanatory variables which are 1) fish_length, location, and sex on a set of response variables (PC1…..PC7).
First I need to test the effect of size (fish size), and in case if the effect of fish_length is significant then I need to use the residuals of the first pRDA test to check the effects of location and sex using RDA. Also I will need to use the residuals...
ukhandurrani

Discussions |
Jul 22, 2021 9:33 AM

1253 views | 0 replies