JMP User Community

Latest Discussions

Formula to interpolate between columns

Hi! Got a request from one our users in refining to interpolate a crude distillation curve. Some background info: YouTube Video on Distillation PlotsASTM D7169 Data table has twelve columns with the boiling points for different volume%iles of the crude. I want a formula that will interpolate across the columns to calculate how much has a boiling point less than T.Of.Interest. I know that the Inter...
markschahl

Discussions |
Jul 21, 2018 10:17 PM

10674 views | 6 replies
Deleting data that is not within the required date range

I have two dates saved in a text file in the format mm/dd/yyyy. I need to analyse data that falls in this date range and delete all other data.How can I do this?
ENTHU

Discussions |
Jul 20, 2018 10:48 AM

8623 views | 3 replies
how do i invert Unhide and unexclude rows based on values in few columns

Hello,I need some guidance here....I have two columns (per_Change) and Step (it's a formula based values) and Per_Change column is sorted from -ve to +ve values.In my script i need to know max rows so i created rank column from 1-14 (ascending order as attached image) and need to have atleast 8 rows (starting with highest rank). Steps:1. Exclude -ve values in Per_Change column2. then in Col Step i...
CG

Discussions |
Jul 20, 2018 9:40 AM

6037 views | 2 replies
SVM

Hi, I am trying to use SVM on my data. I have found an ADDin but dont know how I should get the R-code. I follow all the steps in the video but dont understand from where R-code is coming ( step no.8) can any one help? would the R--code be the same for any type of data? I have R installed on my computer. https://community.jmp.com/t5/JMP-Add-Ins/The-JMP-to-R-Add-In-Builder/ta-p/43879 thanks
Alma1

Discussions |
Jul 20, 2018 8:14 AM

12163 views | 14 replies
Finding first and last elements in a column with a By variable

Hi! I'm investigating what happened to continous variable (tank level in this case) during certain events. I have an Event.Date column that acts as a By variable. Event duration varies, see DayOfEvent column. I want to calculate: LEVEL @ end of event - LEVEL @ beginning of event, i.e. last element - first element by Event.Date. If positive, tank was filled, if negative tank was emptied, if ~0 tank...
markschahl

Discussions |
Jul 20, 2018 6:25 AM

5530 views | 3 replies

Previous
Next

Latest Discussions

SVM

Hi, I am trying to use SVM on my data. I have found an ADDin but dont know how I should get the R-code. I follow all the steps in the video but dont understand from where R-code is coming ( step no.8) can any one help? would the R--code be the same for any type of data? I have R installed on my computer. https://community.jmp.com/t5/JMP-Add-Ins/The-JMP-to-R-Add-In-Builder/ta-p/43879 thanks
Alma1

Discussions |
Jul 20, 2018 8:14 AM

12163 views | 14 replies
Determine significance of difference between percent differences

I have four sets of data from two experiments: one set of "before" measurements and one set of "after" measurements for each experiment. For each experiment, I have calculated a percent difference between the mean of "before" data and the mean of "after" data. I would like to know if the difference between the percent difference calculated for Experiment 1 and the percent difference calculated for...
ryandgus

Discussions |
Jul 20, 2018 12:23 AM

6993 views | 2 replies
http Request with authentication using windows identity

I'm using JMP 13.0.0. I'm currently using the function Load Text File (url) in order to retrieve JSON data from a web api running on my company's intranet. The server requires authentication against our windows active directory. Currently, a dialog pops up requesting credentials, and I can manually type in credentials when prompted, but I want my script to run without that manual intervention. ...
BioData41

Discussions |
Jul 18, 2018 1:01 PM

2709 views | 1 replies
How do I change horizontal error bars to vertical error bars?

I am making a graph, and I have the error bar "points" set to "standard deviation". The error bars present are horizontal, and I cannot figure out how to make them vertical. I've attached a screenshot of my graph. Thanks in advanced for the help!
bezansoncarrie

Discussions |
Jul 18, 2018 12:39 PM

3897 views | 1 replies
Custom DOE - factor levels

I want to create a custom DOE. I have 1 discrete numeric vatiable with 3 levels (1,2,3). I have 2 covariate factors. I also has 1 continuous variable. The problem is I want the DOE with 5 levels for the continuous factor and JMP is only allowing me 2 levels. Am I doing something wrong when I specify the continuous variable or am I limited to just 2 levels?
jjhartwi

Discussions |
Jul 18, 2018 12:27 PM

2762 views | 2 replies

Previous
Next

Latest Discussions

repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

2941 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2056 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

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

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

Discussions |
Mar 17, 2018 2:22 AM

3543 views | 0 replies