JMP User Community

Latest Discussions

Paste data from JMP to Excel

Hello, I currently have a script which automatically populates a JMP table with Excel data, then runs a non-linear regression and saves the fitted data. I would then like to copy these new columns back into the same, open, Excel document. Is there a simple way to select the new columns, and then copy the data to the clipboard using JSL so I can paste it back in Excel? Cheers,
rinosaur

Discussions |
Jan 17, 2018 7:46 AM

8561 views | 4 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

5402 views | 5 replies
Populating yield by variable

Hi, I have a problem as shown below(not actual case though). I guess I can use Analyze - Tabulate for a simple dataset however in actual case, I have about 50 variables and 1million rows and it's going to be huge or simply time consuming to do it one by one. I would like to know from example below, how can calculate the yield(n_pass/n_qty * 100) by Test_Stn and parts supplied(in this case, Mat_sup...
adam

Discussions |
Jan 17, 2018 4:47 AM

6492 views | 2 replies
Basic JMP vs SAS overview?

Hi,I was wondering if there are folks who use (or have used) both JMP and SAS, and could give some sort of overview of the difference, and why someone might choose one over the other? Maybe to keep it simpler, JMP vs PC SAS.I've been programming in SAS for years, never took a look at JMP.Recently, I've been working on statistical process control stuff in SAS. And there's plenty of functionality ...
quentin

Discussions |
Jan 17, 2018 4:13 AM

49111 views | 11 replies
add rows after selected rows

Hello community,I am new to jmp and have troubles with creating a script that would add 1 row after each selected row within my dataset. Any ideas? My code looks like this so far: dt=Current data Table ();
dt<<add rows(1,46030); However, this of course adds a row only after the specified column. I selected my rows according to a sepcific name in one column and a sepcific value wihtin another column...
Pacco

Discussions |
Jan 16, 2018 3:00 PM

14284 views | 6 replies

Previous
Next

Latest Discussions

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

5402 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

4448 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

13903 views | 11 replies
summarize mean data by group and only last number of data point

hi,I want to get the mean value of my "raw data" by a group of 3 different columns ("test name", "measurement name" and "entity") - this i can do by the summary option.my problem is that I want only the last 13 points minimum (or last than 13 :) ) by date. those are my columns thanks for any help
AdamChoen

Discussions |
Jan 11, 2018 8:09 AM

3551 views | 1 replies
How do I plot "spiderdiagrams" in JMP

Hello,I have a large geochemical dataset that I am attempting to plot in JMP13. I use JMP for most of my geochemical plots but I have yet to figure out how to do so-called "spiderdiagrams." Following the advice of another post I found, I transposed my data table and was able to plot things that looked like spiderdiagrams using the graph overlay tool. This allowed me to plot the data and would work...
mcjenkins

Discussions |
Jan 11, 2018 7:09 AM

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

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

4641 views | 0 replies