Reading Excel file - column with numeric and character values
I am reading Excel file with JSL, first 2000 rows of column are numeric, followed by rows with characters. How do I make sure the column is read as character?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am reading Excel file with JSL, first 2000 rows of column are numeric, followed by rows with characters. How do I make sure the column is read as character?
Hello JMP Gurus,I am using the JMP NonLinear platform fit for fitting a 6-parameter model for 2 categories (using By). I am providing reasonably good initial guesses for the parameters.1) I would like to lock 2 of the 6 parameters for a first iteration for easier convergence. How can this be done via JSL?2) I would like to first run with the 2 locked parameters, and after the first "Go" converges,...
Hi,Here is roughly what I'm trying to do:ob = Outline Box( "OB", hlb1 = H List Box() );
hlb2 = H List Box();
hlb2 << append( Picture Box( Open( FilePath , html )));I understand that Picture Box doesn't support .html, but is there anyway to get this to work?Is it possible to convert .html to .png within JMP script?
I am running an EWMA control chart via Analyze > Quality and Process > Control Chart >> EWMA Control Chart. It appears that I am unable to add a title to the chart. I am also trying to set up a script. I have the basic code,
EWMA Control Chart( Y( :Thickness ), Subgroup( :Date ), Lambda Slider( 1 ) );
in place. Is there a way through either scripting or the above portal to add a title? Can an ...
Hi, i am running an experiment based on DOE. one of the responses is viscosity cure that is related to formulation rheological behavior.the plots are viscosity Vs shear rate. For different formulations, the plots appear to be a bit different. Is there any way to compare and treat it as response for DOE further analysis?
Hi,Here is roughly what I'm trying to do:ob = Outline Box( "OB", hlb1 = H List Box() );
hlb2 = H List Box();
hlb2 << append( Picture Box( Open( FilePath , html )));I understand that Picture Box doesn't support .html, but is there anyway to get this to work?Is it possible to convert .html to .png within JMP script?
Hello, I have a observation scale that calculate amount of times a behavior occurs which could be any where from 0 to 40+ so I assume it could only be a continuous variable. I am wanting to run agreement statistic but because both are continuous it won't let me do that in JMP. Any tips or tricks on how to get an agreement stats with continuous variables?
Hi, I am doing FTIR analysis and would like to compare FTIR spectrum plot with many peaks of the reference to another sample one. the goal is to find new peaks that appear in the sample material. is there any way to do it automatically in JMP?An example of ftir plot attached
Hi,I want to conduct an analysis for comparing two groups with paired samples for similarities (they should be similar).My choice was the TOST Test with pairwise comparisons. My boundaries for no difference were 0.4. The output of the analysis is this:Does this mean that there is no difference between the groups as it says: mean difference ≤ 0.4 with p < 0.05 ?Sorry this is the first time I work w...
Hi i need to calculate the lower bound ppk with one sided CI of 95The default option is two sided how can i calculate onle the lower bound ppk without the upper CI in minitab this option exist see attached , where is the same option in JMP
HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4;
// Création de la Carte de controle si N catégories > 5
Names Default To Here( 1 );
If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5,
Gr...
While taking the Exploratory Data Analysis module, it is time to practice. However, when trying to access the JMP Virtual Lab, I cannot get past the "Create User" option. JMP VIRTUAL LABTo use the Virtual Lab, please select the Create User link below. If you would prefer to use software on your own machine, please select the Download Data link below.
Create User Download Course Data Clicking the C...
Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...