JMP User Community

Latest Discussions

Value Ordering of a column based in Ascending Date for another column

Hi everyone, I want to know if there is a way to assign the value ordering labels of one column based in another column that would have a date sorted ascending via scripting. Here is a little example of the columns. I want to have my ID's order by date.IDDate71220G101/04/201880102G101/05/201880209G102/19/2018 I need that beacuse I need to do a graphic in Control Chart Builder by ID, but to see the...
nicoleaba

Discussions |
Aug 20, 2018 3:12 PM

7558 views | 3 replies
Excel Table Formatting

I have written jmp script to auto generate reports and save as .xlsx, but unable to perform the cell formatting such as merge cells, cell color, font type etc.There was a discussion topic in this community mentioned about .xml method, however there is no further details.Much appreciated if someone show me how to get it done. Thanks.
HP_Lau

Discussions |
Aug 20, 2018 12:15 PM

12646 views | 5 replies
How to remove duplicate Graph Builder label

I wanted to add a label to an outlier data point, but somehow added two. How can I remove one of them? Label/Unlabel in the data table either removes both or restores both, but I need only one of them.
Knut

Discussions |
Aug 20, 2018 7:21 AM

4144 views | 3 replies
Formulas in JMP

I have been trying to write a formula since morning to refer to certain cells in my JMP table, however I seem to be able to get no where.I can make a clear general statement: When it comes to Formulas Excel is a far ahead of JMP.Its difficult to understand why its SO SO SO difficult even simple formulas in JMP !
none1

Discussions |
Aug 20, 2018 7:06 AM

16128 views | 5 replies
How to calculate zero portion in %

What is the best way to create on formula column, which shows the portion in percent of values = 0 (Zero portion)?In case the value column is empty, no portion value should be display in the formula column.
Thomas1

Discussions |
Aug 20, 2018 6:57 AM

6208 views | 4 replies

Previous
Next

Latest Discussions

How to remove duplicate Graph Builder label

I wanted to add a label to an outlier data point, but somehow added two. How can I remove one of them? Label/Unlabel in the data table either removes both or restores both, but I need only one of them.
Knut

Discussions |
Aug 20, 2018 7:21 AM

4144 views | 3 replies
One-sided confidence intervals for proportions

I have been using JMP to calculate confidence intervals for proportions and I have been wondering: JMP automatically calculates two-sided confidence intervals, right? If i needed for example a one-sided 90% lower confidence interval, I would have to have JMP calculate a two-sided 80% confidence interval and the only use the lower limit? Thank you in advance.
Knekse

Discussions |
Aug 17, 2018 12:59 PM

13094 views | 9 replies
pasting bug?

I am having a very difficult time lately copying and pasting from excel (Excel for Macintosh version 16.12) to JMP (13.2.0).A column of numbers (not dates or text) will want to paste as characters. When I accept that and then go into Standardize attributes and recode I can always find one single value that has gibberish characters added to the number.This can even happen if I take a numerical col...
Maureen

Discussions |
Aug 16, 2018 4:38 PM

8093 views | 7 replies
Correlation for binary data in different columns

Hi So I have a very large dataset full of 1's and 0's for each column. I am trying to see if there is any correlation between some of the particular columns.I am trying to correlate data on inside an area vs. outside of the area to see if there are any significant differences between people inside and outside these areas. And I am doing it for many different areas. It is a survey with yes and no a...
Maxpower1123

Discussions |
Aug 16, 2018 12:39 PM

13140 views | 10 replies
pb with update database

hi, with jmp14, I've created a database with the query builder.when I want to update the data base, there is no update.I don't understand why. If someone could help me...//Beginning of the script for the update of the database: New SQL Query( Version( 130 ), Connection( "JMP" ), JMP Tables( ["Exploitation" => "Source(Open( \!"S:\Guingamp\Commun\Fab\BDD Exploitation.xlsm\!", Feuilles de...
Françoise

Discussions |
Aug 16, 2018 1:06 AM

4743 views | 7 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

3281 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

2314 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

2849 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

1710 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

3811 views | 0 replies