JMP User Community

Latest Discussions

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

7552 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

16479 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
Need help for using Lag function

Hello everyone! Hope someone could help me with this: What is is the expected output of the following code? After evaluation I get the following Log: And the new columns just looks like this: SliderID column is :Hope someone could enlighten me with this! thanks in advance! :)
switzal87

Discussions |
Nov 14, 2017 11:56 PM

15355 views | 5 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

4404 views | 3 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

4404 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

5921 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

5371 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

2841 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

2841 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

3570 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

4641 views | 0 replies