JMP User Community

Latest Discussions

Date-Time Formats

I have date-time data in a column of form:2020-04-30T17:29:48.967-04:00 This data was loaded from a database. JMP recognizes it only as a string of characters.How can I convert this into a JMP datetime format?P.S. I do not care about the timezone (-04:00).
jfsilves

Discussions |
May 11, 2020 10:16 AM

2129 views | 1 replies
PCA/Factor Analysis with ordinal data

I have a dataset from social sciences that contains many ordinal categorical variables with > 2 levels which are linked to scores like 1 2 3..I was asked if there are correlations between these ordinal variables so question: how to carry out correlation and PCA/Factor Analysis with this kind of data? Thanks for help!
frankderuyck

Discussions |
May 11, 2020 8:52 AM

7833 views | 11 replies
How to perform MANOVA with continuous variables which are not normally distributed (non-parametric)

I am performing an analysis of hemoglobin values at 3 different time points between cases and controls. The data is not normally distributed. How should I go about with MANOVA in such a setting? Also is there an alternative test that I can apply in JMP to see the differences in the cases & controls at these 3-time points.
Uday

Discussions |
May 11, 2020 7:48 AM

2752 views | 4 replies
One Way ANOVA figure for Scientists

I get asked about this one figure a lot. Almost as many times as I've made it. A google search for ANOVA images brings up this figure with hundreds of different data sets. I put together a Blog Post with a Script for how to make the figure. There are a number of subtle variations out there too. So... How do you make this figure? I'm thinking of making launch dialog that includes opti...
Byron_JMP

Discussions |
May 9, 2020 7:32 AM

1927 views | 1 replies
JSL: Color or Mark by Column

I'm trying to color and mark by a specific column that was created using the "Word()" function. For some reason, the "Color or Mark by Column" function doesn't work with the (word) formula created column. It works fine for any other columns that were originally in the table. Is there a line of code I can add or modify to get this working? New Column( "AM or PM", character, Formula( Word( 5, :"...
ERoderz

Discussions |
May 8, 2020 1:12 PM

5442 views | 4 replies

Previous
Next

Latest Discussions

PCA/Factor Analysis with ordinal data

I have a dataset from social sciences that contains many ordinal categorical variables with > 2 levels which are linked to scores like 1 2 3..I was asked if there are correlations between these ordinal variables so question: how to carry out correlation and PCA/Factor Analysis with this kind of data? Thanks for help!
frankderuyck

Discussions |
May 11, 2020 8:52 AM

7833 views | 11 replies
How to perform MANOVA with continuous variables which are not normally distributed (non-parametric)

I am performing an analysis of hemoglobin values at 3 different time points between cases and controls. The data is not normally distributed. How should I go about with MANOVA in such a setting? Also is there an alternative test that I can apply in JMP to see the differences in the cases & controls at these 3-time points.
Uday

Discussions |
May 11, 2020 7:48 AM

2752 views | 4 replies
One Way ANOVA figure for Scientists

I get asked about this one figure a lot. Almost as many times as I've made it. A google search for ANOVA images brings up this figure with hundreds of different data sets. I put together a Blog Post with a Script for how to make the figure. There are a number of subtle variations out there too. So... How do you make this figure? I'm thinking of making launch dialog that includes opti...
Byron_JMP

Discussions |
May 9, 2020 7:32 AM

1927 views | 1 replies
Working with dates

Hi, I have a set of data with information from 2010 to 2020. I'm trying to create a formula column for data before and after 2012 so that that I can compare these 2 sets of data. How do I manipulate the date data? Thanks.
SCWong

Discussions |
May 8, 2020 12:46 PM

4839 views | 4 replies
For Smoother lines, can the volume/density of data be used to adjust the thickness of the Smoother line?

I often use Smoother+Overlay to check how independent categorical variables affect dependent continuous variables in a time trend plot. But one issue I often encounter is when different categories have different volumes of data, the smoother lines are equally as big even if one category has 200 data points and another category has 4 data points. This can create busy plots where it's hard to distin...
markschwab

Discussions |
May 8, 2020 8:27 AM

3961 views | 4 replies

Previous
Next

Latest Discussions

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

4787 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

2261 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

2061 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1688 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1624 views | 0 replies