JMP User Community

Latest Discussions

Table Update with get rows

Hi, I have two tables with > 50k rows and 5 -10 columns and I want to update the first table (dt1) with values from the second table (dt2). I dont want to use loops because it could take a lot of time with rows > 50k. The JSL "update" function works well but I need also the matched rows in dt2 for further use.To show what I mean I used the "update" example from "script index" and add the name MIKE...
TWE

Discussions |
Apr 7, 2020 1:57 AM

3538 views | 4 replies
Counting elements in list (within a cell)

I am working with results from a Google form. The spreadsheet has elements within the cell.user, answer, ...John Doe, "A,B,C,F,G",...Jane Doe, "B,D", ...Richard Roe, "B,G", ... Is there an easy way to count these elements, so a bar plot will show the following ? A: _] 1 B:___] 3C:_] 1D:_] 1E:_] 1F:_] 1G:__] 2
FN

Discussions |
Apr 6, 2020 9:23 AM

3631 views | 4 replies
Comparisons of several groups within categories

I have data from 260 individuals. In 1 row the persons are ceategorized into male or female. Within each gender, there is another coloums categorizing individuals into children, adolescents, adults, elderly.And then there are coloums With measured parameters, e.g food intake, intake of energy etc. How do I compare the measured parameters between age categories from each gender?
Gunnar

Discussions |
Apr 6, 2020 7:19 AM

6354 views | 8 replies
Fit Y by X - plot centered by block

Hi, I am analyzing the data of a sensory test, in which participants had to indicate how acceptable they deem a sample for consumption. In this data, the acceptability scores they can give range from 1 to 9. In total 8 samples need to be evaluated. I have 50 different consumers who each evaluated the 8 samples. So I have 400 scores in total, and I want to take the variability between consumers int...
cc_

Discussions |
Apr 6, 2020 6:54 AM

6197 views | 3 replies
Graph Builder Horizontal Duration Line

Hi, I need some help to visualize horizontal duration lines in graph builder.Therefore, I have three columns with data: Column A: product typeColumn B: duration cummulatedColumn C: duration per product type I want to illustrate on the x-axis the duration cummulatedOn th y-axis, the different product types shall be illustrated. The graph shall show the start and the end point for producing a specif...
Konstantinos

Discussions |
Apr 6, 2020 3:50 AM

4580 views | 3 replies

Previous
Next

Latest Discussions

Continuous Variables Nested within a Categorical Variable?

Hello, I am new to JMP and am not sure how to model my data so any suggestions on the steps I should take would be much appreciated!! I apologize in advance for my very limited knowledge of statistics.I have a data set with a categorical variable (donor) and two parameters unique to each donor that are continuous (age and BMI). I would like to see how different response variables (also continuous ...
angie_newbie

Discussions |
Apr 5, 2020 3:24 PM

6513 views | 9 replies
Is it possible to create an overlay plot representing confidence intervals?

I have lower bound and upper bound of the confidence interval for each estimate already available in my data, I just want to draw it using JMP. All the blogs I have found are regarding generating and drawing confidence intervals with JMP. Any help would be very welcome, thank you very much.
myriam_alexande

Discussions |
Apr 4, 2020 12:14 PM

11786 views | 7 replies
How to do Weighted Least Squares for simple regression

Hi, I'm new to JMP and I need some advice on how to run a WLS for a simple regression.Other discussions say that I use Analyze > Fit Y by X > select another numerical column with the appropriate weights and click "Weight".But what exactly do I put in the weight tab? Do I put the saved residuals or the x variable itself? Sorry if this question is very elementary -- I'm having hard time navigating t...
Soniayoung

Discussions |
Apr 4, 2020 3:35 AM

3502 views | 1 replies
Replacing missing data by regressed values

HiI have a time series for which the variable has missing values. I would like to replace the missing values by a linear model derived from the closest available values in time.What would be the best way?And if the script could do that to all the columns of my table (except the time), that would be even better ThanksExampleWhat I havetOutput0101.2.43010.2010What I want:tOutput0101152204301022.5201...
guilhem

Discussions |
Apr 3, 2020 8:26 PM

17256 views | 22 replies
Graph Builder: How do I only display categories with values for each group x

here's what i've got:clearly i don't want to display all treatments for each experiment. D and E were not in experiment 1 and A-C were not in experiment 2. how do i display only treatments with values?-->treatmentexperimentvalueA10.97A10.39A10.49A10.44A10.38B10.73B10.72B11.02B10.07B10.09C10.23C10.2C10.1C10.22C10.07D20.29D20.18D20.13D20.57D20.86E20.68E20.34E20.46E20.71E20.5 help?
jac865

Discussions |
Apr 2, 2020 7:12 PM

2171 views | 1 replies

Previous
Next

Latest Discussions

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

2020 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

1667 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

1604 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1681 views | 0 replies