JMP User Community

Latest Discussions

Multiplying two columns with jsl script

I am trying to multiply two colums with jsl script. But no success.dt<<new column("C", continious, Formula(:A * :B));
masum111bd

Discussions |
Nov 16, 2017 2:39 PM

5624 views | 1 replies
Number Edit Box on change script

I'm new to JSL and Application Builder, so bear with me.I'm trying to build a dialog box that has a series paired Number Edit Boxes. One of each pair represents a "start" time and the other a corresponding "end" time: I want to avoid the situation where the user puts in a "start" time later than the "end" time, or an "end" time prior to the "start" time.My first thought was to add an "on change" s...
john_madden

Discussions |
Nov 16, 2017 11:33 AM

19316 views | 8 replies
Saving to a SQL Database from a JMP Table: Does the Original SQL Table Have to be Replaced?

I would like to add data to my SQL database directly from JMP tables without modifying column deisgnations already created in my SQL database. However, when I use the "Save to Database" script that is provided in JMP, the JMP table completely replaces the table in the SQL database. This modifies all of the column properties in the database table (e.g., changing an Integer designation to Float). ...
SRoweton

Discussions |
Nov 16, 2017 7:31 AM

7546 views | 2 replies
Color Cells based on formula result

Hi everyone,I have a column (lets call it Indicator) with a formula in it that returns a 0 or a 1.Right now I know how to do this:formulaResult = :Indicator << Get Values;
:Indicator << Color Cells( "red", Loc(formulaResult==1) );But what I really want to do is have the data table dynamically respond: if I change the data so that the Indicator switches to 0 (false), I don't want the cell to highlig...
mjoner

Discussions |
Nov 16, 2017 6:29 AM

16457 views | 17 replies
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

3957 views | 0 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

3957 views | 0 replies
JMP exit code

Hi All, My script works just fine but I do get this exit code -2147023895. Any idea what this is? I believe the exit code should be wither 0 or 1. Maybe I am using a function in the wrong context. Thank you.
vishwasanj

Discussions |
Nov 14, 2017 1:18 PM

4402 views | 3 replies
PCA Model Validation Techniques

PCA can be used to build a model that describes a set of observations. Using the multivariate platform it is possible to perform jacknife and T2 outlier analysis to check if any of the observations are extreme relative to the multivariate mean.In what situation might a weights column be used to build the model?If you use a PCA model how do you maintain it? If I have a new observation(s), I can app...
stephen_pearson

Discussions |
Nov 14, 2017 6:53 AM

5915 views | 3 replies
How can I move the x-axis on top of graph?

Hi, I'm trying to create a trace element concentration profile and need to have the x-axis (concentrations) at the top of the graph so that it can show how the concentration varies down-core .. Is there any way to do this?
maribliss

Discussions |
Nov 13, 2017 6:55 AM

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

2840 views | 0 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

3957 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

2840 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

2968 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

3569 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

4640 views | 0 replies