JMP User Community

Latest Discussions

How to add Continuous Count row with IF statement

Hi Expert, How can I add a new column (D) that able to add count row IF "CompareSeqVsAlarmDP" is 1 in sequence using JSL?I can reproduce this condition in Excel using IF statement : IF((C27=0),0,(C27+D26)).But still unsuccessful to convert the IF condition in JMP. I think something wrong with my IF statement. My JSL statement is as below:dt1:New Column << Set Formula(If(:"CompareSeqVsAlarmDP=z"n =...
WebDesignesCrow

Discussions |
Dec 7, 2023 5:27 PM

2104 views | 2 replies
Mindset when interpreting mixed model results

Hello, I have recently been exploring the use of mixed models as opposed to simpler fixed effects models. I have a few questions that I haven't found clear answers to by reading documentation. 1. What exactly are the variance components of the random effects?Assuming the mixed model is: Mixed model: Response = intercept + fixed effects + random effects + residual error- If I understand correctly, ...
QW

Discussions |
Dec 7, 2023 4:43 PM

2409 views | 3 replies
How to optimize factors with uncertainty in 1 step with JMP?

Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example:
Marco2024

Discussions |
Dec 7, 2023 1:02 PM

9738 views | 25 replies
JSL function with SQL Join pulling data rows 3 times compared to one without JOIN -why?

The first function below with SQL INNER JOIN pulls each data rows (for LNo) two additional times from the database compared to the second function below without JOIN. Where am I going wrong? Names Default To Here( 1 ); opnDtb = Function( {R, M, T}, {dtm}, dtm = Open Database( "Driver=SQL Server; Server=ABCD-EFGH; DATABASE=myDB; Trusted_Connection=Yes;", "SELECT SM.[LNo], SM.[TestDate] A...
Neo

Discussions |
Dec 7, 2023 9:59 AM

1032 views | 1 replies
how to understand the relationship between different predictors

From a large car data set, a company would like to have a tool to predict prices for used cars. Therefore they first need to understand the relationship between different predictors (independent variables) and the used cars price.For the following questions we assume that the price is determined by a number of predictors contained in the dataset.Investigate which continuous predictors have an infl...
BaggingSpaces55

Discussions |
Dec 7, 2023 9:20 AM

1539 views | 3 replies

Previous
Next

Latest Discussions

Mindset when interpreting mixed model results

Hello, I have recently been exploring the use of mixed models as opposed to simpler fixed effects models. I have a few questions that I haven't found clear answers to by reading documentation. 1. What exactly are the variance components of the random effects?Assuming the mixed model is: Mixed model: Response = intercept + fixed effects + random effects + residual error- If I understand correctly, ...
QW

Discussions |
Dec 7, 2023 4:43 PM

2409 views | 3 replies
How to optimize factors with uncertainty in 1 step with JMP?

Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example:
Marco2024

Discussions |
Dec 7, 2023 1:02 PM

9738 views | 25 replies
how to understand the relationship between different predictors

From a large car data set, a company would like to have a tool to predict prices for used cars. Therefore they first need to understand the relationship between different predictors (independent variables) and the used cars price.For the following questions we assume that the price is determined by a number of predictors contained in the dataset.Investigate which continuous predictors have an infl...
BaggingSpaces55

Discussions |
Dec 7, 2023 9:20 AM

1539 views | 3 replies
Help with using a SQL stored procedure to pull data using JSL

Good evening, I'm a beginner to JSL. I think suspect that I have a syntax error or something. I'm trying to run an SQL stored procedure from a JSL script. My database connections seem to work correctly (see when the query is a select statement). However, I can't get the stored procedure to run and give me the data table. Below I've listed: 1) the query formula that works (the select stat...
PleaseRecycle

Discussions |
Dec 7, 2023 7:40 AM

2274 views | 2 replies
New data added in excel - how to refresh in JMP

My source data is in excel. I created a script to import the data with wizard into JMP and then further scripts do many things in JMP, ultimately creating graphs. And the scripts re-run just fine as long as I just look at the original data. But when I add new rows in the excel and run the scripts, the new data is not included there. I just see the same data that was in the excel when I created the...
Markn

Discussions |
Dec 7, 2023 5:30 AM

10211 views | 24 replies

Previous
Next

Latest Discussions

Vector Modeling and Related Analysis Capabilities

hello JMP team , I am curious to learn more on the vector data type modeling and any associated analysis on that . Are there examples of sample vector datasets ? Once such dataset exists, could clustering techniques work on them and how would they work specifically ?I assume they would at the very least extract statistical aggregation from each vector and use these for clustering. Is there any mo...
altug_bayram

Discussions |
Dec 1, 2023 2:30 PM

824 views | 0 replies
Dendrograms in JMP: show scale, show categories without the categories dendrogram and setup UPGMA+dice as statistics.

HiDoes anybody know how to get the scale of the dendrograms? Scale can be setup in different ways, but it is not shown by default in the output.Does anybody know how to get the categories labels shown without performing the categories dendrogram?Does anybody know how to perform Dice+UPGMA dendrograms? Those are basics statistics, and I can’t find them.Thank you very much if someone helps JMP 17.2....
JRTormo

Discussions |
Nov 29, 2023 2:41 AM

1132 views | 0 replies
Keyboard shortcuts

[More Topic Containers like this] Jmp Help/Keyboard Shortcuts assign new Keyboard ShortcutsAssigning-keyboard-shortcuts-for-frequently-used-options comment/uncomment blocks of code (international keyboard)A shortcut can be set in the menu customization Editoradd keyboard shortcuts for your own functionsadd them to the main menu/ to a toolbar and assign a shortcutadd keyboard shortcuts for "open...
hogi

Discussions |
Nov 26, 2023 1:38 AM

998 views | 0 replies
When the neural network of JMP is operated in Python, the value is different.

When the neural network created by JMP was saved and run in python code, it output values different from the score output by JMP.

OS：windows 10Python Version : 3.9

File list jmp_score.py
CNN_NTanH_boost.py <- JMP Python
mypython_code.py

import CNN_NTanH_boost
import numpy as np
import pandas as pdfilepath = r"filepath" ext = 'csv' if filepath.endswith(ext): df=pd.read_csv(filepath) else : df=pd....
TShiino

Discussions |
Nov 21, 2023 8:48 PM

831 views | 0 replies
Could JMP optimize factors with uncertainty?

Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example:
Marco1

Discussions |
Nov 21, 2023 9:08 AM

786 views | 0 replies