JMP User Community

Latest Discussions

Change Values in a Column

I found a script that works well however the time it takes to parse at minimum of 80,000 rows is quite long. This is only 1 wafers worth of data and there is an option to add an entire lot ( 7 more wafers). Which the time it takes to change the values will increase by a lot. Any suggestions?Thank your = dt << Get Rows Where( :testname == "test1" ); Column( dt, "channel" )[r] = "N/A (test1)";...
Yngeinstn

Discussions |
Jan 25, 2019 11:17 AM

9327 views | 4 replies
Does JMP still have a function called Exact Wilcoxon Rank Sum test?

Dear Experts, In the older version of JMP, there is a function called "Exact wilcoxon Rank Sum test" specifically used for nonparametric comparison for small sample size (e.g., n<5). However, in the current version (14.0) I did not see this function any more. Can anyone suggest a new function in the new version with similar or the same power as the "Exact wilcoxon Rank Sum test"? Oneway( Y( :C10...
Windermere

Discussions |
Jan 25, 2019 7:13 AM

10240 views | 6 replies
Automating JMP through Visual Basic (VBA code to import excel data table to JMP)

Hi All, I just want to load data from "combine" sheet to JMP by using VBA code.From JMP menu bar below, actually I can directly click to each option and it also works.But I prefer to do it by VBA coding instead of click directly, may I know how can I touch it by VBA code?Thanks for help.
AlexDong

Discussions |
Jan 24, 2019 9:50 PM

5346 views | 3 replies
Lock Size of Graph Builder with Page and Wrap Variables

Is there a way that I can force the graphs in graph builder to stay the same size? I have an analysis that opens an interactive graph that includes both wrap and page variables. There is a local data filter that allows the user to go look at the data by instrument. However, not every instrument contains data in all of the categories of the page variable. I can't figure out how to keep the graphs f...
aallman

Discussions |
Jan 24, 2019 2:26 PM

4027 views | 2 replies
Extracting substring and converting to column

Hi, Need some help with proceesing a long string.I have a table with several columns;one column has a long string as follows-EntitySubstringARWYT|ZZRZQ_pp29_Nxy13_7|54.58|ZZRZQ_pp29_Nxy13_3|51.72|ZZRZQ_pp29_Nxy13_5|54.31I need to remove first four characters "RWYT" and expected output is as follows: EntitySubstringZZRZQ_pp29_Nxy13_7ZZRZQ_pp29_Nxy13_3ZZRZQ_pp29_Nxy13_5ARWYT|ZZRZQ_pp29_Nxy13_7|54.58...
ENTHU

Discussions |
Jan 24, 2019 1:21 PM

3964 views | 1 replies

Previous
Next

Latest Discussions

Automating JMP through Visual Basic (VBA code to import excel data table to JMP)

Hi All, I just want to load data from "combine" sheet to JMP by using VBA code.From JMP menu bar below, actually I can directly click to each option and it also works.But I prefer to do it by VBA coding instead of click directly, may I know how can I touch it by VBA code?Thanks for help.
AlexDong

Discussions |
Jan 24, 2019 9:50 PM

5346 views | 3 replies
Lock Size of Graph Builder with Page and Wrap Variables

Is there a way that I can force the graphs in graph builder to stay the same size? I have an analysis that opens an interactive graph that includes both wrap and page variables. There is a local data filter that allows the user to go look at the data by instrument. However, not every instrument contains data in all of the categories of the page variable. I can't figure out how to keep the graphs f...
aallman

Discussions |
Jan 24, 2019 2:26 PM

4027 views | 2 replies
Extracting substring and converting to column

Hi, Need some help with proceesing a long string.I have a table with several columns;one column has a long string as follows-EntitySubstringARWYT|ZZRZQ_pp29_Nxy13_7|54.58|ZZRZQ_pp29_Nxy13_3|51.72|ZZRZQ_pp29_Nxy13_5|54.31I need to remove first four characters "RWYT" and expected output is as follows: EntitySubstringZZRZQ_pp29_Nxy13_7ZZRZQ_pp29_Nxy13_3ZZRZQ_pp29_Nxy13_5ARWYT|ZZRZQ_pp29_Nxy13_7|54.58...
ENTHU

Discussions |
Jan 24, 2019 1:21 PM

3964 views | 1 replies
JMP PCA Data Help!

I'm new to doing PCAs in JMP. Playing around with it though seems fairly simple. However, when I'm uploading my own data, that's where the problems begin. I am doing 3D GM, so each landmark (36 in total) has an X, Y, & Z coordinate. In a simple txt or Excel table, the data for each specimen is converted into 3 columns (an X, Y, & Z column) with 36 rows (a row for each landmark). It would seem that...
dinosaur4

Discussions |
Jan 24, 2019 7:39 AM

6029 views | 5 replies
Sample Size and Power Calculation

Hi All, I'm seeking help on how to determine the statistically correct sample to be used for my experiment.Below is the scenario and given data: Hypothesis: The new chemical Z used in process A has no significant difference in Process Sigma A.Matrix: I have 3 cells to be evaluatedCell 1: POR , Chemical XCell 2: Chemical Z1 (certain concentration)Cell 3: Chemical Z2 (certain concentration) Process ...
switzal87

Discussions |
Jan 23, 2019 1:04 AM

4853 views | 1 replies

Previous
Next

Latest Discussions

I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2557 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3234 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3637 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2460 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3434 views | 0 replies