JMP User Community

Latest Discussions

Combining 2 Datasets by Matching 2 Variable Columns

I need to combine 2 large (15k rows) JMP datasets by matching up 2 variables (product_ID and week_ID). In other words, there is a unique record for each product_ID/week_ID combination. Each file contains different attribute columns. I'm just getting started with JSL so looking for script to get me started on this one task, otherwise I plan on pre-processing using VLOOKUP in excel. Thank you! data...
Brynn

Discussions |
Mar 20, 2018 5:59 AM

5868 views | 2 replies
Connecting to SQLite DB

Hi Everyone, I'm trying to use JMP to connect to a SQLite db and I'm running into a very funny problem where the text fields in the first few rows of data get mangled, while everything else looks fine.I'm using JMP 11.2.1 for Mac, running Mac 10.11.6, and I'm using the ODBC available here: SQLite ODBC DriverI've created a very simple database (attached) to test this issue. When I open JMP, and go...
michaelaschmidt

Discussions |
Mar 19, 2018 6:48 PM

21792 views | 8 replies
Add Spec Limits to Tabulated Column

Hello, I am trying to add spec limits to a new column that I created via Tabulate, but cannot get JMP to recognize the column in which I want to add spec limits to. Here is the portion of the code I am working on. tab = dt << Tabulate(
Show Control Panel( 0 ),
Add Table( Column Table( Analysis Columns( :Data ), Statistics( Mean ) ), Row Table( Grouping Columns( :Pitch # ) ) ),
invisible,

);
dt_tab = ta...
xdcurryx

Discussions |
Mar 19, 2018 2:49 PM

4872 views | 2 replies
Map Shape role in Graph Builder - Only 1 point is shown in each state

I created a graph using latitude (Y axis) and longitude (X axis). I used STATE column for Map Shape. I now see an outline of the united states, but the problem I have is it does not show more than one city in each state. It will not show a point for Flagstaff and Phoenix....only one dot for Phoenix. any suggestions to show more than one city in a state? thanks
robbob

Discussions |
Mar 19, 2018 1:48 PM

15475 views | 8 replies
How is are Scaled Estimates Calculated ?

I am a new JMP Pro User with the following query. Using the Fit Model Standard Least Squares platform, I have 67 columns of continuous data. Each column has 213 rows. The 67 columns are entered as Y. Construct model effects adds another column containing five groups, each categorical. I am using this platform instead regular ANOVA to test interactions and other interactive effects. I find the scal...
rexneal

Discussions |
Mar 19, 2018 12:51 PM

11825 views | 5 replies

Previous
Next

Latest Discussions

How is are Scaled Estimates Calculated ?

I am a new JMP Pro User with the following query. Using the Fit Model Standard Least Squares platform, I have 67 columns of continuous data. Each column has 213 rows. The 67 columns are entered as Y. Construct model effects adds another column containing five groups, each categorical. I am using this platform instead regular ANOVA to test interactions and other interactive effects. I find the scal...
rexneal

Discussions |
Mar 19, 2018 12:51 PM

11825 views | 5 replies
Issue running JSL files in C#.NET

I am trying to execute JSL files in a C#.NET wrapper. I am able to sucessfully run the files but my code does not wait for the script to finish. Below is a sample:JMP.Application jmpInstance = new JMP.Application();FileInfo fJSLFile = new FileInfo(@"C:\Test\Test.JSL");jmpInstance.RunJSLFile(fJSLFile.ToString()); if (jmpInstance.HasRunCommandErrorString()){ throw new Appl...
gpuckett

Discussions |
Mar 19, 2018 7:18 AM

5503 views | 4 replies
Kruskal Wallis + post-hoc testing?

Ok I am VERY green at this whole JMP thing, and I have come to a roadblock. About a month ago, I ran some tests on data collected and I was able to work it all out perfectly but now I am unable to replicate what I did, so I'm hoping someone can help me! I have three columns of data: BMI Category (ordinal), year (ordinal), and number of patients (continuous). The data I would like to run is a compa...
KTrotta89

Discussions |
Mar 17, 2018 6:30 AM

10398 views | 4 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

4009 views | 0 replies
Testing - Sample sizes for a full factorial

Hi,I’d really like some help with sample sizes for a full factorial design for a Marketing campaign I’m involved in - looking at response rate. I want to test 4 things, all have 2 levels, cannot be changed and are categorical. If I were to conduct 4 separate A/B tests the cell volumes would look like this: Control response rate = 0.6% SuccessalphaPowerSidesVolume/cellTotal volume Test 1 (A/...
Liz_Perkin

Discussions |
Mar 16, 2018 1:23 AM

10604 views | 4 replies

Previous
Next

Latest Discussions

P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

4009 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2811 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2416 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3761 views | 0 replies
.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

2481 views | 0 replies