JMP User Community

Latest Discussions

Last 30 pieces for each row and delete the other data

Hello Everyone, I have a data table that has multiple columns and each column has a different amount of rows with data in it. I am trying to find a way to get the last 30 rows of the data in each column. For example column 1 has 50 rows and column 2 has 75 rows and I want each row to have the last 30 rows of info. Is there a script that can do that?
rmthomas

Discussions |
Aug 25, 2021 7:17 AM

1900 views | 6 replies
DoE augmentation

I have a main effect screening design via custom design platform. Now I need to augment the design to model the curvature. There seems to be two options: (1) add axial points along with center points and (2) use Augment button and select RSM to add interaction and quadratic terms. Option 1 seems for central composite design. Can anyone tell me whether there is any particular reasons to use option...
JMP38401

Discussions |
Aug 25, 2021 4:41 AM

1960 views | 2 replies
JMP 14 Python abilities - working? I'm confused

I'm trying to use the new abilities in JMP 14 to run python and it's not working. Basically not finding my python install I think though in some circumstances it just crashes. I saw another discussion saying there were issues with that in 14.1 and suggesting a workaround about setting environment variables and using Use Python Version("3.6") as an argument to Python Init() (both of which I tr...
hardner

Discussions |
Aug 24, 2021 2:41 PM

23168 views | 31 replies
Adding numbers to columns

Hi,@txnelson,I am new to JSL Scripting.Is there a way I could number all the columns using a jsl script? There are 100 columns in the data table and I want to concatenate number in the column names On example, there are multiples columns that follow this type:-Looking for some feedbackThanks,Jay
Jackie_

Discussions |
Aug 24, 2021 8:57 AM

1589 views | 5 replies
How to transfer graph data into powerpoint ?

Hi, I usually have to manually transfer graph data ( ex: shown below), by copying three plots at once and transferring them into a new slide in powerpoint manually. I usually have about 40-50 of such plots and it is time consuming to transfer manually each time. Is it possible to automate this in JSL and send pair of 3 plots into a new slide? (Apologize for blacking out column names).Thanks!
D_T_M

Discussions |
Aug 24, 2021 8:48 AM

1462 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

1015 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

839 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

880 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

613 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

2001 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

894 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

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

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

Discussions |
Aug 2, 2021 1:01 AM

566 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

678 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

1007 views | 0 replies