JMP User Community

Latest Discussions

how do I multiply each row values backward in one column until a criteria is met

Hello, I have the following challenge that I have trouble scripting with. My starting data table looks like below. I would like to multiply Xi backwards starting from col2 =0 as the criteria and put the new values in a new column.col1 col2X1 0X2 y2X3 y3…Xn ynXX1 0XX2 yy2….XXn yyn….….My end data table would look like this:col1 col2 col3X1 0 Xn*Xn-1*……X3*X2*X1X2 y2 Xn*Xn-1*…..X3*X2X3 y3 Xn*X...
Tinghui

Discussions |
Nov 17, 2020 8:43 AM

3669 views | 7 replies
Exporting Model Formulae to Excel

Hi,I'm sure this has been asked previously and I'm just missing something in my search, but is there an easy way (other than copy and paste) to take the prediction formula from a regression model in JMP to apply directly to an Excel table? Thanks in advance
SLittle

Discussions |
Nov 17, 2020 8:39 AM

2185 views | 1 replies
How to extract a report name in a generic way using jsl

Hi, I would like to extract the report name using jsl. The script posted below is able to do so, but not for all types of reports. For example: I am able to extract the correct report name for a Graphbuilder report, but not for a Fit Manova report.This results in an error: "Name Unresolved: rescript in access or evaluation of 'repscript', repscript/*###*/" Is there a solution to make this script m...
RobRobeyns

Discussions |
Nov 17, 2020 8:15 AM

2499 views | 3 replies
Scripting to Combine Columns based on Formula

I have a template dataframe that contains 209 columns labelled 1-209. Often a client will forward me datasets that has combined columns, for instance, column 2 may be added with column 3 (labelled '2 + 3') in the new dataset. How can I extract the columns in the new dataset and use these as formulas to make the columns the same in the template dataframe? I know JMP has a combine function, but how ...
MikeDereviankin

Discussions |
Nov 17, 2020 5:17 AM

4735 views | 4 replies
Short cut to apply same test to all groups

Dear JMP USers, Is there any short way to apply same test to all groups.For example i have distributions for 8 groups. I try to check whether each group comes form a normal dist.Is there any short way to apply goodness of fit test to all groups at the same time with one click, or do i have to use red triangle and apply goodness of fit test one group by another?
Ella

Discussions |
Nov 17, 2020 1:26 AM

1725 views | 1 replies

Previous
Next

Latest Discussions

Exporting Model Formulae to Excel

Hi,I'm sure this has been asked previously and I'm just missing something in my search, but is there an easy way (other than copy and paste) to take the prediction formula from a regression model in JMP to apply directly to an Excel table? Thanks in advance
SLittle

Discussions |
Nov 17, 2020 8:39 AM

2185 views | 1 replies
How to add mean of coordinates in bivariate plot, aka plotting Centroids

I have a series of coordinates with two types of rows. Data is in three columns: Column1(x-coordinates), Column2 (y-coordinates), and Type.After I plot them in a bivariate analysis and draw an ellipse around both groups of coordinates, I'd like to have a marker added to the center of each group marking the centroid of each group of coordinates. The marker should, preferably, match the color determ...
echava

Discussions |
Nov 14, 2020 9:55 AM

3380 views | 4 replies
How to perform simple intraclass correlation to determine interrater reliability?

I'm trying to figure out the best way to complete a relatively simple intraclass correlation (ICC) analysis. In my study, three raters scored 100 performance evaluations on a 1-10 scale for various components of performance. Each rater scored each performance evaluation once. I ran the Measurement Systems Analysis platform with Rater as "X", Evaluation (1-100) as "part", and Score as "Y". I got a ...
francisk

Discussions |
Nov 13, 2020 6:15 AM

5113 views | 1 replies
DOE question

Hi everybody, I am quite a beginner regarding DOE and I have a small question.Basically let's say that I have an experiment with several factors. In particular I want to test a component which has two possible levels and I would like to test several concentrations ( 0, 10, 20 or 40). Therefore I created my design with a categorial factor (Component: A, B) and a discrete numeric one (Concentration:...
anne_sa

Discussions |
Nov 13, 2020 2:21 AM

5173 views | 9 replies
how to define a column as a label point in a graph by graph builder?

Hi everyone,I am familiar with Label/Unlabel, feature to make a column data as point labels in a graph. But I have different graphs and I need different column to be labeled on the points for each separately. If I label the column it will show up in all graph and I will have all the columns in the graph that does not really need that label.How I can separately have a column labeled in a graph and ...
Mikasa

Discussions |
Nov 12, 2020 8:33 AM

9197 views | 3 replies

Previous
Next

Latest Discussions

Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1774 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1508 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

959 views | 0 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1197 views | 0 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1480 views | 0 replies