JMP User Community

Latest Discussions

Excluding Rows based on Row Character in a Column Formula

Hello Everyone I would like to calculate the column standard deviation ,but I would like to exclude a certain rows depending another row value. For example, in Excel, my formula in excel will be as follows, i.e the formula for each cell will calculate the standard deviation for other than the row :Columns value. e.g this is standard deviation formula when Columns == B is excluded e.g this is s...
Ashraff09

Discussions |
May 11, 2020 8:40 PM

1925 views | 2 replies
How to run Monte Carlo for variation in Factors - Simulation Experiment/Stochastic Optimization

Hello,I am trying to understand how to utilize the "Simulation Experiment" under the Simulator red triangle to assess how my response is affected by random variation/distribution in my X factors, but am not sure how to interpret the results. It generates a separate "Gaussian Process Model of Log10 Defect Rate": Below are my X factors in a fixed state currently: I have a few questions:1. Does the...
zjuv007

Discussions |
May 11, 2020 5:02 PM

4230 views | 8 replies
How to create database connection reference to a SQL server?

Hello Everybody,
I have an issue with creation of variable (or reference) after connecting to a database. I wanted to create variable conn that I could use later to run different queries. At the beginning, however, I needed to create 2 connections since I needed data from different databases, but on the same SQL server (the same user name and password are required). For both connections I need to p...
lukasz

Discussions |
May 11, 2020 1:00 PM

3418 views | 2 replies
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

1568 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

5467 views | 11 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

5467 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

1768 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

1434 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

3403 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

2732 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

3583 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

1629 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

1486 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

1325 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

1287 views | 0 replies