JMP User Community

Latest Discussions

Compute Column Mean while restricting observations used

Hello, I want to get a column mean into a new column but I want to be able to restrict the date range that I use. I want to be able to say get column mean from day x to day y in my formula. This is the current formula that i have: New Column ("X", Numeric, Continuous, Format ("Best", 12), Formula (Col Mean (:WeeklyPercent, :Week, :Source)), Set Selected); It pull the average weekly perc...
chadyoder

Discussions |
Dec 19, 2014 11:45 AM

12060 views | 1 replies
Script template for creating jrp files from csv

Hi guysI am new to JMP Pro and to its scripting language, as well as to those SAS forums.If you think that I post my question in the wrong place - let me know and please excuse me,My goal is to create a script that will:open CSV filecreate variability chart based on table from this filesave the result as JRP fileNow some details.CSV file might be huge in row number. This file starts with line of c...
artem_verbuk

Discussions |
Dec 18, 2014 7:06 AM

10942 views | 3 replies
graph builder define x groups

i am using graph builder to display continuous data on x and y. if i drag to the top (X group) i get my data in bins (levels as jmp calls them) which is what i want and i can choose how many levels to display but i need to define each level (bin)
right now graph builder chooses the bin and i cannot find how to define manuallyjason
west

Discussions |
Dec 17, 2014 12:44 PM

5541 views | 3 replies
freeze columns and dynamic subsets within a data table

Dear , have two questions: 1: how to freeze pans or row/column in JMP like what we do in excel ? 2: for the subset table, usually from one master table, I create different subset based on my study purpose and save it in different name, from there do some graph plotting accordingly. this situation usually give me many different tables there is a software which just need save the master table (inc...
hupin

Discussions |
Dec 15, 2014 8:51 AM

16015 views | 1 replies
JMP10 : Oneway Plot >> How to connect data points between two groups (x-axis)

Bivariate plots, I can connect data points between two groups by grouping them first then Fit Each line.But for Oneway plots, I cant do that. Do you guys have any idea/trick?Thanks a lot.
pichan_p

Discussions |
Dec 14, 2014 6:00 PM

12175 views | 2 replies

Previous
Next

Latest Discussions

graph builder define x groups

i am using graph builder to display continuous data on x and y. if i drag to the top (X group) i get my data in bins (levels as jmp calls them) which is what i want and i can choose how many levels to display but i need to define each level (bin)
right now graph builder chooses the bin and i cannot find how to define manuallyjason
west

Discussions |
Dec 17, 2014 12:44 PM

5541 views | 3 replies
test statistics on odds ratios in logistic regression

I've been using logistic regression with multiple categorical predictors. I'm particularly interested in the odds ratios, and I understand how the odds ratios themselves are calculated, but I'm having trouble understanding how the test statistics associated with each odds ratio are calculated. JMP gives the disclaimer "Tests and confidence intervals on odds ratios are likelihood ratio based." M...
mjahnke

Discussions |
Dec 5, 2014 11:03 PM

3695 views | 0 replies
Is there a way to export a prediction equation from JMP to Excel?

Hello,I was wondering if there is a way to export a prediction equation from JMP to Excel?Thank you,Konrad
konradkk

Discussions |
Dec 4, 2014 2:39 PM

4697 views | 1 replies
Designing Your Own profiler

Is there a method to quickly design your own profiler. For example, if I already have a complex model (formula) with several independent variables, can I set up my own profiler to see the impacts of individual independent variables?
Steven_Moore

Discussions |
Dec 4, 2014 7:49 AM

3882 views | 1 replies
Align the values on graph to start at the same point?

I have some data from measurements and I need to compare the results between the several tests (graph of value over time with test number as legend). My problem is that different tests have starting values slightly different (later shape of graph is similar, but they are e.g. slightly above or below because of that start difference). Is it possible to 'calibrate' the graph so that the start value ...
prmiszkiewicz

Discussions |
Dec 4, 2014 7:13 AM

5839 views | 2 replies

Previous
Next

Latest Discussions

test statistics on odds ratios in logistic regression

I've been using logistic regression with multiple categorical predictors. I'm particularly interested in the odds ratios, and I understand how the odds ratios themselves are calculated, but I'm having trouble understanding how the test statistics associated with each odds ratio are calculated. JMP gives the disclaimer "Tests and confidence intervals on odds ratios are likelihood ratio based." M...
mjahnke

Discussions |
Dec 5, 2014 11:03 PM

3695 views | 0 replies
What robust methods are common for Process Capability Indices for Non-Nornal distributions?

In Europe, we found it common to use Cpkn as a non-normal Cpk metric, where mean was replaced with median, and stdev was replaced with IQR/1.35. For some "regulatory" or "customer" reports, this seems to be accepted rather than the usual "torture the data until it says its normal" approach with transformations. Does anyone have similar experience or better ideas? (Note: any use of capabilit...
mclayton200

Discussions |
Jun 19, 2014 2:05 PM

4887 views | 0 replies
Graph Builder Remove Variable

Hello,I am trying to use jsl to remove the x-axis variable and replace it with a different one. It looks like I should use the GraphBuilderBox <- Remove Variable() tool, but since I change the x-axis variable multiple times, I do not know its name and would like to use the Remove Variable(Role("X"), Position(1)) method, but this does not work. Any assistance would be appreciated.Thank you,Martin
Martin

Discussions |
Apr 15, 2014 6:44 AM

2750 views | 0 replies
How to calculate average (median) of a group of variables to get the eudlidean centre

How would I calculate the shape of the average (using the median) of a variable from a group within a data set? I need a certain function for calculating the centre of gravity (centroid) or Euclidian centre of this group of variable.
Many thanks!!
alexsheehy1992

Discussions |
Apr 2, 2014 12:17 PM

4176 views | 0 replies
LD50 and LT50 calculation

Hi everybody,I would want to calculate LD50 and LT50 from a dataset organized in 6 columns:- Name of the compound (I just got 1 compound named A)- Concentration of the compound (2 dilutions per compound)- Individual number (a fixed number of 10 individuals is used per assay)- State of the individual at the end of the experiment (1 = alive, 0 = dead)- Day death (experiment last 15 days)- Experiment...
cecilia

Discussions |
Mar 5, 2014 8:13 AM

5118 views | 0 replies