Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHello all, I am trying to find correlations between the expression of hormones and metabolites during different phases of growth from my company's omics data. I have structured my data with 4 columns: Type (hormone or metabolite), Name (of said compound), Phase (A,B,C or D), and Normalized Phase Averages (this is the raw data which is the level of expression of each compound. I have normalized for...
Kotton_King
Hi.Supposing that I have bunch of data but no Specification (LSL and USL).Data are diagnosed as to follow SHASH or other non-normal distribution. Is there appropriate analougues for the plus/minus 3 SD for normal distribution? (Since 6SD of normal distribution is usually used as Specification Tolerance) Alternatively, is there function that JMP calculated the possible Specification which ensures s...
MikeKim
Hi, I have a question about using process screening. I am trying to look for CPK analysis of a data sheet. When I try to use "Process screening" the rows were shuffled. Shown below is an example:We can see the order of Kelvin followed by Continuity But once the table is generated the test data sequence were shuffled. Need the community help to keep the test sequence as is compared to the rod...
Cognostar18
Hi everyone, I'm trying to upload my data table into SQL & I'm having issues getting the date columns to load in.
The error I receive is this: "[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: numeric is incompatible with date"I tried using SELECT CAST to make it into a date format but that didn't work. I'm using JMP 17.0.0. I used the base code from this post & tried to adapt it ...
Bagawandoss96
Hello all, I am trying to find correlations between the expression of hormones and metabolites during different phases of growth from my company's omics data. I have structured my data with 4 columns: Type (hormone or metabolite), Name (of said compound), Phase (A,B,C or D), and Normalized Phase Averages (this is the raw data which is the level of expression of each compound. I have normalized for...
Kotton_King
Hi, I have a question about using process screening. I am trying to look for CPK analysis of a data sheet. When I try to use "Process screening" the rows were shuffled. Shown below is an example:We can see the order of Kelvin followed by Continuity But once the table is generated the test data sequence were shuffled. Need the community help to keep the test sequence as is compared to the rod...
Cognostar18
Hi everyone, I'm trying to upload my data table into SQL & I'm having issues getting the date columns to load in.
The error I receive is this: "[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: numeric is incompatible with date"I tried using SELECT CAST to make it into a date format but that didn't work. I'm using JMP 17.0.0. I used the base code from this post & tried to adapt it ...
Bagawandoss96
I am trying to do a simple filter and save it to my table so I have the script for later use.
Basically I want my table to only show rows for a specific water meter, and then change the filter to show the rows only for another water meter.
This is because I know that one has more rows in the dataset than the others have... I also know through analysis in powerbi, that the scew is because one meter...
Prometheus
Bonjour à tous, Je dispose d’une base de données comme ceci (il s’agit d’un résumé ici) : Cette base de données est issue d’un script qui fonctionne bien jusqu’ici, cependant la dernière colonne permettrait de calculer une dernière durée différente des autres.Les valeurs dans cette dernière colonne représentent des OP qui correspondent à des objets. Par exemple pour la 1ère ligne : la valeur 60 co...
hcarr01
I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus
How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi
It seems the following command does not work for JMP MacOS.
Use JMP Locale Settings( 0 )
Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user?
// Configuring JMP to save CSV as commas and not
If( (Num( "3.14" ) == 3.14),
is_EN_num_format = 1, //"English numeric format"
is_EN_num_format = 0 //"Non-english");
)...
FN
Hi,
I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like
One example:
If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...
hogi
I ran a cross-over trial where healthy volunteers came to the lab twice (separated by a wash-out period) and underwent sensory testing at both arm and foot, before and after one of two neuromodulation interventions. Each participant underwent both conditions in a randomly assigned order. We want to see if the neuromodulation interventions affected the outcomes differently for the arm and the foot....
arnaudsteyaert
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Do you face challenges with restrictive data formats from EDS, XRD, or Raman instruments? Are the ex...
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...
jvine