JMP User Community

Latest Discussions

Renaming and/or saving data tables

I create a data table through tabulate and need to do further reports on that data table but each time it gives a name to data table "untitled XXX" (in this case untitled 14) . And since I need to automate the reporting and need to do it several times a day I need a "fixed name" for that data table (and further save or not). How will I do it?Thanks for your help(Data Table( "AgencyStayISL.jmp" ) ...
saitcopuroglu

Discussions |
Mar 4, 2019 3:19 AM

11810 views | 2 replies
Set Column Names to UpperCase

I am trying to set all the Column Names to uppercase. I have tried the below but it just changes the list to uppercase not the columns. col_name_list = dt3 << get column names(string); for (i = 1, i <= nitems(col_name_list), i++, col_name_list[i] = uppercase(col_name_list[i]); What do I need to do to change all of my column names to uppercase?
wjalford

Discussions |
Mar 3, 2019 6:35 AM

6653 views | 2 replies
Measure distance between all points

I am trying to determine a meausre of how distance from a point effects measurements to find a minimum / maximum point within range of points. I tried to do this in the attached files but I cannot find a way to do this programatically. I tried to do this by concatenating a table of N rows, N times, copying the XY coulmn, sorting Y then X then pastingn this sorted column into the NxN table. I tri...
JumpingAC

Discussions |
Mar 1, 2019 12:58 PM

3705 views | 1 replies
Response surface VS Mixture response surface

Hello Gentlemen, I am writing because I am a little confused about the options that there are in JMP. I am trying to evaluate a DOE and the construction of the model Effect there are several option like response surface which is by default but I did a comparison with Minitab and I found different results between both softwares but I think the Minitab result is the good one because it is more acc...
Archy

Discussions |
Mar 1, 2019 8:48 AM

29742 views | 21 replies
set default directory

In the script I am writing, I ask the user for a file to import (an Excel file).I then create a folder at the same level as the imported file to store all the analysis in on spot.The script basically doesif(directory exists(saveDirectory), , create directory(saveDirectory));set default directory(saveDirectory);
The rest of the script saves png files as analysis results. (Please make the PowerPoi...
Hegedus

Discussions |
Mar 1, 2019 8:16 AM

12671 views | 5 replies

Previous
Next

Latest Discussions

Measure distance between all points

I am trying to determine a meausre of how distance from a point effects measurements to find a minimum / maximum point within range of points. I tried to do this in the attached files but I cannot find a way to do this programatically. I tried to do this by concatenating a table of N rows, N times, copying the XY coulmn, sorting Y then X then pastingn this sorted column into the NxN table. I tri...
JumpingAC

Discussions |
Mar 1, 2019 12:58 PM

3705 views | 1 replies
Response surface VS Mixture response surface

Hello Gentlemen, I am writing because I am a little confused about the options that there are in JMP. I am trying to evaluate a DOE and the construction of the model Effect there are several option like response surface which is by default but I did a comparison with Minitab and I found different results between both softwares but I think the Minitab result is the good one because it is more acc...
Archy

Discussions |
Mar 1, 2019 8:48 AM

29742 views | 21 replies
How to get Odds Ratio in Ordinal Logistic Regression?

How can I calculate in JMP the odds ratio in an ordinal logistic regression with one independent, continuous variable [0-1], and one ordinal dependent variable [1,2,3,4,5]? See the example in the screenshot, where it is unclear to me where I can find the odds ratio.
MaxMueller

Discussions |
Feb 28, 2019 2:45 AM

5243 views | 1 replies
Table>Summary>Custom formula?

My apologies if this question is too trivial. I have a table as shown below. In JMP, under 'Tables'>'Summary' I can apply any summary statistic that I would like; however, I would like to apply a custom formula(1/LOG( SUM(group)/COUNT(group) )) stratified by Name and Group The tableNameWeekStipendA110A111A112A250A251A252B3101B3102B3103B4501B4502B4503C11C12C13 Will be summarized asNameWeekSummary...
rs

Discussions |
Feb 26, 2019 6:15 PM

3605 views | 1 replies
JSL file runs when open instead of opening in editor

Hi, I recently ran into the opposite problem: When I click a jsl-file in a folder, JMP immediately start ot execute it. I note that there is mentioned in this string the special effect of //! in the beginning of the script. This should force the script to execute, as the more obvious 'On Open' command. Do you know of any more obscure controllng characters that will affect the behavior of JMP whe...
poulravn

Discussions |
Feb 25, 2019 4:29 PM

7398 views | 6 replies

Previous
Next

Latest Discussions

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

3091 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

2379 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

4100 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

3417 views | 0 replies
I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2557 views | 0 replies