JMP User Community

Latest Discussions

Comparing Columns of the Same Name Between 2 Data Tables

I have 2 data tables that contain numerical columns of the same name.I want run a script that will compare the column names across the tables and a unique identifier in a row. if they match then it should run a simple calculation ( % difference between the 2 numbers) and return another table with the results.I have tried to use the compare tables but this doesn't allow for the calculations I need....
d_barnett

Discussions |
Jan 17, 2014 1:03 AM

15420 views | 4 replies
Distribution Parameter Extraction Script

I am attempting to perform the following with a JMP script:Fit Weibull distributions to two different continuous data columns (TBI and TTR) in a table (dt1) BY all the different combinations of two categorical columns in the same table (STNFAM and VIEW_STATE_ID)Extract the Alpha and Beta parameters for all the resulting distributions and write them to a table. Even printing them to the log in a pa...
pstickel

Discussions |
Jan 16, 2014 12:26 PM

9085 views | 1 replies
How to create a legend in Graph Builder which preserves row state coloring?

I'm working on an asset performance analysis using multiple datasets. I've created custom colors (from ColorBrewer: Color Advice for Maps) for each asset and used the (anonymized) script below to set the Row State Color. It's a nice color scheme that fits my specific needs. The problem is that the Make Row Legend in the various platforms and Coloring schemes in Graph Builder will only allow select...
markschahl

Discussions |
Jan 16, 2014 11:37 AM

10713 views | 3 replies
How to manipulate axes scales in Graph Builder when using log units

Hello,Please see attached data file.
I am trying to plot "actual" vs. "perceived" separated by "context". I have created a graph doing this and saved the script as "Graph - Perceived ~ Actual x Context".(1.png) The data is skewed so I created via the formula function two new variable by logging both "actual" vs. "perceived". I then created a new graph and saved the script as " Graph - Ln(Perceived...
ac11ca

Discussions |
Jan 16, 2014 6:22 AM

20056 views | 2 replies
Multiple custom bivariate charts

Hi,I am writing a script to plot multiple custom bivariate charts (for each group). I have created the column dialog to choose the respective columns. However, it seems there is any error stating "Bad Argument( {Xaxis, Role requires at least 1 columns., Yaxis, Role requires at least 1 columns.}". Pls advise. ColDlg = Column Dialog( Yaxis = ColList( "Y-axis", MaxCol( 1 ), Datatype( Numeric ) ),...
Anonymous

Discussions |
Jan 15, 2014 2:00 AM

8893 views | 2 replies

Previous
Next

Latest Discussions

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

6575 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

7505 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

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

2897 views | 0 replies
how do I add labels to a bar chart showing the N for each mean

vertical bar chart, where each bar represents the mean(col name)? no problem, donenow we want to show the N for each of those means, right at the top of each columnhelp? thanks
jmp_ingbean

Discussions |
Nov 21, 2013 7:54 AM

4538 views | 2 replies

Previous
Next

Latest Discussions

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

2897 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

3421 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

3262 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

3582 views | 0 replies
Mean Diamond Confidence Intervals

I'm doing a simple Oneway Analysis, ~10 groups each with # of data points ranging up to 20.I noticed that there are 2 95% CIs that are calculated:1. One set for each group in the Means and Std Dev report below the chart, where CIs are calculated off of the Std Dev of each individual group2. One set for the Anova, where the Std Dev of all groups are assumed to be the same (calculated off of the S...
gugiyu

Discussions |
Apr 23, 2013 2:39 PM

4159 views | 0 replies