JMP User Community

Latest Discussions

If row column value equals any values of any array then... What is the general form of this formal?

How do I write an If statement (or whatever the right function is) to evaluated when a row's column value = any value in an array?

Example:If( :ColToCheck == [Any of these values] , then 1, else 0 )
BSwid

Discussions |
Apr 26, 2019 7:02 AM

9686 views | 6 replies
Date Based Equations, Line of Fit, Setting X to mean different units of time

With JMP often we are asked to roll up raw data, group it by week, month, quarter, year, etc. Then go look for a trend. What are the best practices for dealing with longitudinal data? Data TypeModeling TypeFormatMaybe tricks in graph builder?I'm having trouble getting the graphical output to be both executive presentation friendly AND include an equation that makes sense. For example, it's typ...
BSwid

Discussions |
Apr 25, 2019 4:19 PM

4899 views | 1 replies
Scripting Table Sort by User Defined Column

Warning - scripting newbie @ work. I'm working on a script, a part of which sorts the data table by the user selected column (obtained by ColList selection and Eval List). This does not work, it brings up the Sort dialog, which I don't want: dt << Sort( By(_userCol), Order(Ascending), Replace Table); When I hover over _userCol, the assigned column is shown in the scripting window. If I u...
markschahl

Discussions |
Apr 25, 2019 1:18 PM

25526 views | 5 replies
Simultaneously change column width of all selected columns in JMP 14?

Hello all,Our IT recently pushed JMP 14 onto us.In JMP 13, with multiple columns selected, if you adjust the width of one column, all selected columns to the right of the one you adjusted change width to match. This is an extremely useful feature when you have to adjust 30 column widths on multiple files every day!!! In JMP 14, with multiple columns selected, if you adjust the width of one column...
tatarjj

Discussions |
Apr 25, 2019 10:46 AM

8046 views | 3 replies
Creating JMP script for data manipulation

Hi i want to create a JSL for following table title1Title2Title3stack1stack2stack3..............stack(n-1)stacknACE0.55.0100..........2045.65BDF1.521055.35.........2241 for this table i want to create a script which will create a new table with stacked all columns from stack1 to stack n. then in new table add new column at the end which will put numbers 1,2..25 abd repeat same sequence till end o...
Probe_PE

Discussions |
Apr 25, 2019 10:29 AM

3379 views | 4 replies

Previous
Next

Latest Discussions

Creating JMP script for data manipulation

Hi i want to create a JSL for following table title1Title2Title3stack1stack2stack3..............stack(n-1)stacknACE0.55.0100..........2045.65BDF1.521055.35.........2241 for this table i want to create a script which will create a new table with stacked all columns from stack1 to stack n. then in new table add new column at the end which will put numbers 1,2..25 abd repeat same sequence till end o...
Probe_PE

Discussions |
Apr 25, 2019 10:29 AM

3379 views | 4 replies
Nested effect

I have data for two species and two types of leaves. Species A and B, type R and L. I would like to check how species and type of leaves affects for example leaf area. However I have results of area measurements for several leaves assigned to each individual. Because of that I used nest function: Model effects:SpeciesTypeSpecies*typeLeaf number [Individual]But I receive “The model is missing an ef...
Kronika

Discussions |
Apr 24, 2019 6:21 AM

7439 views | 2 replies
JRP with embedded JMP table/file missing the report

HelloI was doing some K means and saved the clusters to my table and saved the cluster out as JRP file and chose the option to embed the table with the report and saved it. When I open the jrp, only the MP file associated is showing up, I do not see the actual JRP with the cluster out summaries.Is there any effective way to save reports with the tables? This seems to be occuring very frequently. N...
theseventhhill

Discussions |
Apr 24, 2019 12:54 AM

3612 views | 1 replies
Constrained least squares and exponential fitting

I am looking to fit Y ~ 1-exp{-[C1*(x/Xmax)^1+.......CN*(x/Xmax)^N]}. The order could be anywhere between 6 to 12 (max value of N). But before generating the fit, I need to estimate the coefficient using modified LSQ. I looked at the exponential fit (analyze fit Y-->X) and tried to enter a formulae but I do not want to directly fit the exponential curve, rather I want to estimate the best fit coef...
theseventhhill

Discussions |
Apr 21, 2019 4:45 AM

4602 views | 3 replies
Graph Builder Mean Line

I have a "points" plot in graph builder. I would like to add a mean line to the plot automatically, like one can do in Fit Y by X by selecting Fit Mean. I want it to happen automatically because I have a local data filter that I want to use to filter my data and each time I do so, I want the mean line to update with the mean of the filtered data. Basically, I would like the Mean Line to behave the...
JShef

Discussions |
Apr 18, 2019 1:01 PM

4872 views | 1 replies

Previous
Next

Latest Discussions

Chi square or Cochran's Q test

Okay, so i have to decide whether i should use chi-square or Cochran's Q test for one of my study.If i assume meat as experimental unit (EU) and impose 6 different wood smoke (like apple smoke, cedar smoke, hickory smoke etc.) on EU and consumers (people) act as observational unit (OU). I have 10 consumers and each one will taste each treatment (6 treatments) and respond liking (9 point scale), an...
sharmachetan

Discussions |
Apr 16, 2019 3:54 PM

2842 views | 0 replies
Selecting Number of Clusters in Hierarchical Clustering

One way to select possible number of clusters in hierarchical methods is to identify the relatively large changes in distance as number of clusters change (see table below). When I look at the actual distance measure from the table (clustering history below dendogram), there is a bigger jump from 3 clusters to 4 than from 4 to 5 (smaller), suggesting 4 may be the right decision. However, when you ...
pratyushdash

Discussions |
Feb 23, 2019 5:51 PM

2887 views | 0 replies
Beta Generalized Regression and adjusted chi-square values

I have a data set from a two-choice rodent feeding trial. We were testing the effectiveness of 10 deterrents by coating them on seeds and offering them to rodents alongside control seeds that were uncoated. The explanatory variable is which of the 10 deterrents the treatment seed was coated with, and the response variable is the proportion of control seed and treatment seed consumed. The question...
Mananahi

Discussions |
Feb 13, 2019 9:58 AM

2228 views | 0 replies
DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

3884 views | 0 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3245 views | 0 replies