JMP User Community

Latest Discussions

Text to Columns result columns

I'm using the built-in JSL Text to Columns() function. I won't know how many "segments" my input text has, so I won't know in advance how many new columns will result from calling the function. But I need to know this so I can do certain subsequent steps in my script. Back when this was an add-in, Jeff Perkinson's v3 returned a result that gave the names of the columns that had been created; the v...
john_madden

Discussions |
May 30, 2019 12:14 PM

8330 views | 3 replies
Text time to numeric time

I am having an issue converting a text time format to a numeric time format. Data should be of the format MM:SS.0 (This is the format it was in excel). After the import into JMP I have a long string (i.e. 2.1713e-5) that I seem to be unable to do anything with. This time value represents a time duration that needs to be in the format of MM:SS.0 I have tried a few solutions but nothing quite seem...
Sciguy_1

Discussions |
May 30, 2019 9:08 AM

5964 views | 5 replies
Applying kernel smoothing to large datasets

I frequently work with time series data acquired simultaneously from multiple sensors. For example, 100 sensors may make measurements once per hour for several months. The sensors sometimes report erroneous values and sometimes fail to report. I want to remove the outliers from the dataset and impute the missing values in order to extract values from specific points in time for further post-proces...
wgardnerQS

Discussions |
May 30, 2019 4:12 AM

6711 views | 6 replies
F (distribution) Inverse functinality

Hi,i am trying to find out the F inverse value. I am having input like probability values and degrees of freedom. Can any help me in finding out this functionality. I have tried using F density function but not sure weather my results are correct or not. Dilip
dilipkumar

Discussions |
May 30, 2019 3:26 AM

3042 views | 1 replies
How to combine two columns (with missing data)?

got a table with missing data like this:Column1Column21••5•73• Need to combine it it to one column Column31573 I used sum but it didn't work. The only way I can do is using If and is Missing() formual. Any fast way to combine it? Thanks!
jasongao

Discussions |
May 29, 2019 9:53 PM

2218 views | 1 replies

Previous
Next

Latest Discussions

How to combine two columns (with missing data)?

got a table with missing data like this:Column1Column21••5•73• Need to combine it it to one column Column31573 I used sum but it didn't work. The only way I can do is using If and is Missing() formual. Any fast way to combine it? Thanks!
jasongao

Discussions |
May 29, 2019 9:53 PM

2218 views | 1 replies
Help understanding how Lift curves are calculated

Dear JMPers, (computer details: I have JMP Pro 14 on a W7 Enterprise, 64-bit computer.) I am trying to better understand how JMP actually calculates a Lift curve. I understand conceptually the ROC and Lift curves, but I'm having a hard time calculating a Lift curve myself. The JMP help/support page (https://www.jmp.com/support/help/14-2/lift-curve.shtml#1276958) isn't all that helpful in under...
SDF1

Discussions |
May 29, 2019 11:10 AM

1945 views | 0 replies
How to calculate moving average of column with more than 10000 million entries in JMP 11?

I am trying to run the below formula on a column with 100 million rows to calculate the moving average.Could you please suggest an JMP11 alternative for Col Moving Average Col Moving Average( :x, 1, 9999999, 0 ) is not supported by JMP11. Please find below the code I have tried: NamesDefaultToHere(1); // Use a function to open a .CSV file: Given the path to such a file, returns a reference to t...
jojmp

Discussions |
May 29, 2019 3:48 AM

3592 views | 5 replies
Likert scale in correlation analysis

Hi all. I am working on my master thesis and are struggling with my correlation analysis.My plan for the statistics from my survey are:Item analysisPCA and factor analysisCorrelation analysisMultiple regressionCluster analysis. In my assumptions in correlation analysis I have problems with the fitting of the likert scale data to find linearity among other things. Is it better to use the factor sco...
MScMasterStuden

Discussions |
May 29, 2019 1:14 AM

2941 views | 2 replies
Move column to first using JSL script

Hi JMP community I seem to have a simple question.I want to move a specific column to the first position using JSL script. I started withselecting it:"That's my column" << set selected (1) ; /*seemed OK*/ However, ...move selected column ( (:"That's my column"), to first) ;...just doesn't work. Could you help me solve this one?Thanks a lot!
Newbie2Jumpie

Discussions |
May 28, 2019 8:51 AM

7165 views | 2 replies

Previous
Next

Latest Discussions

Help understanding how Lift curves are calculated

Dear JMPers, (computer details: I have JMP Pro 14 on a W7 Enterprise, 64-bit computer.) I am trying to better understand how JMP actually calculates a Lift curve. I understand conceptually the ROC and Lift curves, but I'm having a hard time calculating a Lift curve myself. The JMP help/support page (https://www.jmp.com/support/help/14-2/lift-curve.shtml#1276958) isn't all that helpful in under...
SDF1

Discussions |
May 29, 2019 11:10 AM

1945 views | 0 replies
How to analyze PSM data(Propensity Score Matching) in JMP？

How to analyze PSM data(Propensity Score Matching) in JMP？If it is yes, please tell me what detail steps in JMP manu,If there is any available examples in JMP sample data?
mujahida

Discussions |
May 7, 2019 9:30 PM

2209 views | 0 replies
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

2837 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

2883 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

2227 views | 0 replies