cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Import (open) data from excel

    Hi,I'm trying to import data from excel by using the open functionMy code is as follows:Open("C:\Users\"username"\Documents\Statistics\Test.xlsx");I use my username instead of "username"I don't get any error messages, but nothing happens when I run the script.Why does it not open?Thanks

    sirihofstadtrap sirihofstadtrap
    Discussions |
    May 10, 2018 10:45 AM
    15345 views | 5 replies

  • Compare lists, but partial strings

    I have one list containing column names, like Final Name 1, Final Value 2 etc. and another list that has names like Name,Value, etc. How can I use pattern matching make matches like: Name == Final Name 1 for all columns? I want to extract its row values if the column matches the values in the list. Thank you.

    powerpuff powerpuff
    Discussions |
    May 10, 2018 9:47 AM
    12062 views | 8 replies

  • Update Data Tables

    I' m running a script taking data from a shared MS Excel database. I run script to import data into JMP, and open graph builder to look at required data.I find out some data has been left out of the database, meaning visualisation doesn't work properly, so have to go back and add it.I then have to manually close graph builder and all the windows [Window > Close All Data Tables], then start the scr...

    LZF LZF
    Discussions |
    May 10, 2018 5:48 AM
    4533 views | 2 replies

  • Change thickness of box plots on variability chart

    Hi all, I am creating a  variability chart in jmp. The box plot lines look too thin and vanishes amongst markers.Is there an option to change all the box plot line width at once for the entire figure?I know I can individually change each box plot by right-clicking each of them separately, but this process becomes tedious for multiple box plots. Can I use that in form of jsl code? Thanks a lot !  

    rahulsmils rahulsmils
    Discussions |
    May 9, 2018 4:40 PM
    6146 views | 1 replies

  • Using a user-defined equation to create a distance matrix

    Hello,  I am trying to create a distance matrix of similarity/dissimilarity values for community data.  I would like to use a specific equation (Bray-Curtis) to construct the matrix of values; values will show similarity in multiple species abundances between multiple plots.  I am aware of the method to create a distance matrix in JMP using hierarchial clustering, but do not know how to perform a ...

    hjh hjh
    Discussions |
    May 9, 2018 3:20 PM
    4099 views | 1 replies

Latest Discussions

  • Using a user-defined equation to create a distance matrix

    Hello,  I am trying to create a distance matrix of similarity/dissimilarity values for community data.  I would like to use a specific equation (Bray-Curtis) to construct the matrix of values; values will show similarity in multiple species abundances between multiple plots.  I am aware of the method to create a distance matrix in JMP using hierarchial clustering, but do not know how to perform a ...

    hjh hjh
    Discussions |
    May 9, 2018 3:20 PM
    4099 views | 1 replies

  • Concatenate to Summary Table

    I have a joined table that combines two summary tables. I want to plot the results of one column against the other. These columns are calculated from values in their respective parent tables and are locked. However, I also want to plot a reference trendline (1:1) on this plot. To do this I would like to add four rows with numeric values in the two columns I'm plotting and create a new column that ...

    KApple KApple
    Discussions |
    May 9, 2018 3:36 AM
    2789 views | 1 replies

  • How to create APA-format tables and plots from JMP data?

    Hi JMP users, I would like to know if there is an easy way to create/export tables and plots from JMP data to APA*-format. Thank you! * APA: American Psychological Association

    Reinaldo Reinaldo
    Discussions |
    May 4, 2018 7:03 AM
    4018 views | 2 replies

  • Issues with local data filter and select where

    I am trying to make a Class object that contains methods and properties I find usefull when working with distribution reports. I have everything working how I would like it when I don't try and filter the report or data table but when I try and fitler the report I start having issues. Main issue being is after I filter the report when I go into the display tree to pull and save values they don't r...

    awsmagala awsmagala
    Discussions |
    May 4, 2018 3:30 AM
    3971 views | 3 replies

  • get current work week in string

    Hi I need to pull the date from a constant changing folder name, the name is the year+curent WW e.g. 201817I have the following JSL  if ((day of week(today()))==1, WW = "^year(today())^^week of year(today())-1^", WW = "^year(today())^^week of year(today())^" );

    Eval Insert Into( WW );

    dt = Open("\\.......\Reports\"||WW||"\.......xlsx");
    it works when I run it on my PC but when I schedule it on a serv...

    AdamChoen AdamChoen
    Discussions |
    May 4, 2018 1:53 AM
    2584 views | 2 replies

Latest Discussions

  • 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
    1556 views | 0 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 aryasohrabi
    Discussions |
    Mar 17, 2018 2:22 AM
    3543 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 Picard
    Discussions |
    Mar 15, 2018 1:57 PM
    2379 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 DG
    Discussions |
    Mar 11, 2018 6:27 AM
    2004 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 helga55
    Discussions |
    Mar 9, 2018 2:20 PM
    3247 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

JMP® Marketplace Feature: S3 Data Connector

 view all blog articles

Learn more about JMP's premier analytics conference