cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.

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

  • Ordinal logistic regression

    Hi EveryoneI am very new to JMP. I have data on the scale of 0-4 on leaf damage scale on 15 eggplants taken every 48 hrs for 3 times on each plant. How can I represent dataset on the jmp .. or show data set for ordinal logistic regression?  Anyone can post data set table as an sample. Thank you 

    Sami Sami
    Discussions |
    Sep 27, 2021 3:56 AM
    1378 views | 1 replies
  • How JMP calculates confidence interval for a linear fit model

    For the following set of data,    XY7.91151315410.815611.618210.512411.11578.812911.918111.116491227.41006.986.29.4118.97.294.28.8114.37.1104.912.4181.512.1166.115.1166.114.2157.7   one can generate a linear fit model  as shown below:   Linear Fit
    Y = 24.522739 + 11.068566*X
    Summary of Fit
    RSquare 0.743712
    RSquare Adj 0.729474
    Root Mean Square Error 16.17783
    Mean of Response 138.695
    Observations (or Su...

    ILoveJMP ILoveJMP
    Discussions |
    Sep 27, 2021 2:49 AM
    48781 views | 17 replies
  • Copying Row values to other Column

    Hello, Kindly help me I'm stuck when putting a formula into other column.Here is expected output if SerialNumber is not empty copy row to Column ChipID else copy the same SN.dtraw << New Column("ChipID", Character, Formula( For( i = 1, i <= N Rows(dtraw), i++, If( Is Missing( :SerialNumber), :ChipID[i] = (:SerialNumber[1] & i = 1), :SerialNumber ) ) ); 

    JeffO JeffO
    Discussions |
    Sep 27, 2021 1:56 AM
    1400 views | 2 replies
  • JSL how to reference a table in graph builder

    Hallo all,   I use a JSL script to generate two tables dt1 and dt1 from an SQL server and then I want graph builder to plot two columns from the first data table I generated. Example below:     dt1 = Open Database( "BLA", " SELECT col1, col2 FROM BLA", "data table 1" ); dt2 = Open Database( "BLA", " SELECT col1, col2 FROM BLA", "data table 2" ); Graph Builder( Variables( X( :col1 ), Y( :Tcol...

    valeria valeria
    Discussions |
    Sep 26, 2021 11:47 PM
    2677 views | 3 replies
  • Determine Week of Year and Day of Week Based on Year, Date and Time

    Hello all, My company uses a fiscal calendar where one year has only 52 work week(WW). The weeks start on Saturdays, time 19:00  (hh:mm). The day of week (DOW) is determined based on the time 19:00. I am trying to determine it by using Week Of Year() and Date of Week() functions but I do not get the desired outcome. Has anyone created JSL script to determine the week of year and date of week based...

    bzanos bzanos
    Discussions |
    Sep 26, 2021 9:58 PM
    2359 views | 2 replies

Latest Discussions

  • Ordinal logistic regression

    Hi EveryoneI am very new to JMP. I have data on the scale of 0-4 on leaf damage scale on 15 eggplants taken every 48 hrs for 3 times on each plant. How can I represent dataset on the jmp .. or show data set for ordinal logistic regression?  Anyone can post data set table as an sample. Thank you 

    Sami Sami
    Discussions |
    Sep 27, 2021 3:56 AM
    1378 views | 1 replies
  • Saving Multiple Data Tables to an Excel Workbook

    Hi -
    I have a jsl script made with Jmp 12 that processes huge data table and generates 9 data tables with different summaries.

    I am saving these off currently as 9 csv files. I would like to condense it to ONE Excel workbook with 9 tabs.

    I understand saving each data table to excel (xlsx) is an option. How can I have 9 sheets saved to one excel via Jmp 12?

    Appreciate any inputs/pointers. Thanks!

    uProf uProf
    Discussions |
    Sep 26, 2021 7:38 PM
    1555 views | 2 replies
  • break a single column into multiple based on empty row or specific character

    Hi,can someone provide advice?I have a column with structure below:
    123 abcdef xxyyzz

    is it possible to divide to multiple columns based on empty row (or a repeated same character) 1 a xx2 b yy3 c zz   d   e   f

    dadawasozo dadawasozo
    Discussions |
    Sep 25, 2021 8:08 AM
    935 views | 2 replies
  • How to estimate sample size to meet specificity and sensitivity requirements

    Hi, I'm trying to calculate the sample size required for my test to meet the sensitivity and specificity requirements.I have a binary test that detects the presence of bacteria in water, if it's positive bacteria is present, if it's negative it is not present.I would like my test to have92% sensitivity (with 95% CI of 90-94%)and 90% specificity (with 95% CI of 88-92%)and I want the power to be 0.8...

    Agustin Agustin
    Discussions |
    Sep 24, 2021 9:22 AM
    2463 views | 3 replies
  • How to calculate adjusted variable data ?

    Hello, this may be a simple question.I am trying to analyze e relationship between Adjusted Variable and Variable of Interest. I want to calculate adjusted variable data by age and sex.  What JMP function should I use?  

    KF2 KF2
    Discussions |
    Sep 23, 2021 10:40 AM
    1271 views | 2 replies

Latest Discussions

  • Skip Lot Sampling Plan

    Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam

    AT AT
    Discussions |
    Sep 10, 2021 10:38 AM
    946 views | 0 replies
  • Time values in xls or xlsx, csv, and JMP

    Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...

    fliew0410 fliew0410
    Discussions |
    Sep 7, 2021 7:25 AM
    946 views | 0 replies
  • Error while using Azure MFA to connect with JMP

    I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14.  [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.

    hariharan249 hariharan249
    Discussions |
    Sep 3, 2021 7:14 AM
    660 views | 0 replies
  • Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

    Hi everyone,  I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along.  I f...

    caseylott caseylott
    Discussions |
    Aug 17, 2021 11:15 AM
    1217 views | 0 replies
  • Projects Window List in JMP 15 for Mac -- Reorder?

    I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses.  There is a flow to the findings which I'd like to order in that Window List.  Is this possible? I can't click and drag an entry for a window up or d...

    datanaut datanaut
    Discussions |
    Aug 16, 2021 6:38 AM
    611 views | 0 replies
view all discussions