JMP User Community

Latest Discussions

Calculating difference between two dates and times in hours

Iam trying to subtract two dates and times and get the answer in hours. For example Column1 Column201/30/2013 5:30 02/02/2013 14:30I want to subtract column1 from column2 and the difference in hours. I want to do this in JSL Scripting language... Can some one help how to subtract the above two dates..I mean the formula for doing that,.Thanks a lot

fr2007

Discussions |
Feb 14, 2014 10:57 AM

16367 views | 3 replies
Creating a running total of a column

I am wondering how to create a column in a JMP table that is the running total of another column (which I may need to reference via the column name as a string). That is, if I have a column with the following data:12345I would want to create a column with a formula whose contents would work out to1361015Currently I have this loop, working from a list of names of columns to take the running total o...
david_t_pitchfo

Discussions |
Feb 14, 2014 8:36 AM

10494 views | 4 replies
Customizing the title of a set of plots

I currently have a script to produce the following plot. The call that finally produces it looks like this:chart = Bivariate( Y( :Log10 Reads , :Log10 Writes ), X( :Bin ), Nonpar Density, Send To Report( Dispatch( {}, "Bivar Plot", Framebox, {Frame Size(plotWidth, plotHeight)}), Dispatch({}, "1", ScaleBox, {Format("Best", 10), Min(xMin), Max(xMax), Inc(xInc), Min...
david_t_pitchfo

Discussions |
Feb 12, 2014 8:30 AM

10242 views | 1 replies
Query about Line Up Box behavior

Hi,In the following script fragment I've defined an array of six button boxes within a Line Up Box five slightly different ways in as many different windows. In the first window I don't bother to specify the width of any of the buttons – no problem. In the second and third windows, I specify that I want one of the two columns to be a specific width by setting the width of just one of the buttons...

Discussions |
Feb 11, 2014 1:42 AM

9327 views | 4 replies
JMP Script: Random Functions

Hi Folks,I am trying to use a variety of random functions for continuous plots. I find that many exist in JSL, but many do not. Am I missing something here? If you look below you will see in blue the expressions that exist, while those in black do not and I list the variables that I would expect them to take.Thanksrandom normal(mu, sigma);random log normal(mu, sigma);random weibull(beta, alpha); ...
clausa

Discussions |
Feb 10, 2014 11:31 AM

9360 views | 2 replies

Previous
Next

Latest Discussions

How to split the data and plot the graphs based on date

I have the data for 2 years (2011 to 2013) with a date column in 'YYYY-MM-DD' format, I want to split the data into monthly parts i.e 2011 Jan - Feb.... to 2013 Nov and also plot histogram calculate the total no case reported each month for period of 2 yeaer. Please let me know how can I split the data and the plot a line graph to compare the performance. I m very new to JMP. Kinldy assist CA...
nyeesg

Discussions |
Jan 29, 2014 7:07 AM

5891 views | 4 replies
Combining multiple screenings in Fit Model?

Hello, I've been using the Screening function to fit my data. It's been working well for individual outputs but I haven't been able to figure out how to make a model with multiple outputs and have it screen for the best fit for each output. The reason I would like to do this is to use the desirability function for multiple outputs, which has been pretty useful in determining the most ideal s...
dil950

Discussions |
Jan 23, 2014 8:13 AM

2476 views | 0 replies
Upper-tailed t-test in JMP

In performing and upper-tailed t-test in JMP, the order of the predictor variables determines in which tail the p-value falls. However, the null hypothesis may not directly reflect this outcome. How do you reverse the order of the variables so that JMP does not pick which to give precedence. Example, if I want to perform a t-test for whether the mean of Female test scores are higher than Male test...
memma

Discussions |
Jan 9, 2014 8:44 AM

6960 views | 3 replies
Column name as variables

Hi there,I have a question related to the column name convention. For example, I have a table contains the ages of students from several grades. age_grade1age_grade2age_grade3age_grade4age_grade5age_grade6age_grade7
I like to define a parameter, so I can use "for" loop to do some data processing. 1: only select the non-empty rows.Parameter = "age_grade1" ;dtRaw << Select Where( Is Missing( Paramete...
shasha

Discussions |
Dec 13, 2013 11:04 AM

7800 views | 1 replies
How do I recode indicator columns into one nominal (or ordinal) column?

I have a data set that has been created with indicator columns for all nominal and ordinal variables (for the purpose of running a regression model). For instance, the variable "Marital Status" has 3 possible values, Single, Married, Divorced. The current data file has two columns for this one variable. A "1" in column one and a "0" in column two indicates "Single", a "0" in column one and a "1" i...
jmpuser1234

Discussions |
Dec 2, 2013 1:19 PM

3704 views | 1 replies

Previous
Next

Latest Discussions

Combining multiple screenings in Fit Model?

Hello, I've been using the Screening function to fit my data. It's been working well for individual outputs but I haven't been able to figure out how to make a model with multiple outputs and have it screen for the best fit for each output. The reason I would like to do this is to use the desirability function for multiple outputs, which has been pretty useful in determining the most ideal s...
dil950

Discussions |
Jan 23, 2014 8:13 AM

2476 views | 0 replies
Multiple F-tests

I am looking for a feature similar to the "Compare Means" -> "Each pair by Student's t" found under the "Oneway" "Fit X By Y" analysis option. That is, I want to perform an F-test between any two levels of the categorical X-axis variable, yielding the P-values for each test and hopefully also a "Connecting Letters Report" or something equivalent. Preferably I would like to do this for either one o...
JesperJohansen

Discussions |
Nov 28, 2013 4:41 AM

3010 views | 0 replies
Bar chart with data table

I need to create some graphs like the one shown in the picture below (Excel).What is important is that the bar groups are displayed with the individual data.I know that I can chart a bar graph and then insert a table below it. But wouldn't it be difficult make it look as nice as the Excel version.What would be an alternative solution that works just as good visually?Any help is greatly appreciated...
peder

Discussions |
Nov 19, 2013 1:08 PM

3591 views | 0 replies
Best method of analysis of multiple dependent variables in JMP

I need a predictive model for two response variables (that are dependent on each other) and multiple independent variables. I'm not very statistics-savvy but am comfortable with multiple regression; however, I'm not sure of the best way to approach a problem with multiple dependent variables. I've been studying some of the approaches (MANOVA, MANCOVA, multivariate multiple regression, structural...
kcros

Discussions |
Sep 24, 2013 11:37 AM

3462 views | 0 replies
How to do a clean uninstall of JMP9 on a Mac?

Wondering if this is as simple as dragging the application package to the trash. The OCD in me would like to also get rid of associated library and preference components. The manuals and online resources don't give any direction. And since I have JMP10 installed, I don't want to rip out resources shared with the new version.
uw_viromics

Discussions |
May 17, 2013 6:26 PM

3783 views | 0 replies