cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • How to use Column index (instead of Column name) in a formula.

    Hi,I am trying to do this in a for loop:In current table, I have 14 Columns. Column #3~#14 were named as "Step 1" to "Step 12".In the for loop, I want to create Column #15 (named as "Delta Step i" for i = 2, i <=12, i++), which is calculated with formula (Col(4) -Col(2)). Then Column#3 was deleted. The same formula will be reused in the next iteration. Two problems here,1) my formula doesn't work ...

    Zihao Zihao
    Discussions |
    Sep 19, 2018 12:07 PM
    10376 views | 3 replies
  • Help using for loop and conditional to fill in missing values

    Hi all, I am working with a excel data set where multiple rows (batches) are merged for a single workorder and a single yield. Once in JMP, the merge cells split and every row but the yield and scrap column are populated with the correct values for each work order.I need to populate the missing values with the yield value for that work order. I have attached a example data table. I can do this by ...

    acfbt acfbt
    Discussions |
    Sep 19, 2018 10:06 AM
    4880 views | 2 replies
  • How to create isopleths of dissolved oxygen for lake?

    I am trying to create an isopleth of dissolve oxygen for a lake as shown below using JMP. The data I have includes month, depth, and dissolved oxygen.   .  

    ayman ayman
    Discussions |
    Sep 19, 2018 10:05 AM
    10060 views | 6 replies
  • JMP and MongoDB

    Our database team is moving us from a T-SQL framework to a MongoDB framework. Currently much of our team has extensive JMP scripts and tools for automated queries / processing / analysis that rely on JMP's ability to connect/pull through the OBDC drivers.  What does JMP / MongoDB integration look like? Below is a 'sample' of how we interact currently. Is this functionality still avaliable with the...

    JumpingAC JumpingAC
    Discussions |
    Sep 19, 2018 9:33 AM
    4642 views | 2 replies
  • R Init() on Mac

    Hi,I'm trying to test some R (version 3.5) code in JMP (version 14) on my Mac.When I run R Init(); my Mac hangs up. A process called tkrproxy starts up and consumes all of the CPU, and nothing happens. I end up having to force quit the tkrproxy process.What am I doing wrong? Is there some preference or path or something that I need to set in JMP first?Michael

    mjoner mjoner
    Discussions |
    Sep 19, 2018 9:21 AM
    5235 views | 3 replies

Latest Discussions

  • JMP and MongoDB

    Our database team is moving us from a T-SQL framework to a MongoDB framework. Currently much of our team has extensive JMP scripts and tools for automated queries / processing / analysis that rely on JMP's ability to connect/pull through the OBDC drivers.  What does JMP / MongoDB integration look like? Below is a 'sample' of how we interact currently. Is this functionality still avaliable with the...

    JumpingAC JumpingAC
    Discussions |
    Sep 19, 2018 9:33 AM
    4642 views | 2 replies
  • Import JSON Files

    I am trying to import JSON files and the data comes in with the wrong formatting. Attached you will see images of the corrrect and incorrect way that the files import. To get the correct import view I have to save the file as a text file and then re-import the text file. What should I do to fix the import issues Wrong Formatting  Right Formatting      

    dkraeuter_sunne dkraeuter_sunne
    Discussions |
    Sep 19, 2018 7:00 AM
    4579 views | 2 replies
  • Analysis by specific rows

    Hi Everyone! I have a very large dataset that I am in the midst of analyzing but I have come across some difficulties. In the dataset there are 1924 rows and 1061 columns - so it's quite large. I am trying to do Fit Model and just want to make sure that I am doing this right.  If I for example want to fit a model based on rows 112-245, I select these rows, enter "Fit Model" option, select the colu...

    Maxpower1123 Maxpower1123
    Discussions |
    Sep 18, 2018 12:11 AM
    9568 views | 9 replies
  • API Access to AWS Database

    I’m trying to access a database using the new API request feature in JMP ( I’m using 14.1) and I’m having trouble understanding what is required to connect to the database. I’m trying to access amazon cloud ( AWS) at the following location deawdoraisap001.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.comusername is dbarnettpassword is Password_123 ( obviously it isn’t this so it’s just an example) Could...

    d_barnett d_barnett
    Discussions |
    Sep 17, 2018 11:34 AM
    3688 views | 1 replies
  • How to overlap points with the same/ very close values in a graph?

    Hello!A quick question, as the title suggests, how can I overlay points with the same value or close values ( e.g., a difference smaller than 0.1) in a graph?For example, in the following situtation I want to keep only one point for each small range of values, and therefore lose the observed horizontality of points.  Thank you very much in advance.

    Natalia_Castelo Natalia_Castelo
    Discussions |
    Sep 17, 2018 10:59 AM
    3342 views | 2 replies

Latest Discussions

  • Mean separation letter from test slices

    Hello!

    How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...

    jfranc19 jfranc19
    Discussions |
    Sep 14, 2018 2:35 PM
    2327 views | 0 replies
  • repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

    Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...

    Reinaldo Reinaldo
    Discussions |
    Jun 18, 2018 6:31 AM
    3278 views | 0 replies
  • Time Series - Prewhiten

    Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
    What is the Prewhiten Corr, Noise AutoCorr, &...

    nopon649 nopon649
    Discussions |
    Jun 7, 2018 11:10 PM
    2314 views | 0 replies
  • Fit Spline By Group: Save Spline Coefficients to Column?

    Hi all--having an issue.  I am using Fit Y by X to fit 5,000 separate regressions.  I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1.   This fits a spline to all 5,000 graphs with lambda of 0.1.  I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D).  I understand if I just had 1 regression...

    M0gAl0g M0gAl0g
    Discussions |
    Jun 5, 2018 3:19 PM
    2840 views | 0 replies
  • Why does Profiler not stop

    All, 
         I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this.      I am using JMP 13.   

    uday_guntupalli uday_guntupalli
    Discussions |
    Apr 27, 2018 7:12 AM
    1710 views | 0 replies
view all discussions