JMP User Community

Latest Discussions

How to use Variables for Custom Quantiles

Dear Community, I've been struggling for a while now, looking for a way of replacing the hardcoded values 0.95 and 0.99 below, with variables in an Application. Continuous Distribution( Column( Eval( colSelect ) ), Horizontal Layout( 0 ), Histogram( 0 ), Vertical( 0 ), Std Error Bars( 1 ), Count Axis( 1 ), Show Percents( 1 ), Show Counts( 1 ), Axes on Left( 1 ), Outlier Box Pl...
HubP_SDe

Discussions |
Feb 1, 2021 3:46 AM

2370 views | 2 replies
How to calculate linear-Log trapezoidal method (lin up /log down) in JMP?

Hi!!I have previously been calculating the trapezoidal equation from my data without any issue in JMP but I need to run this time a Linear-Log trapezoidal method (lin up /log down).Can somebody give me a hand with the script or equation I should include for such type of analysis? Thanks in advance.Best, Marlly
Marlly_Guarin

Discussions |
Feb 1, 2021 2:56 AM

2646 views | 2 replies
script to add two column

i am trying to add two columns. two of the column has name abcd and efgh following line works: dt_tab << New Column( newcolumn, formula( :name( "abcd" ) + :name( "efgh" ) ) ); but following code is throwing an error name1 = "abcd"; name2 ="efgh"; dt_tab << New Column( name1 || "3", formula(:name(name1) + :name(name2))); why is the 2nd method not working?
tangxu

Discussions |
Jan 31, 2021 9:13 PM

2322 views | 3 replies
Compare strings and highlight differences

How would I write a function or routine that would compare two strings and show the difference between them?e.g.string1="It will rain tomorrow"string2="It will snow tomorrow"comparison result (string2 vs string 1) = "It will ~~rain~~snow tomorrow"
MathStatChem

Discussions |
Jan 31, 2021 6:18 PM

6361 views | 6 replies
Converting Military Time Format (hhmm) to Time Format (hh:mm)

I need to convert military time in the hhmm format, e.g. 1432 or 725 to hh:mm format e.g. 14:32 to 7:25. Is there a simple formula that can make the conversion, or should I use a script for it? Thanks.
nadershakerin0

Discussions |
Jan 29, 2021 9:00 AM

31201 views | 11 replies

Previous
Next

Latest Discussions

How to calculate linear-Log trapezoidal method (lin up /log down) in JMP?

Hi!!I have previously been calculating the trapezoidal equation from my data without any issue in JMP but I need to run this time a Linear-Log trapezoidal method (lin up /log down).Can somebody give me a hand with the script or equation I should include for such type of analysis? Thanks in advance.Best, Marlly
Marlly_Guarin

Discussions |
Feb 1, 2021 2:56 AM

2646 views | 2 replies
Compare strings and highlight differences

How would I write a function or routine that would compare two strings and show the difference between them?e.g.string1="It will rain tomorrow"string2="It will snow tomorrow"comparison result (string2 vs string 1) = "It will ~~rain~~snow tomorrow"
MathStatChem

Discussions |
Jan 31, 2021 6:18 PM

6361 views | 6 replies
Import Excel data from specific Excel cells

I have situation where the data I need to analyze in JMP is stored somewhat haphazardly in in an Excel file. I fortunately can easily get a list of the Excel cells that the data is in, and I would like to automate with JSL importing those values. I am looking for ideas on how to do this effectively and efficiently. For example, let's say the data I need in a single column in JMP is stored in ...
MathStatChem

Discussions |
Jan 29, 2021 8:08 AM

5856 views | 7 replies
Normal Mixture Clustering - force SDs to be equal?

Hello, Is there a way to force the standard deviations between clusters to be equal when doing the normal mixtures clustering analysis? Thanks for any help! Carmen Annevelink
cea5320

Discussions |
Jan 29, 2021 5:29 AM

1340 views | 1 replies
How to change number of decimal places in Bar chart labels (Label by Percent of Total Values)

Hi, I am struggling with (what i believe is) a basic task of changing decimal places of labels shown on the Bar chart. I have a table with few around 3000 rows and a column that can have 4 distinct values. When using Label by Percent, some of the labels are shown with 0 decimal places, and some with 1. This results in sum of all values is different from 100%. Is there any easy way to change this?...
Interval

Discussions |
Jan 28, 2021 6:24 AM

5946 views | 1 replies

Previous
Next

Latest Discussions

Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1513 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

4252 views | 0 replies
Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1907 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1595 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

1017 views | 0 replies