JMP User Community

Latest Discussions

JSL question: select columns and replace missing values with zero

Hi, There are many numeric columns in the data table, and all of them have missing values in them. I want to select only few of them (considering that I know the column names already), and replace the missing values in them with zero.I wrote the code as follows, but it doesn't work. Could you help? Thanks! dt = data table("Untitled 9"); col_list = {"A","B"}; For( i = 1, i <= N Items( col_list ), ...
pomemelom

Discussions |
Mar 1, 2017 1:53 PM

9881 views | 4 replies
JSL - showing spec limits as graph reference lines (JMP 12)

I have recently updated to JMP 12.1 and was trying to port over an old script to set the spec limit property (see below). It works fine in JMP 11, but now that I'm running JMP 12.1, the code in red doesn't work. It doesn't error out, it just doesn't toggle the option for showing specs as graph reference lines. Has anyone found a solution to this?M JMP 11 code that worked but doesn't work with 12.1...
mohamed_elhassa

Discussions |
Mar 1, 2017 9:36 AM

11215 views | 3 replies
Predictive Modeling with asymmetric cost / imbalanced data set

Hello, How can I instruct predictive modeling platforms on JMP Pro (partition, random forests etc.) to assign a higher cost to falsely predicting the minority class. I have a dataset that is highly imbalanced with a high cost for false negative (readmission rate of acute patients) and when I use the classifiers the AUC is low and all positive cases are falsely classified. Please help on tools avai...
Nayimoni

Discussions |
Mar 1, 2017 6:13 AM

10687 views | 10 replies
Where is the binomial reliability calculation hiding?

I'm doing a binary test (pass/fail) and the number of acceptable failures depends on the sample size and acceptance/confidence limits. It's a binomial reliability calculation. I can find reliability lifetimes but no basic sample size calculator that takes failures into account. MiniTab has it clearly available, and I found very simple online calculators, but I need to document the calculations in ...
Lisa

Discussions |
Feb 28, 2017 4:05 PM

5105 views | 4 replies
Help with comparing two sets of data

I'm sure my problem is laughably simple, but I really need help! This is very much out of my skill level. I have two sets of data: 2015 and 2016 data for ER vist counts for different syndromes (asthma and general respiratory) and particulate matter pollution levels. I want to know the relationship of PM2.5 on ER visits, specifically, is there any difference between the 2015 and 2016 data and if so...
jennison_floyd

Discussions |
Feb 28, 2017 12:33 PM

33941 views | 10 replies

Previous
Next

Latest Discussions

Where is the binomial reliability calculation hiding?

I'm doing a binary test (pass/fail) and the number of acceptable failures depends on the sample size and acceptance/confidence limits. It's a binomial reliability calculation. I can find reliability lifetimes but no basic sample size calculator that takes failures into account. MiniTab has it clearly available, and I found very simple online calculators, but I need to document the calculations in ...
Lisa

Discussions |
Feb 28, 2017 4:05 PM

5105 views | 4 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3331 views | 0 replies
Using "Get Rows Where"

I need to use Get Rows Where to get the row with value that is just below certain value.In other words:I have a Date AI have a table with dates. I need to get the row where the date is the latest, but less than Date A Example:I have a date when person died.I have table with all event when somebody logged in into his account. There are dates before and after his death.I need to find the latest dat...
miguello

Discussions |
Feb 18, 2017 4:45 AM

7000 views | 3 replies
Make JMP Journal Transportable

JMP supports talks about "Building a JMP Journal Presentation". How can you create a journal that will still work when it is: Transported to another computer, possible switching between Windows and Mac, Viewable from a USB drive, no matter what drive/folder the host mounts the drive in.
kthompsn

Discussions |
Feb 15, 2017 10:45 AM

7337 views | 3 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4388 views | 0 replies

Previous
Next

Latest Discussions

Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3331 views | 0 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4388 views | 0 replies
How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

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...
MIKE

Discussions |
Dec 14, 2016 8:48 AM

4713 views | 0 replies
Odds ratios for multiway tables

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...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4868 views | 0 replies
How to find ETA squared effect size for MANOVA?

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...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3881 views | 0 replies