JMP User Community

Latest Discussions

How do I make text box to a List for sql query

I am trying to make a text box to allow users to input information for sql query, and users copy this information from excel to text box. my question:1. This length of Lot is fixed =14, and there are 11 lots in this example. Why the length of text box is 176?2. How to make this text into a list as {"18148018-01-00","18148018-01-01","18148018-02-00"......}Names Default To Here( 1 ); //make a text ...
Benson

Discussions |
Jun 12, 2018 8:31 PM

10757 views | 4 replies
Using specific row values for use in a formula

Hey there,I'm sure this has been covered in the past, but I had trouble finding something that matched. In a new column I would like to calculate Average release for condition 9 as compared to the same time points in the control. Something like this logic:When Condition # =! "Control",Divide average release by the corresponing average release (by Time Point) in the Control. Eventually I would lik...
DBiber

Discussions |
Jun 12, 2018 1:24 PM

5623 views | 2 replies
Highlight cells based on matched column names

I have a script that colors the minimum values yellow for every Studentized column in a table. I want to also highlight values adjacent to these values in raw columns. For example, for Studentized Resid Rest Pulse, the cell adjacent to -2.321144119 in Rest Pulse column i.e. 44. How can I do this in jsl? Can regex or match be helpful? Thank you dt = current data table(); col = dt << get column nam...
Aam_jmp

Discussions |
Jun 12, 2018 6:12 AM

11374 views | 12 replies
How to use Dif/Lag function by Column group

Hi JMP community folks, I have a data table with four columns as Box, iClass, BinPos, and Slot. iClass means 24 level of products, BinPos means the Box location in the sorting equipment and Slot indicated which slot position the product be placed in the box. The Box is designed to hold a max quantity of 100 product, after that a new empty box would be placed in. In order to check the product is ...
bernie426

Discussions |
Jun 11, 2018 8:35 PM

21623 views | 11 replies
Need some quick help with Text Explorer

Folks, I need some qiuck help with the Text Explorer platform. I have a huge table with, let's say, parts replacement history. I need to analyze it. The field that has Parts Description in it is entered manually and is vaguely structured. I can have different entries for the same part. Let's say: "ABC DE", "ABC-DE", "New DE", "ABC of type (DE)", "Automatic Bull Catcher DE" and so on. Very hard t...
miguello

Discussions |
Jun 11, 2018 11:55 AM

7736 views | 4 replies

Previous
Next

Latest Discussions

Use ComboBox on TableBox

Hi I want to make a tablebox that one of it column eatch cell can have a value of "Yes" or "No"thought of using a combobox for ittry using the following code with no success new window("Bla Bla",
tb = Table Box(
c1 = String Col Box( "Bla Bla", {cb = combo box({"Yes","No"}) << get selected})
)
) any idea
cerdmh

Discussions |
Jun 11, 2018 5:31 AM

4734 views | 4 replies
How to set changing upper/lower limit lines on graph builder

Hello, I have a simple Y vs X graph that the upper limit and lower limit are changing at different X values. Does anyone know how to do this on Graph Builder? or if there's a better way to do it? Thanks,Gary
bgeaibreyi

Discussions |
Jun 8, 2018 4:54 PM

7050 views | 4 replies
Checking Lack of Fit Test Power

Dear JMP Community, Let's say JMP returned me a LOF test results. If I wanted to know how strong (or power) of that test to detect LOF, are there any indicator to this? Thanks. B.r,Chris
Zappy

Discussions |
Jun 8, 2018 6:08 AM

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

2510 views | 0 replies
Jacknife analysis

Hi,I am interested to do Jacknife analysis (Leave - One - Out) to get an an estimate of error in the mean of a sample distribution. I saw Bootstrap in JMP Pro and appreciate if anyone has done Jacknife analysis in JMP. Thanks.
AT

Discussions |
Jun 7, 2018 1:41 PM

5833 views | 4 replies

Previous
Next

Latest Discussions

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

2510 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

3097 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

1889 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

4059 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2863 views | 0 replies