JMP User Community

Latest Discussions

How Do I Transfer Excel COUNTIF and MATCH functions into JMP

I am having an issue in scripting the JSL code for two functions (see screen shot) which I currently have in Excel but want to transfer over into JMP. The data is found in the attached file JMP_Test_Average2.xlsx and the functions I wish to transfer to JMP are as follows:column VS has a COUNTIF function; =COUNTIF(C3:N3,"-1")I want to know the number of instances -1 appears in each row (e.g. in row...
sellerm

Discussions |
Aug 30, 2019 3:49 AM

22282 views | 12 replies
concatenate / save and evaluate formulas

When manually concatenate two tables there is an option to “save and evaluate formulas” so the formulas in the new or appended date gets evaluated. In JSL this option is not available only “keep formula” witch suppresses the evaluation. dt_1 << Concatenate(dt_2,Append to first table,save and evaluate formulas(1)); // this is not possible I know that you can use: dt_1:mycol << Suppress Eval( 0 ...
Mauro_Gerber

Discussions |
Aug 29, 2019 7:00 AM

3977 views | 3 replies
Dunnett's Test Statistic

I have run an ANOVA in JMP with a Dunnett's post hoc test to compare 8 treatments to my control. In a publication I am working on I reported the p-values for each comparison to the control. A reviewer has asked me to include the test statistic along with the p-values. For some reason, a test statistic is not displayed along with the p-values in the default settings on the Dunnett's output within t...
Mananahi

Discussions |
Aug 28, 2019 4:43 AM

9996 views | 6 replies
Fit Y by X Legend with Color & Marker

How am i able to do plot Fit Y by X with 2 separate group legend, 1 with color , another by marker type like chart below. I know it can be done by using graph builder overlay + color. But i cannot find the way to do it in Fit Y by X or Valiability Plot. Please advise.
OneNorthJMP

Discussions |
Aug 27, 2019 8:04 PM

14692 views | 7 replies
How to used JSL JMP tables into a multi-tabbed Excel workbook？

I would like to ask JMP community to help me out on a custom way to export JMP table to excel. Thanks! dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
lwx228

Discussions |
Aug 26, 2019 3:24 PM

7897 views | 11 replies

Previous
Next

Latest Discussions

Search a list of strings for a partial string

Hello I am trying to find a way to search through a list of strings for all items that contain a partial string. I know this can be done using a For loop, but the list that I will be running this script on is very large and For loops take a very long time. I am wondering if there is some function out there similar to Loc(list, string) that will find the items that have the partial string. Just as ...
aallman

Discussions |
Aug 22, 2019 8:39 PM

4066 views | 1 replies
Default Parameters for Elastic Net Logistic Regression

Hi all, I used to use JMP for data mining when I was in school, but have switched to using Python since then. I recently used JMP to build an Elastic Net Logistic regression with my data since its output is more intuitive. I attempted to replicate my results in python using the "SGDClassifier function" but my results were way off. I believe it may be because this function requires specifying se...
wa635419

Discussions |
Aug 22, 2019 7:05 AM

4343 views | 5 replies
Non-parametric coefficient of determination

Dear, I have a question about the use of the coefficient of determination (which is part of the output from a regression model). For the study I'm ready to analyze the data, I want to use the coefficient of determination (COD) to examine the relationship between my dependent variables which represent each column (see annex). But, as I found out each dependent variables (column) has a non consisten...
tomasVH

Discussions |
Aug 21, 2019 10:52 AM

2232 views | 2 replies
replacing numbers with strings

hey,i have a column COL_A, which has 31 rows for wach number between 1 - 31 ( 31 rows of 1, 31 rows of 2 .... etc), and i want to replace those numbers with 31 strings in a specifiec order, for example:if my string are in this order: horse, cat, dog ....etc, i want to replace the 1's with horse, the 2's with cat, the 3's with dog...., what is the best and fastest way to do it?
adham_saif

Discussions |
Aug 21, 2019 3:55 AM

3424 views | 3 replies
Merging time series with timestamp and duration

I would like to merge the following tables 1 (time series with certain events, ~2000 datapoints) and 2 (time series with duration and amplitude data, ~1,000,000 datapoints) into a table like 3: 1:timestampevent20:23:56:962A event20:24:14:964B event...... 2:time [s]amplitude0-0.0004577640.00006250.0642700195...... 3:timestamptime [s]eventamplitude20:23:56:9620A event-0.00045776420:23:56:9620.000062...
WHG

Discussions |
Aug 21, 2019 3:19 AM

3359 views | 5 replies

Previous
Next

Latest Discussions

How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1374 views | 0 replies
Capability Animation - How to see the LSL/USL Value?

I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?
Antonio80

Discussions |
Jul 9, 2019 1:31 AM

1314 views | 0 replies
Unable to allocate enough memory in access or evaluation

Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a 73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...
ns

Discussions |
Jul 8, 2019 9:04 AM

1436 views | 0 replies
How to Post JSON data to a site via API functionality: "Unsupported Media Type"

Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...
liqinglei419

Discussions |
Jul 2, 2019 6:33 AM

1667 views | 0 replies
How to analyze crossover design data in JMP

I had crossover design data from one of my experiment, and I want to analyze it according to the rules of crossover design. Can someone please help me with this?
sharmachetan

Discussions |
Jun 14, 2019 2:34 PM

1285 views | 0 replies