JMP User Community

Latest Discussions

Create my own color map on correlation and correlation matrix

reposting, I must have accidentally deleted the original post:I am writing a teaching and demonstration script that will:Create a random covariance matrix of a specified size, and calculate the corresponding correlation matrix (C)Create random multivariate normal data with a specified number of rows and mean vector, based on the covariance matrixoutput the simulated data to a data table and run th...
MathStatChem

Discussions |
Aug 17, 2017 2:23 PM

10125 views | 4 replies
JMP 13 asks to save file when I just want to close

Some of my JMP 13 users cannot close a table without saving it. I have checked their preferences and I do not see anything requiring a SAVE before closing. Am I missing a preference? Thanks
john_along

Discussions |
Aug 17, 2017 10:06 AM

3613 views | 3 replies
how to remove a local data filter column?

Hello, I have a problem that can be simplified to the following example: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Cities.jmp" ); obj = dt << Data Filter( Add Filter( columns( :Region, :POP ) ) );Is there a way to remove :Region from the data filter without deleting the data filter and creating a new one? Thank you for your help!
newbie_alex

Discussions |
Aug 17, 2017 9:04 AM

5445 views | 1 replies
How do I calculate a ratio with negative numbers

Without using scripting, I want to create a formula that computes a ratio between two columns of CAGR percentages, taking into account that some of the percentages are negative (meaning simple division will not suffice). A formula that might accomplish this is:If the above formula would work, how would I incorporate the comma in the JMP formula box? Or, is there a better way to compute the ratio?
rj69

Discussions |
Aug 16, 2017 12:51 PM

17851 views | 2 replies
Run VBA code in JSL script

Hello all! I'm new to JMP. I've seen many post claiming that it is possible to run a JSL script via Excel VBA. I was wondering if the other way around is possible. Run VBA code inside a JSL script. Reason: I have a macro in Excel and a script in JMP. I would have liked to bring the excel macro to my JMP script. Thanks for info!
Eduardo

Discussions |
Aug 16, 2017 11:42 AM

7753 views | 2 replies

Previous
Next

Latest Discussions

JMP 13 asks to save file when I just want to close

Some of my JMP 13 users cannot close a table without saving it. I have checked their preferences and I do not see anything requiring a SAVE before closing. Am I missing a preference? Thanks
john_along

Discussions |
Aug 17, 2017 10:06 AM

3613 views | 3 replies
Scaling a window to be saved as a PDF?

Hey JMP Community I am new to JSL, and have been working on a script for the past week or so. The final portion of the script is supposed to take a graph and save it as a PDF. The issue I am having is that I cannot seem to find a way to scale this PDF down to one page. I can do this manually by clicking "Save As" in the graph window, choosing the PDF file format, and setting the scale to 80%. Curr...
michaelgroom

Discussions |
Aug 16, 2017 9:25 AM

10082 views | 4 replies
MANOVA Partial Covariance Matrix

Hello, I am getting familiar with JMP's Fit Model platform by trying to match results with MATLAB and MS Excel long-hand that I have computed. Using the "Cholesterol.jmp" sample data file and running the Fit Model platform with MANOVA personality, I was a bit confused as to why my Partial Covariance matrix did not identically match my Covariance Matrices in MATLAB and MS Excel. Here is the JMP ou...
bio_grad

Discussions |
Aug 14, 2017 8:02 PM

8234 views | 3 replies
Graph Builder: Convert x-axis label from horizontal to vertical

Hello, I'm using Graph Builder (JMP 10) to group 3 items (WAT date, Lot#, and Wfr ID) on the same x-axis. In the attachment, only Wfr ID is vertical. Is there any way I can convert the horizontal labels of WAT data and Lot# to vertical ones for a clearer visualization? Thank you! Best,Han
ngochanle2210

Discussions |
Aug 14, 2017 1:25 PM

4385 views | 1 replies
Transfer columns with values to a new table

Please will you help me with this script. I'm trying to transfer a column full of items/values (some characters and Numerics) from an old table to a new table and this scripts is not fully working. I'm propably missing something. I'm sorry I'm new to JMP. DATAtwo=Data Table("Results Extract");testid = DATAtwo:column3 << Get Values; // Testtrans =Column(testid);　dtfour << New Column( "key", formula...
IrisK

Discussions |
Aug 12, 2017 6:47 AM

7914 views | 2 replies

Previous
Next

Latest Discussions

JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4380 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2159 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4259 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3313 views | 0 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

3334 views | 0 replies