JMP User Community

Latest Discussions

Change all columns names dynamically

I'm opening a text file that I want to concatenate with an existing JMP file. Unfortunately, the column names of the two files don't match and therefore can't be easily concatenated. I'm trying to change the column names of the text file to match those of the specific JMP file it will be concatenated to. To further complicate things, the quantity of columns and their positions change in the var...
terapin

Discussions |
May 15, 2014 1:22 PM

9646 views | 2 replies
how to creat new column if same name column does not exist

hi,I need to use few columns to do calculation. the question I have is how to create new column and set value of each cell to 0 if same name column does not exist, it there is the column, do nothing. I tried below but it does not work the column already exist. can someone helps me out?
=Data Table( "FinalBiningTable" ) << Get Column Names(); (Column_list);((contains(Column_list, "N(P, F)"))==0, Da...
robust1972

Discussions |
May 14, 2014 6:51 AM

9606 views | 3 replies
Open JMP file Using Variable and Wildcard

After prompting the user to select a text file, the file is opened and a variable is created based on the site name contained in this text data filename as follows
dt.rawdata = Open ( Pick File( ...... ));// Create string that is filenamedtname = dt.rawdata << Get Name;// Create variable called siteid that removes just the site name from the filenameIf( Word( 1, dtname, "_" ) == "UC", site...
terapin

Discussions |
May 13, 2014 3:10 PM

10345 views | 2 replies
Kappa Coefficient and Agreement Statistic

Hi all,Assume that I have two columns, Bob and Mary, who rate four items with either a Y or a N. In the following case, no Agreement Statistic is present when doing Fit Y by X, because it appears that JMP thinks that Bob and Mary do not have the same categorical levels. How can I set column "Bob" to inform JMP that Bob can also take on values or Y or N? For example, if I change one of the columns ...
barik

Discussions |
May 12, 2014 6:48 PM

15009 views | 2 replies
Moving / Rolling CpK

Hey Friends,I have a table with a continious process data. I want to calculate the CpK at every measurment, so that I can follow the variation in CpK with time. Is there an elegant way to do so ?RegardsSG
none1

Discussions |
May 12, 2014 7:31 AM

10716 views | 5 replies

Previous
Next

Latest Discussions

Moving / Rolling CpK

Hey Friends,I have a table with a continious process data. I want to calculate the CpK at every measurment, so that I can follow the variation in CpK with time. Is there an elegant way to do so ?RegardsSG
none1

Discussions |
May 12, 2014 7:31 AM

10716 views | 5 replies
Parameter estimates in Logistic Regression

I have simulated three data sets of 20M points each for testing LR with binary response variables with very rare events:1) Two continuous effects: Beta0=12, beta1=1 and Beta2=1. X1 is Normal (-0.8, .25) and X2 is -ABS[Normal (0,5)]. (Each of the two variables increases the probability of the event, depending upon the value of the variable.) In this case there are about 711,000 positive events in 2...
ranjan_mitre_or

Discussions |
Apr 16, 2014 12:18 PM

6924 views | 6 replies
Ternary Diagram: Density Countours

I have about 5000 points that I am plotting on a ternary diagram. Is there any way to have JMP plot density contours on the diagram (90% of the points fall within this contour, 80% fall within the adjacent contour) without coming up with a formula on my own? I am looking for contours in the form or a line, or a gradation in color.
pickle

Discussions |
Apr 16, 2014 9:15 AM

4721 views | 1 replies
Script for hiding/closing local data filter

I am trying to find a script which will close or hide the local data filter from a report. I have tried :Dispatch( {}, "Local Data Filter", OutlineBox, {Close(1)} );This seems to work for everything except the local data filter. Please help.
JesperJohansen

Discussions |
Apr 15, 2014 7:38 AM

4361 views | 1 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

2840 views | 0 replies

Previous
Next

Latest Discussions

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

2840 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

4282 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

5284 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

3553 views | 0 replies
Combining multiple screenings in Fit Model?

Hello, I've been using the Screening function to fit my data. It's been working well for individual outputs but I haven't been able to figure out how to make a model with multiple outputs and have it screen for the best fit for each output. The reason I would like to do this is to use the desirability function for multiple outputs, which has been pretty useful in determining the most ideal s...
dil950

Discussions |
Jan 23, 2014 8:13 AM

2444 views | 0 replies