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
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi 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
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?
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...
Look at my attached file. I have fitted an Exponential 3P curve to data that is based on %. I have added a range check as well as a response limit for my "% knockdown" column. I would like to have my fit curve parameter estimates not exceed 100%. Is there a way to do this?
Hi all,I'm new to Access and I'm trying to connect to JMP using database open table. After selecting MS Access Database under the Machine Data Source, I keep getting this error: "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". Any suggestions or thoughts? Thanks for any tips!
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?
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...
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.
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...
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...
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...
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.
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...
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...
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...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...
Jump into Graphing Date: Wednesday, September 24Time: 1:00 – 2:30 p.m. ETDura...
German Mastering JMP Webinar Finden Sie heraus, wie Sie Analyseschritte interaktiv automatisi...