JMP User Community

Latest Discussions

Calculate difference between values in consecutive rows by group

Hi There, I have a data table with 2 columns like the below:group value 1 10 1 20 1 25 2 5 2 10 2 15I want to create a new column, "diff", that calculates the differences between consecutive rows, grouped by "group", so I would have something like this: group value diff 1 10 . # because there is a no previous value 1 20 10 # value[2] - value[1] 1 25 5...
Alicia

Discussions |
Aug 24, 2021 7:28 AM

4439 views | 2 replies
Issue with copying Excel Pivot Tables to JMP

Hi! I would like to know if there is a clever way to copy pivot tables with several columns of info into JMP. Excel groups them into categories, but when you copy the Pivot table into JMP, it just has blank values. I have not found a good trick for this aside from actually complex formula rows and then copy paste. If anyone has a trick for this, it would be super helpful to share!!! Thanks!
Aziza

Discussions |
Aug 24, 2021 7:19 AM

1306 views | 1 replies
Problem when importing Excel (.xlsx) to JMP 16 on Mac

Hi all, I have a strange problem when importing .xlsx files to JMP 16 on Mac:some cells in .xlsx file have numbers with 9 decimal places, which are only seen in the value box if you click on the cell in MS Excel or Mac Numbers. Otherwise, the cell format shows only 1 decimal place.When I import the .xlsx file to JMP 16 on Mac, only 1 decimal place is imported, and there is no way to convince JMP t...
ruskicar

Discussions |
Aug 24, 2021 5:37 AM

2000 views | 1 replies
Suitable software to compute discrete choice experiment results with dual response none

I am conducting a discrete choice experiment with dual response none option.Is there any function that can be recommended for modelling that 2-stage decision process? I used Sawtooth Lighthouse studio for first computation of results (HB analysis) but like to re-compute results in another software as well.Thank you very much in advance.
Julia90

Discussions |
Aug 24, 2021 5:36 AM

1154 views | 1 replies
JMP Script: How do I select rows based on variable cell value?

Hi,I'm trying to write a script to select the rows with either the SerialNo or the Data value of 1-25 (highlighted rows below).Is there a way to select these cells with variable?e.gdata table () << select where (:Item == "SerialNo[1-25] ");
kyawkag

Discussions |
Aug 24, 2021 3:00 AM

1141 views | 1 replies

Previous
Next

Latest Discussions

Issue with copying Excel Pivot Tables to JMP

Hi! I would like to know if there is a clever way to copy pivot tables with several columns of info into JMP. Excel groups them into categories, but when you copy the Pivot table into JMP, it just has blank values. I have not found a good trick for this aside from actually complex formula rows and then copy paste. If anyone has a trick for this, it would be super helpful to share!!! Thanks!
Aziza

Discussions |
Aug 24, 2021 7:19 AM

1306 views | 1 replies
Suitable software to compute discrete choice experiment results with dual response none

I am conducting a discrete choice experiment with dual response none option.Is there any function that can be recommended for modelling that 2-stage decision process? I used Sawtooth Lighthouse studio for first computation of results (HB analysis) but like to re-compute results in another software as well.Thank you very much in advance.
Julia90

Discussions |
Aug 24, 2021 5:36 AM

1154 views | 1 replies
JMP Script: How do I select rows based on variable cell value?

Hi,I'm trying to write a script to select the rows with either the SerialNo or the Data value of 1-25 (highlighted rows below).Is there a way to select these cells with variable?e.gdata table () << select where (:Item == "SerialNo[1-25] ");
kyawkag

Discussions |
Aug 24, 2021 3:00 AM

1141 views | 1 replies
How can this "weight" classification be made faster?

The segmentation points of each body weight were calculated by combining and classifying the "Big Class.jmp", age and sex.
Each weight in each segment was then compared to these segment points to calculate the weight classification.dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New Column( "TYP" ); Column( "TYP" ) << Formula( Char( age ) || sex ); dt << run formulas; Column( "TYP" ) << deleteFormula;...
lwx228

Discussions |
Aug 24, 2021 1:29 AM

829 views | 1 replies
How to get the ChiSq for each predictor in Logistic Regression?

I noticed that in Logistic Regression each predictor will have a ChiSq value as highlighted in the color yellow below pic, I am wondering how to calculate this value for each predictor since the predictors are continuous data.Is there anyone who can help answer? Thanks in advance. ~ ~
baiyun

Discussions |
Aug 23, 2021 8:30 AM

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

1233 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

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

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

Discussions |
Aug 2, 2021 1:01 AM

719 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

909 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

1279 views | 0 replies