JMP User Community

Latest Discussions

<< Get Values from a Column without subsetting each set of row selection.

So, I have a big dataset. Currently I am selecting few rows for each condition, subsetting the data and run << get values (im My JSL script) to move data to defined LIST. This process is taking significant time, because as i mentioned dataset is huge.I want to know, if there is a way to << get values from a column for the selected rows without doing subset everytime. \Or I have to subset every...
jump

Discussions |
Sep 15, 2014 8:23 PM

14892 views | 2 replies
Import from Excel yields random missing fields (dots) in JMP

Hi,

All my source data is in Excel and when importing into JMP, either by Opening the file directly or by doing a scripted Open Database(), I have some columns of numbers that show up with missing fields(dots). The data in Excel is a formula which provides a number. I can't find a pattern that would hint to why this is happening (some fields are ok).

Any suggestions or known errors?

I'm using JMP8 ...
alex

Discussions |
Sep 15, 2014 4:58 PM

6689 views | 3 replies
How to remove blank spaces from a List in JSL ?

Hello all , I am new to JMP Scripting . I was working on something and was trying to delete empty spaces from a list in JMP . I have done the following in order to do that : for(i=1,i<nrows(dt),i++, if(SampleList(i)== "", //then Remove From(SampleList,i,1); //else , ShowSampleList); ); );
uday_guntupalli

Discussions |
Sep 15, 2014 11:34 AM

11811 views | 4 replies
Can I have a 3-level categorical factor in a definitive screening design?

It seems that when using the JMP definitive screening platform in JMP 11 Pro I can only enter two levels for each categorical factor. I need to include a 3-level categorical factor in my DOE. Is this in any way possible? If so, how?
notoriousapp

Discussions |
Sep 15, 2014 10:16 AM

11983 views | 4 replies
How to preserve rows states\color for a graph builder using bar chart

Hi,i am building a graph using JSL and graph builder . I have data set where i assign row_states\colors\markers by a (for loop) as no. of rows keep changing with every data set. Now when i plot a bar chart with Graph builder, these rows states do not set the color marked for each row in bar chart.Is there something missing while setting up graph builder in JSL, as same rows show right colors when...
jump

Discussions |
Sep 13, 2014 6:15 PM

14929 views | 9 replies

Previous
Next

Latest Discussions

Import from Excel yields random missing fields (dots) in JMP

Hi,

All my source data is in Excel and when importing into JMP, either by Opening the file directly or by doing a scripted Open Database(), I have some columns of numbers that show up with missing fields(dots). The data in Excel is a formula which provides a number. I can't find a pattern that would hint to why this is happening (some fields are ok).

Any suggestions or known errors?

I'm using JMP8 ...
alex

Discussions |
Sep 15, 2014 4:58 PM

6689 views | 3 replies
EMS vs REML - why do the standard errors differ?

Hi,I've just set up a series of mixed models using the Fit Model platform using one of the JMP demo data sets ("Blood Pressure", in which I've set Doses as a fixed effect and Subjects as a random effect). To analyse those models I have a choice of methodologies: EMS or REML (recommended), so I tried them both, added a pairwise comparison of the doses (the "LS Means Student's t" option on the "Eff...

Discussions |
Sep 12, 2014 12:20 PM

6437 views | 2 replies
JMP Interactive HTML Examples

Update: Now that JMP 14 is released, we've added more examples. You can read about updates to Interactive HTML in JMP 14 here and here. We updated our JMP Interactive HTML Examples and this post for the release of JMP 13 at JMP Discovery Summit. Interactive HTML is all about sharing, so we decided to share a few examples of interactive HTML reports with JMP Discovery Summit attendees next week...
John_Powell_JMP

Discussions |
Sep 12, 2014 7:38 AM

8435 views | 2 replies
How may I see variable tabs in JSL Debugger

Hi folks,I am trying to use JSL Debugger for first time and I could not control how to display botton page tabs, as Global, Local, Watch, ...I do not know why, but in my window I see the one I leave here so I can't see Variable values(even I do CRTL-SHIF- - to decrease view).Could you help me?w. Thank youTeresa
teresa

Discussions |
Sep 8, 2014 2:03 PM

3455 views | 1 replies
Appending Data To Table

I have a large data table in JMP with several scripts saved to the table. Each week, I receive additional data via Excel files to append to the data table and repeat the analysis via the saved scripts. The problem is appending the data to the JMP data table from the Excel files. Can someone explain how to do this without having to create a whole new data table each time and so that I can utiliz...
Steven_Moore

Discussions |
Sep 3, 2014 9:41 AM

4495 views | 2 replies

Previous
Next

Latest Discussions

What robust methods are common for Process Capability Indices for Non-Nornal distributions?

In Europe, we found it common to use Cpkn as a non-normal Cpk metric, where mean was replaced with median, and stdev was replaced with IQR/1.35. For some "regulatory" or "customer" reports, this seems to be accepted rather than the usual "torture the data until it says its normal" approach with transformations. Does anyone have similar experience or better ideas? (Note: any use of capabilit...
mclayton200

Discussions |
Jun 19, 2014 2:05 PM

4883 views | 0 replies
Graph Builder Remove Variable

Hello,I am trying to use jsl to remove the x-axis variable and replace it with a different one. It looks like I should use the GraphBuilderBox <- Remove Variable() tool, but since I change the x-axis variable multiple times, I do not know its name and would like to use the Remove Variable(Role("X"), Position(1)) method, but this does not work. Any assistance would be appreciated.Thank you,Martin
Martin

Discussions |
Apr 15, 2014 6:44 AM

2747 views | 0 replies
How to calculate average (median) of a group of variables to get the eudlidean centre

How would I calculate the shape of the average (using the median) of a variable from a group within a data set? I need a certain function for calculating the centre of gravity (centroid) or Euclidian centre of this group of variable.
Many thanks!!
alexsheehy1992

Discussions |
Apr 2, 2014 12:17 PM

4173 views | 0 replies
LD50 and LT50 calculation

Hi everybody,I would want to calculate LD50 and LT50 from a dataset organized in 6 columns:- Name of the compound (I just got 1 compound named A)- Concentration of the compound (2 dilutions per compound)- Individual number (a fixed number of 10 individuals is used per assay)- State of the individual at the end of the experiment (1 = alive, 0 = dead)- Day death (experiment last 15 days)- Experiment...
cecilia

Discussions |
Mar 5, 2014 8:13 AM

5112 views | 0 replies
How to add "All pair Tukey-Kramer" & mean diamond in graph builder box plots?

We can do as above simply using "Fit Y by X" with quantiles and compare means , however I can't find the way if I compile box plots using graph builder (especially when I need to compare more complicated box plots).Can anyone show some hints please? Thank you very much.
Anonymous

Discussions |
Mar 2, 2014 9:15 PM

3422 views | 0 replies