JMP User Community

Latest Discussions

JSL rename columns based on user selection

I am trying to rename column names based on user selection of file. But, I am having trouble renaming the columns. I have added my code, the set name doesn't work for renaming. I think I am doing something wrong. Can anyone please let me know about this?Clear Log(); dt1_dir = Pick Directory( "Select directory for data table 1" ); dt1_Name = Pick File( "Select data file 1", dt1_dir, {"JMP Files|jmp...
shasha_2

Discussions |
Feb 2, 2022 6:04 AM

1336 views | 2 replies
Need help in determing what data should be threated as random in a repeated measurements

Hi.Can someone help me with this one or verify that I am on good path here? I have data in a long format that contains month (from january till march), day of the month (from 1 till 31), shift (from 1 till 3), total energy consumption within shift (this is dependent variable) and working time in hours of 12 different systems (machines) within a shift (from 0 till 8 hours). I want to find out energ...
MachineHippo109

Discussions |
Feb 2, 2022 2:35 AM

2416 views | 7 replies
How to get the confidence interval (CI ) and to make t-test with multi distributions in one histogram (as direct input data)?

Input data is already the histogram in %. There are 5 samples in total. Each sample include 2 distributions (bottom and top position). The goal is to calculate the difference between the 2 means (physically, it´s an height). Raw data (´´CI_t test_data_Q12345.jmp´´) is attached.Questions:How to obtain the statistics for each distribution (bottom and top position)?How to deduce the statistics for h...
Kate

Discussions |
Feb 2, 2022 2:22 AM

4517 views | 10 replies
Refitting a lasso regression at single penalty

Scenario: I use validation data to tune my lasso penalty and now I want to refit to all of my data (training + validation) specifying that optimized penalty term. I can't see anyway to do that within the generalized regression platform. What is recommended here?
Mittman

Discussions |
Feb 1, 2022 1:14 PM

2704 views | 4 replies
Cookie Consent issue

Hi All, when attempting to open the html code of a webpage i only get the Cookie Consent text rather than the page content. For example, being in the UK and attempting to open the jmp homepage this is what i get: //:*/ Page = open("https://www.jmp.com/"); /*: String( "<html><hea... 2588 total characters ...></html> " ) assigned. //:*/ print (Page); /*: "<html><head><script type=\!"text/jav...
ron_horne

Discussions |
Feb 1, 2022 11:14 AM

1641 views | 4 replies

Previous
Next

Latest Discussions

Need help in determing what data should be threated as random in a repeated measurements

Hi.Can someone help me with this one or verify that I am on good path here? I have data in a long format that contains month (from january till march), day of the month (from 1 till 31), shift (from 1 till 3), total energy consumption within shift (this is dependent variable) and working time in hours of 12 different systems (machines) within a shift (from 0 till 8 hours). I want to find out energ...
MachineHippo109

Discussions |
Feb 2, 2022 2:35 AM

2416 views | 7 replies
Refitting a lasso regression at single penalty

Scenario: I use validation data to tune my lasso penalty and now I want to refit to all of my data (training + validation) specifying that optimized penalty term. I can't see anyway to do that within the generalized regression platform. What is recommended here?
Mittman

Discussions |
Feb 1, 2022 1:14 PM

2704 views | 4 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

587 views | 0 replies
Making heat map- How do I define the values for each color in the gradient?

So I am making a heat map, and my color gradient goes from green, to black in the center, to red. I would like to customize my gradient so that the black extends from exactly -1 to +1. My data set range is -2 (green) to 7 (red). So with me wanting the black area to extend from -1 to +1, this makes the gradient lopsided with the red area being much longer, which is fine. But since it is lopsided to...
ClusteredMining

Discussions |
Feb 1, 2022 8:34 AM

2105 views | 3 replies
DF and Lost DFs

Good evening all,I have this error has shown in the image attached especially for effect of species in the image which shows zero. I have looked at previous questions addressing this but it doesn't seem to clarify my issue. Why would it recognise a Nparm but fail to recognise the DF? Also, why the Lost DFs error?
Gabriel

Discussions |
Jan 31, 2022 3:48 PM

1762 views | 2 replies

Previous
Next

Latest Discussions

How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

587 views | 0 replies
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

789 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

911 views | 0 replies