JMP User Community

Latest Discussions

Count of records with specific values

Hi, I am working on a project where I have ID and attendance indicator for each ID (0 - Attended, 2 - Non - Attendance). I need to calculate the cumulative non - attendance rate as shown below. I need to know cumulative count of Non - attendance and divide by total count of that ID. This needs to be calculated on cumulative basis. Appreciate if anyone can help me with a formula / script to accompl...
Rini_Kar

Discussions |
Jan 22, 2018 11:32 PM

5035 views | 2 replies
overlay plot customize color

I use overlay plot often to plot the change overtime. Usually I customize the color and line style of each variable (see attached). However, when I add more variables to the plot by "relaunch analysis" command, all the cusotmization is gone and I have to redo everything--which could be a pain if I have many variables. Is there a way to save the customization, and when I relaunch analysis, I just h...
xiaoyaj0

Discussions |
Jan 22, 2018 6:49 PM

18168 views | 9 replies
Multiple parameter selection

Hi, I have the following script that will tabulate test_type_combo by few tests(Test1, Test2, Test3, Test4, Prepass) each with sum the n_unit and n_unit_passed for a parameter named coil_supplier_A. Then will create a new column, Yield. From here, I will have Graph builder to do the plotting. Can I know if I have multiple parameter for suppliers, each in a column eg. coil_supplier_B, coil_suppli...
adam

Discussions |
Jan 22, 2018 6:25 PM

7103 views | 6 replies
not equal to symbol

Hi, I have the following script and it does not select the correct columns names ("Std"). Here is the script: cols = dt << Get column Names(); for( i = 1, i <= N Items( cols ), i++, if( contains( cols[i] , "Std") != 1 , Column( dt, cols[i] ) << Set Data Type( "Character" ); Column( dt, cols[i] ) << Set Modeling Type ("Nominal") ) ); Looks like != does not do the job. Any help on this? Tha...
AT

Discussions |
Jan 22, 2018 5:35 PM

13643 views | 2 replies
How to get the UCL value for Outlier analysis in a script?

Hi, I like to write a script to get the UCL for multivariate outlier analysis using Mahalanobis Distance.I can get the UCL by going through the JMP menu but is there anyway one can get UCL and set it to variable name in a script. I appreciate your hlep. Thanks.
AT

Discussions |
Jan 22, 2018 4:16 PM

6819 views | 2 replies

Previous
Next

Latest Discussions

Joining Two Datasets Using Closest Date Match

Hello all. I am attempting to join two datasets in JMP using a unique identifier plus a closest date match. I have some code here that runs and is pretty close to what I need but I am having trouble with it keeping many to one matches. One unique identifier "EMP_ID_UID" could (or could not) have several "Transaction Dates" and multiple "MED_SCAN_DTIMES" will match one "Transaction Date" (because...
sagrim

Discussions |
Jan 22, 2018 1:22 PM

4729 views | 1 replies
Nonlinear regression using vba automation

Hello, I currently have a working JMP script which automatically fits my raw data using a predictor formula fit1 = Nonlinear(
Y( :Name( "-60" ) ),
X( :Formula ),
Iteration Limit( 100 ),
Newton,
Finish
);
fit1 << Prediction Formula;
fit1 << Close Window; I am now trying to automate this side of things from Excel using VBA. Is it possible to automatically run this non linear regression using vba and paste ...
rinosaur

Discussions |
Jan 22, 2018 1:08 PM

3852 views | 1 replies
Help with mutivariable regression

Hello, Im attempting to do a multivariable logistic regression looking at the independent association of variables for an adverse event, however the result for my variable of interest is reading as unstable. I believe this is because the variable actually has a 100% sensitvity for my outcome (adverse event) on univariate analysis. If this is this case, does anyone have suggestions on what to do? T...
nmg

Discussions |
Jan 17, 2018 6:21 AM

5288 views | 5 replies
Sizing Data Table in Display Box

I have searched ad nauseum and cannot not find a solution to my problem. I'm trying to set up a window for my users that dynamically updates some summary data and two plots based on their selection. I'm working with display boxes, but when I append my summary data table, no matter what I've tried, the data table is always smaller in width such that the last column is cut off, leaving me with wha...
CS13

Discussions |
Jan 16, 2018 2:58 PM

4400 views | 2 replies
User Interface

Hi,I have made a UI and like to make some changes to it. This is shown below:I like to move "OK" and "Cancel" to bottom of the window and in "Select Product Name" only choose on product (combine the right and left). Also like to know how to choose these options and put them in a varaible to be used for further scripting. I have attached the actual script.Thanks so much for your help.
AT

Discussions |
Jan 15, 2018 4:16 PM

13663 views | 11 replies

Previous
Next

Latest Discussions

Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3922 views | 0 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2803 views | 0 replies
Confirmation of Repeated Measures Analysis, when sphericity if voilated

Hi Everyone, I would like confirmation on the appropriate analysis to run on a repeated measures design.Experimental design:Independent variable: Nutrient treatment (Control, Low, Med, High),Dependent variable: basal diameter, 5 replicates (plants)Repeated measurements were taken at Weeks 0, 1, 4, 7, 10, & 12Split data-> Fit Model-> Y: basal 0, basal 1, 4, 7, 10, 12, Add: Nutrient treatmentPers...
uamiller

Discussions |
Oct 23, 2017 8:07 AM

2903 views | 0 replies
Cox Proportional Hazard - adjusting risk ratio with std dev

I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP. When I questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...
Maureen

Discussions |
Aug 22, 2017 1:18 PM

3514 views | 0 replies
JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4569 views | 0 replies