JMP User Community

Latest Discussions

Calculate average of x highest hourly values per day

We are looking to average the highest x hourly values in a given day across large data sets. For example, the average of the 12 highest hourly values within a given calendar day over a five-year period. The data include date, hour, and value for various metrics. Thank you for any suggestions.
FourPeaks

Discussions |
Jun 22, 2022 8:52 AM

1612 views | 4 replies
Rolling average (30 days) using continuous time data

I have 180 days of recent data totaling 2574 rows in JMP. I have included a file with just two columns, one is the DATETIME stamp and the other is the MAX_VALUE data at that timestamp. I have created an X-Y chart of MAX_VALUE (Y-Axis) vs DATETIME (X-Axis). I wish to add a trendline where its value at any given time is equal to the average value of MAX_VALUE over the past 30 days. Can somebody help...
ControlKangaroo

Discussions |
Jun 22, 2022 8:23 AM

3483 views | 5 replies
How DoE model evaluation impact final model after experiment?

Hi Folks, I have several questions about DoE, could you please answer them? Thank you so much. 1) Due to experiment constraint, can I manually adjust center point value for example (-1)= 10, (+1)= 12, (0) = 11. But (0) = 11 is not a good center point, can I change to 10.5 in the design? How this change will impact the data analysis and final model as well as model prediction? what if I used (0)= 1...
lazzybug

Discussions |
Jun 22, 2022 7:14 AM

1996 views | 4 replies
How do I run multiple CMD commands?

Hello, I am trying to do a simple extract of a zip file (TGZ) from JMP using the command prompt, and I don't manage to do it using the following approach (I tried many ridiculous ideas, none seem to work...): Names Default To Here( 1 ); path1="C:/Users/niros/Downloads/"; path2="C:/Program Files/WinRAR/WinRAR.exe"; path3="C:/Users/niros/Downloads/LP.tgz"; RP = RunProgram( Executable( "CMD.EXE"...
Niros

Discussions |
Jun 22, 2022 7:07 AM

3095 views | 5 replies
Error: Unexpected end of input. Perhaps there is a missing "," or ")".

Hello, Whilst trying to automate data visualisation from a file I am encountering an error message after entering these lines of code // Delete selected rows dt( "Export" ) << select where(row() >= N Rows(dt) - 1; dt << delete rows; Here I would like to delete the last 2 rows of each file I open regardless of their length.If you could help, that would be very much appreciated Names Default To He...
jlmbs

Discussions |
Jun 22, 2022 7:02 AM

2862 views | 2 replies

Previous
Next

Latest Discussions

Using formula

Hello everyone, i am wondering if there is anyone that can help with a formula problem. I would like to compare two different columns and result the values in a third column but i cannot find a versus formula on jmp. Any ideas or suggestions are highly appreciated. Thank you!
OmegaKoala673

Discussions |
Jun 22, 2022 6:51 AM

956 views | 2 replies
Non-parametric test

Good day,I would like assistance with the ANOVA equivalent for a non-parametric test.I understand that to do this there are several options in JMP, one which is the The Kruskal-Wallis test, however, I am stuck on how to use this for:1. Two/three way type of ANOVA in the case of a parametric test.2. When I try using the Fit Y by X option using Steel-Dwass there are no option for connecting letters....
Gabriel

Discussions |
Jun 21, 2022 7:32 AM

896 views | 1 replies
Use Local Data Filter for Cpk Chart

Hi JMP Community,Below is the report that I want to generate. I would like to see individual reports for SI1 to SI10 (values in "Process" column) by changing the filter inside Local Data Filter. Since I would like this process to be automated in the future, I exported the script of it. But when I ran the script again, error occurred. Can anyone help to identify the error in the script? I suspect i...
AsymptoticBat64

Discussions |
Jun 21, 2022 7:29 AM

985 views | 1 replies
JMP - Updating reports

Can JMP automatically provide an updated report(eg in power point) when the data gets new updates?
Zara

Discussions |
Jun 21, 2022 5:30 AM

1005 views | 2 replies
Prediction profiler confidence level change

Hello, How do you change the confidence level in the prediction profiler? Thank you, Jeff
Jeff1

Discussions |
Jun 21, 2022 2:56 AM

1698 views | 3 replies

Previous
Next

Latest Discussions

Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

800 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

641 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

805 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

1028 views | 0 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

719 views | 0 replies