JMP User Community

Latest Discussions

Identifying Titles of Graph Builder Page Titles

In the following graph, I want to be able to identify the page titles: i.e. "sex = F" and "sex = M". Looking at the display tree it would appear that the titles are associated with a display box of type GraphBuilderGroupBox: I have the following script: Open("$SAMPLE_DATA/Big Class.jmp"); gb = Graph Builder( Size( 378, 714 ), Show Control Panel( 0 ), Show Legend( 0 ), Variables( X( :hei...
David_Burnham

Discussions |
Oct 16, 2021 5:13 AM

2948 views | 5 replies
A time series (seasonal ARIMA) model for varying variability in different seasons

Is there a time series ARIMA model that can represents increased variation (expand confidence intervals) in values during one season? As an example, attached is a data set showing the number of deaths in the United States. A time series analysis of deaths prior to March of 2020 (settings below) gives a reasonable prediction of deaths, however its accuracy is reduced during Dec - Feb (flu season...
ih

Discussions |
Oct 15, 2021 6:13 PM

2319 views | 4 replies
Preserving JMP Data Table Hyperlinks when Tables are Saved in Excel Format

At the risk of blasphemy, I am trying to figure out how to save a table that has hyperlinks for all data in a column in an Excel file, where the hyperlinks are still functional. I pull a lot of Excel data into JMP for faster data analysis and can add hyperlinks to entries in JMP columns. I can save the resulting charts as picture files and raw data files that can be read in Excel, but would also l...
JensRiege

Discussions |
Oct 15, 2021 3:39 PM

746 views | 0 replies
JSL - Calculate Mean of Last 3 Rows Per Date

I have a data set where I'd like to calculate the mean of the last 3 observations for each date and have that value be in its own column and paired with the last date as shown below. Names Default To Here( 1 ); // Create an example data table dt = New Table( "Date", Add Rows( 30 ), New Column( "Date", Numeric, "Continuous", Format( "m/d/y", 10 ), Set Values( [3713817600, 3713817600, 371...
terapin

Discussions |
Oct 15, 2021 9:36 AM

2451 views | 4 replies
Index Linest Formula of Excel In JMP possible?

Hi All, I would like to know that possible to create the Index + Linest formula using JMP formula? Example of data table:TempMotor TempExchaust Temp135.635.2235.934.8334.934.2 With the index + Linest formula, i would like to get coef1,coef2 and coef3 results as attached in the excel file example. Final result as shown in Result column (-2.7619,196.1429 and -3447.1581). ResultExcel FormulaCoef1-...
dexue

Discussions |
Oct 15, 2021 8:31 AM

1593 views | 2 replies

Previous
Next

Latest Discussions

A time series (seasonal ARIMA) model for varying variability in different seasons

Is there a time series ARIMA model that can represents increased variation (expand confidence intervals) in values during one season? As an example, attached is a data set showing the number of deaths in the United States. A time series analysis of deaths prior to March of 2020 (settings below) gives a reasonable prediction of deaths, however its accuracy is reduced during Dec - Feb (flu season...
ih

Discussions |
Oct 15, 2021 6:13 PM

2319 views | 4 replies
Preserving JMP Data Table Hyperlinks when Tables are Saved in Excel Format

At the risk of blasphemy, I am trying to figure out how to save a table that has hyperlinks for all data in a column in an Excel file, where the hyperlinks are still functional. I pull a lot of Excel data into JMP for faster data analysis and can add hyperlinks to entries in JMP columns. I can save the resulting charts as picture files and raw data files that can be read in Excel, but would also l...
JensRiege

Discussions |
Oct 15, 2021 3:39 PM

746 views | 0 replies
Index Linest Formula of Excel In JMP possible?

Hi All, I would like to know that possible to create the Index + Linest formula using JMP formula? Example of data table:TempMotor TempExchaust Temp135.635.2235.934.8334.934.2 With the index + Linest formula, i would like to get coef1,coef2 and coef3 results as attached in the excel file example. Final result as shown in Result column (-2.7619,196.1429 and -3447.1581). ResultExcel FormulaCoef1-...
dexue

Discussions |
Oct 15, 2021 8:31 AM

1593 views | 2 replies
Eliminating Empty Space in HTML when converting from Jmp Journal

Hi - I need some guidance to eliminate empty space observed between plots in HTML file when it is converted from a journal. I am using the following JSL code. Journal looks as expected but HTML has spacing between plots and table. Names Default To Here( 1 ); bigClass = Open( "$SAMPLE_DATA/Big Class.JMP" ); dt = Current Data Table(); nw = New Window( "BigClass", <<journal, vlb = v List Box() );...
uProf

Discussions |
Oct 15, 2021 7:53 AM

1492 views | 4 replies
Cannot remove limits from graph

I am using JMP 16 on Mac, and if the column has a spec limits (LSL / USL), then no matter what I am not able to remove them when making a graph. In the "Reference Lines" section there is a "Remove" button but it never works; I remove the line and it is removed in the preview to the left, but once I click Ok it comes back again. IS there a solution to this bug?
student1

Discussions |
Oct 14, 2021 12:57 PM

1061 views | 1 replies

Previous
Next

Latest Discussions

Preserving JMP Data Table Hyperlinks when Tables are Saved in Excel Format

At the risk of blasphemy, I am trying to figure out how to save a table that has hyperlinks for all data in a column in an Excel file, where the hyperlinks are still functional. I pull a lot of Excel data into JMP for faster data analysis and can add hyperlinks to entries in JMP columns. I can save the resulting charts as picture files and raw data files that can be read in Excel, but would also l...
JensRiege

Discussions |
Oct 15, 2021 3:39 PM

746 views | 0 replies
non-parametric response screening

I love the response screening platform. Is there a way to choose the fit y-by-x model to be non parametric, so i can compare non-normal distributions? is that the Huber/cauchy options?thanks
ezorlo

Discussions |
Oct 11, 2021 1:03 AM

609 views | 0 replies
JSL: Saving multiple chart and auto fit each of them into 1 page

I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...
giin

Discussions |
Oct 7, 2021 6:42 AM

799 views | 0 replies
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

Discussions |
Sep 10, 2021 10:38 AM

943 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

Discussions |
Sep 7, 2021 7:25 AM

943 views | 0 replies