JMP User Community

Latest Discussions

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

9310 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

10129 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

14708 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

10303 views | 5 replies
plotting two years data over the same calendar dates with error bars

Hello, I am new to JMP and am a bit lost as to how to do this:I have river temperature data from 2 study years; samples were taken at animal locations and so for a given day i could have 0-7 temp readings. I am trying to plot them on the same graph with the x-axis being month/day and data series being 2012 & 2013. For each day with samples i want to display the average temp for that day with sta...
jgolach

Discussions |
May 8, 2014 11:56 AM

10526 views | 4 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

10303 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

6511 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

4577 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

4190 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

2747 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

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

4175 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

5113 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

3423 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

2353 views | 0 replies