JMP User Community

Latest Discussions

Setting Row Values Under a Given Condition

Hello, I am new to JSL and attempting to create a script that will change the value of certain rows in a given column. The general issue I am having is that my data is being categorized as from different locations, when in fact those sites are the same. So when I go to graph them, I get more groups than necessary. Here is the snippet of code that I was hoping would accomplish my goal: for each row...
lgober

Discussions |
Jul 17, 2020 1:33 PM

4945 views | 3 replies
two way anova with strongly unbalanced samples

In case like this, where the two sample sizes are so strongly different (25 vs 410), the standard anova test is it ok?
FR60

Discussions |
Jul 17, 2020 12:58 PM

6116 views | 6 replies
Converting a Julian Day into Month-Day

I receive material from a supplier that uses an encoded date in their material lot, which I'd like to convert to a regular date. It first encodes the three digit Julian date into a two-digit Base 36 hex, which I have found JMP can easily handle. But converting the Julian date to month-day has been surprisingly elusive. There isn't a mention of Julian conversion I can find. Seems like I should be ...
jay_holavarri

Discussions |
Jul 17, 2020 11:54 AM

6405 views | 1 replies
Create a column formula using a column name from a list

Hello, I have a simple script where I want to create a new column in which a formula calculate the absolute value of another column. the column is referenced in a list.I tried a few different ways, but I can't figure out how to evaluate the referenced column so I end up with an empty formula column. Any suggestion would be greatly appreciated. Best Sebastiendt=New Table( "test", Add Rows( 4 ), N...
Sburel

Discussions |
Jul 17, 2020 11:52 AM

4032 views | 3 replies
Add Annotations to Graph from a text data column?

Is there a way to have JMP add annotations to a graph from a text column? I have a large data table with time-series data. I would like to create a column called "comments" that contains unstructured text data. This column would be mostly empty, but when a "significant event" occurs a few words would be entered to describe what was happening at that time. Then, when I am looking at time seri...
Chris_Rodrigues

Discussions |
Jul 17, 2020 7:37 AM

8594 views | 3 replies

Previous
Next

Latest Discussions

Weighting Variables in regression models

I was wondering how to weight variables in a regression model. I have some variables that may contribute more to my model and I want to find a way to have JMP value these variables more so than other variables. I know I can enter them first into a stepwise regression model. I want to do that, but I also want to weight some variables more than others.
dross111E

Discussions |
Jul 17, 2020 7:36 AM

7694 views | 5 replies
How Do You display Regression Equation on Bivariate fit graph
Andrew_Botfield

Discussions |
Jul 17, 2020 2:41 AM

2455 views | 2 replies
Newbie Question extracting values from a report

Hi,I am trying to come up to speed on extracting values from a report called by a script.To test things out I create two simple columns and do a fit and I am trying to extract the intercept from the estimate just so I know what I am doing.Test=Bivariate( Y( :Column 2 ), X( :Column 1 ), Fit Line( {Line Color( {208, 64, 86} )} ));r=test<<report;fred=r[outlinebox("Linear Fit"),Outlinebox("Paramete...
Hegedus

Discussions |
Jul 16, 2020 10:38 PM

9622 views | 10 replies
Fit model using stepwise method

Hi,In the context of my PhD, I'm doing a Fit model using stepwise method to determine the set of factors that best explain my variable of interest (energy balance). When I click on GO this alert message appear: ALERT: Failed to converge (step-halving limit). I have put 50 variables in the construct model effect box. Then I clicked on RUN. I choose my stopping rule and direction and clicked on GO....
audreystlo

Discussions |
Jul 16, 2020 9:34 AM

1961 views | 1 replies
Is there a way to display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles in box plots in graph builder or one way plots

In my work we display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles + the mean in our box plots in excel (which is painful and time consuming) – is there a way of replicating this in JMP oneway or graph builder? andrew.botfield@geochemistry.com.au
Andrew_Botfield

Discussions |
Jul 15, 2020 4:28 PM

6630 views | 8 replies

Previous
Next

Latest Discussions

[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1288 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1311 views | 0 replies
How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4657 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2213 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

2019 views | 0 replies