JMP User Community

Latest Discussions

How to "lock" single column width in JMP

Greetings,I have a single column (Data Type > Character) in JMP file (using 10 Pro) that requires extremely long character strings. Unlike Excel, I cannot find a simple way to "lock" the column width, which results in auto-resizing the column to massive widths upon reopening the file, entering new text, etc. Note: I do not want to use the actual Lock feature (under Column Info), as I need to const...
optflow

Discussions |
Mar 20, 2014 11:41 AM

11378 views | 3 replies
JMP error: blocking ignored because cell counts were unequal

Hi,I'm trying to do a fit Y by X and I have experimental blocks, but when I try to include them, I get this error:"Blocking ignored because cell counts unequal"I have 20 varieties of plants, 3 biological reps of each, and 3 technical reps of each (measurements)I want to fit the response (glucose release) to the factor (variety) and have nested blocks of bio & technical reps.My intention is to see ...
odoyle81

Discussions |
Mar 19, 2014 11:20 AM

4899 views | 4 replies
Check if a column has numeric data

Hi everyone,I loop over columns in a table collected from the DB. Some of them have no data in them (leading to empty charts). Is there a way to check if a column has numeric values?thx guys,Jan
jan_solo

Discussions |
Mar 19, 2014 5:33 AM

11607 views | 2 replies
Quick question about screening design

When making a simple screening design including only main effects the model still presents (in my case two) 2xinteractions in the Fit Model, Model Specification, Construct Model Effects box. Why is this?
Anonymous

Discussions |
Mar 17, 2014 5:36 PM

3497 views | 3 replies
finding the mode

hi everyone,i would like to produce a table summery that gives the mode of a variable for each category of another variable.ideally, this would work:dt = open ("$SAMPLE_DATA/Mail Messages.jmp");
dt << summary ( Group ( :From ), Mode (:To) );alternatively, i would stack the table by "From" and calculate the mode at each row. yet, "Mode" is not an option in Table summary or column formula.any ideas c...
ron_horne

Discussions |
Mar 13, 2014 6:48 PM

15809 views | 11 replies

Previous
Next

Latest Discussions

JMP error: blocking ignored because cell counts were unequal

Hi,I'm trying to do a fit Y by X and I have experimental blocks, but when I try to include them, I get this error:"Blocking ignored because cell counts unequal"I have 20 varieties of plants, 3 biological reps of each, and 3 technical reps of each (measurements)I want to fit the response (glucose release) to the factor (variety) and have nested blocks of bio & technical reps.My intention is to see ...
odoyle81

Discussions |
Mar 19, 2014 11:20 AM

4899 views | 4 replies
Quick question about screening design

When making a simple screening design including only main effects the model still presents (in my case two) 2xinteractions in the Fit Model, Model Specification, Construct Model Effects box. Why is this?
Anonymous

Discussions |
Mar 17, 2014 5:36 PM

3497 views | 3 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

5090 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

3401 views | 0 replies
How to split the data and plot the graphs based on date

I have the data for 2 years (2011 to 2013) with a date column in 'YYYY-MM-DD' format, I want to split the data into monthly parts i.e 2011 Jan - Feb.... to 2013 Nov and also plot histogram calculate the total no case reported each month for period of 2 yeaer. Please let me know how can I split the data and the plot a line graph to compare the performance. I m very new to JMP. Kinldy assist CA...
nyeesg

Discussions |
Jan 29, 2014 7:07 AM

5497 views | 4 replies

Previous
Next

Latest Discussions

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

5090 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

3401 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

2339 views | 0 replies
Multiple F-tests

I am looking for a feature similar to the "Compare Means" -> "Each pair by Student's t" found under the "Oneway" "Fit X By Y" analysis option. That is, I want to perform an F-test between any two levels of the categorical X-axis variable, yielding the P-values for each test and hopefully also a "Connecting Letters Report" or something equivalent. Preferably I would like to do this for either one o...
JesperJohansen

Discussions |
Nov 28, 2013 4:41 AM

2885 views | 0 replies
Bar chart with data table

I need to create some graphs like the one shown in the picture below (Excel).What is important is that the bar groups are displayed with the individual data.I know that I can chart a bar graph and then insert a table below it. But wouldn't it be difficult make it look as nice as the Excel version.What would be an alternative solution that works just as good visually?Any help is greatly appreciated...
peder

Discussions |
Nov 19, 2013 1:08 PM

3404 views | 0 replies