Test column data type
Hi, Is there a simple way to test if the data type of a column is numeric and nominal? Thanks and regards, Jérôme
j_bonnouvrier
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, Is there a simple way to test if the data type of a column is numeric and nominal? Thanks and regards, Jérôme
j_bonnouvrier
I have a raw dataset that does not have spec limits. The spec limits that I would like to add to the column properties are contained in another dataset. How do I pull the spec limits into the column properties without manually typing them into each column property?
I need help creating a script that will create a new table containing the UCL LCL and Average from a control chart. The control chart is created by a script using data from an excel file. I need the UCL LCL and Average to go back into the original excel file. I have found reference to a "Save Limits" option for control charts in JMP but I'm not sure how to use it or if it is even appropriate for...
Dear All, It's my first post here, I hope someone can help. I'm plotting several port cities on a map as part of an simple application I'm building. Next step I want to take is to draw circles on the map indicating a user-defined distance from the city defined by a value in the data-table which is modified via scripting. Simple example: plot the location of port of Rotterdam on a map, and draw a 1...
I have been doing a script that asks from user which two columns from original data will be chosen for Journal. I have manage to do that (see the code) but I want to add also item for input dialog where you could put any text that will appear later in the Journal (preferable before table). I do not know how to add "user can write text" option in dialog nor how to "print" that text later in Journal...
Hi, Is there a simple way to test if the data type of a column is numeric and nominal? Thanks and regards, Jérôme
j_bonnouvrier
I have been doing a script that asks from user which two columns from original data will be chosen for Journal. I have manage to do that (see the code) but I want to add also item for input dialog where you could put any text that will appear later in the Journal (preferable before table). I do not know how to add "user can write text" option in dialog nor how to "print" that text later in Journal...
Hi everyone, I am trying to sample data every 50 rows and check if values in a column, F, gives F(50)-F(1)>1. I don't want to use the lag function as it should only sample at row 1, 50, 100, 150 and so on. Thanks in advance!
The below code doesn't work, b/c JSL evaluates emptyVar when you try to pass it to the function instead of evaluating it on run time w/in the function.
isEmptyTest = Function({var},
return(isempty(var));
);
isEmptyTest(emptyVar);
It would be awesome if this was changed.
msharp
Hi guys,Glad to be part of this great community. Looking forward to making useful contributions.I need some help with determining the Signal to Noise Ratio (S/N) for my regression model. I am using JMP pro 11 software.Can anybody help me please? Thanks.
For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...
On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
JMP Student Edition is a professional statistics environment rather than a simplified teaching tool....
JMP imports and analyzes the important data you collect or store in a variety of databases and forma...
Este seminario web se presenta en español. Tanto si acaba de descargar la prueba gratuita de 30 días...
Date: Friday, February 20Time: 1:00–2:00 p.m. ETRegistration: FREE Whether you've jus...