JMP User Community

Latest Discussions

Can we use Recode to classify values as missing values

1)I want to classify negative values as missing values. Can we use Recode to accomplish this. If yes, how can we do it? I can create a new formula column while using Recode. I see it as a two step process. I was wondering if this could be accomplished in a single step.2) If we use data filters, can recode be used in the subset of the filtered data with out affecting the rest.
SymS

Discussions |
Jan 31, 2022 7:44 AM

2222 views | 4 replies
How to analyze a 4x4 Latin square design?

Hello. I am new to JMP. I am still figuring out how to do Latin square designs here. I cannot find any intuitive tutorials here or even in youtube. Here is my sample data ( I got this from Latin square design in R tutorial in Google):

My treatment of interest is the varieties and row and column are your blocking variables.
RonnieOmics

Discussions |
Jan 31, 2022 7:39 AM

2895 views | 4 replies
Unequal Variance Log Normalization

Hi,

Why is the unequal variance not in log normalized numbers similar to the ANOVA? I want to test if the log normalized standard deviations are similar between my subjects:
MikeDereviankin

Discussions |
Jan 31, 2022 7:29 AM

949 views | 1 replies
JSL code: convert jmp file to csv file

Hi, I am trying to convert JMP file into csv file. It converts the file into csv, but I had a doubt. Is there a way to convert two file into two different csv files at once where both the file paths are given. Here is my code where I am able to save dt as csv but I don't know how to save dt1 as csv file :dt = Open("$SAMPLE_DATA/big class.jmp"); dt1 = Open( "$SAMPLE_DATA/semiconductor capability.jm...
shasha_2

Discussions |
Jan 31, 2022 6:03 AM

1796 views | 1 replies
how do I write a script to compute confidence intervals

Hi - I am still new at jsl scripting and am trying to write a script that creates and saves four new columns based on my linear regression fit:- lower 95% mean confidence interval- upper 95% mean confidence interval- lower 95% individual confidence interval- upper 95% individual confidence intervalobj = Fit Model( Y( :LOG_ECOLI_PEAR ), Effects( :LOG_TURB_PEAR_FNU), Personality( "Standard Least...
learning_JSL

Discussions |
Jan 31, 2022 4:40 AM

1934 views | 2 replies

Previous
Next

Latest Discussions

How to analyze a 4x4 Latin square design?

Hello. I am new to JMP. I am still figuring out how to do Latin square designs here. I cannot find any intuitive tutorials here or even in youtube. Here is my sample data ( I got this from Latin square design in R tutorial in Google):

My treatment of interest is the varieties and row and column are your blocking variables.
RonnieOmics

Discussions |
Jan 31, 2022 7:39 AM

2895 views | 4 replies
Unequal Variance Log Normalization

Hi,

Why is the unequal variance not in log normalized numbers similar to the ANOVA? I want to test if the log normalized standard deviations are similar between my subjects:
MikeDereviankin

Discussions |
Jan 31, 2022 7:29 AM

949 views | 1 replies
Data Filter Limit Selectable Items without Excluding Rows

In JSL, is there a way to only show certain items from a particular column? For instance, say I have a data table with a column called "Color". That column of data is filled with "Blue", "Yellow", "Red", "Orange" values. I want to show a Local Data Filter where the only options for the user are "Yellow" and "Red" (meaning the user of the dashboard would not even know that "Blue" and "Orange" we...
Martin

Discussions |
Jan 28, 2022 9:24 AM

1590 views | 3 replies
Fit Line automatically to data table

Hello, I would like to use the Fit Line function in JMP to automatically save the equation to my data table. The catch is that I need to do this hundreds of times, so the "Save Predicteds" option isn't very feasible. What would be the easiest way to write bivariate formula in the data table that would calculate it automatically? I am somewhat limited to the formula builder in JMP since I don't kn...
ndowidar

Discussions |
Jan 28, 2022 7:56 AM

4575 views | 6 replies
How can i add design constraints to modelling

Hello JMP Community, I have a custom DoE with a linear constraint (Disallowed: factorX > factorY). However I can not add this contraint when modelling my data. This results in predictions including factorX > factorY.Apparently the constraints can be modified in the modelling dialog as seen in picture 1. However I do not have this option (see picture 2).Any tips how to access this?
JaNeu

Discussions |
Jan 28, 2022 6:44 AM

1823 views | 3 replies

Previous
Next

Latest Discussions

Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1390 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

786 views | 0 replies
How do I apply time fixed effects with multiple regression

I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function only available in SAS? Thanks
RiDe

Discussions |
Jan 10, 2022 11:18 PM

699 views | 0 replies
separating labelled values from graph points

I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...
Cdougz

Discussions |
Dec 31, 2021 7:38 AM

907 views | 0 replies
Expand Contours

Hi,

I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks!
MikeDereviankin

Discussions |
Dec 15, 2021 12:49 PM

707 views | 0 replies