Welcome to the JMP User Community!

Latest Discussions

• 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

  Discussions |

  Sep 27, 2021 2:49 AM

  48849 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

  Discussions |

  Sep 27, 2021 1:56 AM

  1409 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

  Discussions |

  Sep 26, 2021 11:47 PM

  2688 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

  Discussions |

  Sep 26, 2021 9:58 PM

  2375 views | 2 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

  Discussions |

  Sep 26, 2021 7:38 PM

  1573 views | 2 replies