JMP User Community

Latest Discussions

Confusion using word( ) function and specified delimiter

Hello all, I'm trying to manipulate my column names. It's very easy to do once or twice with Find/Replace but I'd like to script it. Essentially, I want to change a column name from "Singlets/Live leukocytes/Lymphocytes/B cells/A+B+C-,Freq. of Parent" to "B cells/A+B+C-,Freq. of Parent". Here is my current code: dt = Current Data Table (); colList = dt << get column names(string); For ( i =...
lakepotter

Discussions |
Oct 11, 2018 10:18 AM

8368 views | 8 replies
"Specified Column not found in data table" in Fit Model using JSL

I have a script that makes a Fit Model from a table I import. My problem is that I get this error when accessing the data.
"Specified Column not found in data table.{4759} in access or evaluation of 'List' , {/*###*/data:T_VALUE}" When I try to access the column through "Show" I get good results:

"data:T_VALUE = 1;" My code: data = Open( "C:/Users/taviad/Desktop/Sheet1.jmp" ); Show(data:T_VA...
tomerFire

Discussions |
Oct 11, 2018 9:10 AM

10082 views | 7 replies
Extracting the script behind addins

Is there any way I can extract the script behind add ins like the Table Attributes add in or Limits to data table add in?
Aam_jmp

Discussions |
Oct 10, 2018 7:05 PM

7517 views | 3 replies
In Split data table fucntion, how to input variable in "Remaining Columns" ?

Hi,I am making a script where the user inputs columns using a GUI and then the script splits the input table and make some correlation plots. The user input is very similar to the what the regular JMP Split function needs. My code for splitting looks something below, where remcol = "Drop all" or remcol="Keep all", depending on the user input. Splitdt = dt << Split( Split(Eval...
shaira

Discussions |
Oct 10, 2018 7:02 PM

5005 views | 2 replies
Parse XML Help

All,
I have some XML, I would like to parse using JSL. I am not familiar with XML, so pardon my ignorance.
<Table><Rule DayName=\!"Sunday\!" Val1=\!"1\!"/> What I tried is the following: Parse XML( Test, On Element( "Table", Start Tag( New Table( XML Attr( "Table" ) ) ) ), On Element("Rule",End Tag( New Column( XML Attr( "DayName" ), Set Values( Parse( XML Text() ) ) ) ) ) ); I...
uday_guntupalli

Discussions |
Oct 10, 2018 6:43 PM

4649 views | 1 replies

Previous
Next

Latest Discussions

Confusion using word( ) function and specified delimiter

Hello all, I'm trying to manipulate my column names. It's very easy to do once or twice with Find/Replace but I'd like to script it. Essentially, I want to change a column name from "Singlets/Live leukocytes/Lymphocytes/B cells/A+B+C-,Freq. of Parent" to "B cells/A+B+C-,Freq. of Parent". Here is my current code: dt = Current Data Table (); colList = dt << get column names(string); For ( i =...
lakepotter

Discussions |
Oct 11, 2018 10:18 AM

8368 views | 8 replies
Extracting the script behind addins

Is there any way I can extract the script behind add ins like the Table Attributes add in or Limits to data table add in?
Aam_jmp

Discussions |
Oct 10, 2018 7:05 PM

7517 views | 3 replies
How to calculate the variance of the weighted sum of >10 components

Perl https://stats.stackexchange.com/questions/5392/variance-of-two-weighted-random-variables; the variance of A+B is: Thus, one would imagine that the calculation of the weighted sum of >10 components will be very very complicated. Was wondering whether JMP has an easy way to perform the calculation. Thanks!
ILoveJMP

Discussions |
Oct 10, 2018 9:55 AM

11957 views | 5 replies
DOE L18 Design matrix

Hi, I am running a Screening Design of experiment to identify the key factors affecting the output variable. The DOE includes 7 factors. Out of which 6 factors have 2 levels and 1 factor has 3 level. JMP is suggesting the L18 Hunter design matrix. But if I review the design matrix two of the runs (15 & 17, 16 & 18 in attached picture) have the same factor settings. Can you suggest why this is the ...
tahirawan11

Discussions |
Oct 10, 2018 1:09 AM

4002 views | 2 replies
how to generate an interaction plot based on parameter estimate output?

I am analyzing a set of data about graph performance. I am comparing surface graphs with non surface graphs. In this analysis I have two tasks, A and B. I'm measuring the absloute difference (=participant's answer-correct answer). ABSDifference is ranging from 0 to 100. Its distribution is like a half normal distribution. To analyze this dataset, I used Fit Model, ABS differnce as Y by Graph and ...
samanb

Discussions |
Oct 9, 2018 1:06 PM

4777 views | 3 replies

Previous
Next

Latest Discussions

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

3676 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

2510 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

3507 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2505 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

3090 views | 0 replies