JMP User Community

Latest Discussions

Return the Row Number of Maximum

Hi, Is it possible to get the row number of the maximum value of a column? I would like to create a formula that uses a value in a column as an offset and I would like to write it in generic form such that it looks in Col1 for a maximum value and then returns the row number such I can use the value of col2 at that row number as the offset. How could I do this? Thanks in advance Andy
Hegedus

Discussions |
Jan 11, 2018 5:06 PM

11881 views | 6 replies
Script for standard deviation based on +/- 1.5 sigma

Hi,I like to calculate standard deviation based on looking at data with ranges of values (+/- 1.5 sigma). Is there anyone you can achiev that in JMP? I appreciate your help. Thanks
AT

Discussions |
Jan 11, 2018 4:19 PM

9455 views | 7 replies
Save Bivariate plot to JPEG

Hi, I was able to get the Bivariate plot. But I'm unable to save the plot as a picture as I have error in my save. Any help would be great. Thanks. Open("C:\jmp_data\NamesData.jmp", window bounds(600, 50, 500, 400), window state(maximized)); window_DATA = New Window("NAMES SHOW", Bivariate(Y(:Name("AGES")), X(:Name("GENDER")), Fit Line({Line Color({100, 50, 50})}))) << Maximize Display << Set...
sam_t

Discussions |
Jan 11, 2018 9:37 AM

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

6344 views | 2 replies

Previous
Next

Latest Discussions

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

6344 views | 2 replies
Batch effect adjustment using Housekeeping Genes

Hello, starting from a txt file with count data, I am analysing RNAseq data from three different independent experiments which should be merged into a single analysis. Sample characteristics, such as disease conditions, are perfectly confounded within the batches. The use of housekeeping genes, such as those suggested by Eisenberg et al. (http://dx.doi.org/10.1016/j.tig.2013.05.010), could be one...
AS

Discussions |
Jan 10, 2018 10:52 AM

4052 views | 1 replies
JMP Script for inverse prediction

Hello everyone, I want to automate my data analysis, therefore I wanted to write myself a script to make things easier. Basically, I want to take my standards to generate a standard curve using 4P fit. (Columns 1, 2, 3 are triplicates of those standards, so I want to have an average value) Afterwards, I want to use the inverse prediction formula that has been generated by the 4P fit and apply it t...
Robertasm

Discussions |
Jan 9, 2018 6:16 AM

9442 views | 11 replies
bell curve for exam grade calculation

dear all, I made an exam and ı want to calculate exam grades by using bell curve approach. I heard this approach but ı do not know how can I apply it. How can ı calculate their exam grades? which one is A,B,C etc... Each line represent one student exam result at the attached jmp file. Please help me. I need very urgent help. Thank you.Best Regards,
nac

Discussions |
Jan 9, 2018 5:44 AM

4160 views | 1 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