JMP User Community

Latest Discussions

How to open private data tables in loop

All,
I have a reasonably simple problem. It is my understanding that when you open the data table as private, you would lose the table when you don't retain the reference of the data table name. So, how do you retain the data tables especially when you are opening them as a part of a loop. For e.g.: FilePath = "C:\Test.xlsx"; SheetsList = Get Excel Worksheets(FilePath); OpenDts = {}; fo...
uday_guntupalli

Discussions |
Dec 8, 2018 6:55 AM

7778 views | 4 replies
Evaluating Dif Function by Column

I'm trying to evaluate the difference between two rows using the "Dif" function; however, the evaluation is continuous and has no regard for other columns. For example, with the "Big Class" DT I run the script below, but it will still compute the weight difference between a male and female. Is there any way around this? dt = Current Data Table(); dt << Sort( By( :age, :sex ), Order( Ascending, As...
Ksrzg01

Discussions |
Dec 7, 2018 2:22 PM

2805 views | 1 replies
LSMeans Tests between Student's t vs. Tukey HSD

Has anyone seen this result where Student's t letters are the same while Tukey HSD letters are different. I usually see visa versa. Any thought?
nickki_s

Discussions |
Dec 6, 2018 12:57 PM

9047 views | 1 replies
Restricting Col List Box entries

I have a problem with Col List Box. I'd like to restrict the list of columns available to be selected.I've already restricted it to Numeric and Continuous, but in my application that leaves a very long list.For that matter, if there is another way that's easier (Column Dialog?), that would be fine too. The documentation seems limited on this. For instance, it shows that a script can be added to th...
mwechtal

Discussions |
Dec 6, 2018 11:53 AM

7556 views | 4 replies
Select Cell Color for Row Based on one Cell's Value

Hello JMP Discussions. I think this is an easy one but everything I have researched and everything I have tried has failed. Is it possible to color all cells in a row based on the value found in a column of that row? I want to select a color that is readable for selected row and leave ones that don't fit the criteria with default color. If I use Color Rows by Row State the data is not readable ...
WendyLou315

Discussions |
Dec 6, 2018 7:40 AM

9955 views | 7 replies

Previous
Next

Latest Discussions

Evaluating Dif Function by Column

I'm trying to evaluate the difference between two rows using the "Dif" function; however, the evaluation is continuous and has no regard for other columns. For example, with the "Big Class" DT I run the script below, but it will still compute the weight difference between a male and female. Is there any way around this? dt = Current Data Table(); dt << Sort( By( :age, :sex ), Order( Ascending, As...
Ksrzg01

Discussions |
Dec 7, 2018 2:22 PM

2805 views | 1 replies
Help me make sense of the significance in Chi-Square Analyses results

Hey all,Here I have run the presense of a car passenger (1 = front seat, 2=back seat) against casualty severity (1 = fatal, 2 = serious, 3 = slight). I am having trouble understand the results. I understand that the expected count and the actual count is what I'm interested in, but how do I detect whether the difference between those two counts is significant. Thanks in advance!
Bearded

Discussions |
Dec 6, 2018 6:10 AM

9428 views | 4 replies
Viewing "Weighted N"

Hello,First of all, I should say that I am an Engineer with a very basic knowledge in statistics (perhaps thats why I am using JMP :) I have a data table with 90,000 rows and 12 columns. One of the columns has a pre-selected role as "Weight". The dataset I have has been sampled from a series of events with each event having its own "Weight". In our literature, it is common to publish Tables with "...
mikethejumper

Discussions |
Dec 4, 2018 5:34 PM

7783 views | 3 replies
DOE - ELISA method - 4 PL modeling

Dear JMP Community, My question is about a DOE performed on ELISA method.The response is the Absorbance and there are 3 factors which are dilution of different reagents (standard, parameter B and parameter C) - Refer to graph attached to visualize the type of data I have.I’m looking for optimizing the three factors to get a plateau equal to 2 for absorbance. But I would like also to be at “the beg...
TBrisset

Discussions |
Dec 4, 2018 3:23 AM

9188 views | 5 replies
Non-parametric Mixed Model

Hi everyone, New to the forum. I've been using JMP for a while now and I have encountered my first problem. Maybe it's not a problem to any of you, but I don't know how to run a non-parametric test on a mixed model. My understanding through the fit model platform is that this is a parametric method. However, there is no way to transform my data. I have a response, y, a fixed factor, and a ra...
tylerg4

Discussions |
Dec 4, 2018 12:43 AM

2401 views | 1 replies

Previous
Next

Latest Discussions

I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2560 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3235 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3641 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2465 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3443 views | 0 replies