JMP User Community

Latest Discussions

Formula application

IF(MONTH(A151)=MONTH(A150),NA(),COUNTIF(W151:W181,1)*100/(COUNTIF(W151:W181,1)+COUNTIF(W151:W181,0))) . This is a formula applied in excel to create a new column, where Column A has date & column W contains only 0 & 1 as values. How to apply this same formula in JMP if we have columns A & W values.
Chitranshu

Discussions |
Apr 2, 2024 7:28 AM

1373 views | 6 replies
to connect to database through SQL

HelloI would like to connect to the database through an SQL query.I have written the JSL script dt = Open Database (
"DRIVER = {SQL Server};
SERVER = HAISQLC162\HAISQLC162,3187
UID = hw_tests_viewer
PWD = ********
DATABASE = HW_Chip_Tests;"
,
"SELECT * FROM [HW_Chip_Tests].[...
Dennisbur

Discussions |
Apr 2, 2024 5:59 AM

1539 views | 2 replies
Crow-AMSAA Confidence Intervals - Delta Method

Hello, I am using JMP 16.2.0 to calculate Reliability Growth and am trying to understand the math behind the profiler confidence intervals on the Crow AMSAA models. The help article states that: "The delta method is applied to this expression to obtain an estimate of its variance. This estimate is used to construct a 95% Wald-based confidence interval. The resulting confidence limits are then tran...
Reliability_JPL

Discussions |
Apr 2, 2024 5:47 AM

1140 views | 3 replies
Multiple File Import Auto-Naming Data Table

Hello All, I'm writing a script where I start with a 'multiple file import' of a folder of .csv files. I will periodically be getting new .csv files that I would like to add. These files have a series of letters and numbers (i.e chghistory0857-786.csv, chghistory0956-783.csv, chghistory1008-805.csv, etc). The issue I'm running into is when I run the 'multiple file import' script, JMP creates a dat...
gregpearce

Discussions |
Apr 1, 2024 4:57 PM

5708 views | 11 replies
How to choose heredity rules in definitive screen

Hi, When performing a DSD, you are given the option for applying rules of "obeys strong heredity" for quadratics, and for interactions. I believe that this limits the model and allows only for interactions that contains both as main effects. I'm not positive how this works for quadratics unless it only allows for quadratics that are found to have a main effect as well. When evaluating your DSD, ho...
MetaLizard62080

Discussions |
Apr 1, 2024 12:00 PM

1288 views | 5 replies

Previous
Next

Latest Discussions

Formula application

IF(MONTH(A151)=MONTH(A150),NA(),COUNTIF(W151:W181,1)*100/(COUNTIF(W151:W181,1)+COUNTIF(W151:W181,0))) . This is a formula applied in excel to create a new column, where Column A has date & column W contains only 0 & 1 as values. How to apply this same formula in JMP if we have columns A & W values.
Chitranshu

Discussions |
Apr 2, 2024 7:28 AM

1373 views | 6 replies
How to choose heredity rules in definitive screen

Hi, When performing a DSD, you are given the option for applying rules of "obeys strong heredity" for quadratics, and for interactions. I believe that this limits the model and allows only for interactions that contains both as main effects. I'm not positive how this works for quadratics unless it only allows for quadratics that are found to have a main effect as well. When evaluating your DSD, ho...
MetaLizard62080

Discussions |
Apr 1, 2024 12:00 PM

1288 views | 5 replies
Help about sample size calculation

For my study, the primary endpoint is to determine the proportion of patients who experience a beneficial effect after receiving the treatment. We have established a null hypothesis proportion (퐻0) of 0.5, indicating our expectation that approximately 50% of the patients will exhibit a beneficial response to the treatment post-intervention. This figure serves as a clinically relevant cut-off point...
thiennguyen

Discussions |
Apr 1, 2024 9:11 AM

3627 views | 16 replies
dt: image - missing?

What is the correct way to check if an image in a data table is missing?... and why is there a difference between the column formula and the JSL questionis missing(:pet[5]) Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); dt[[4],"pet"]=.; New Column( "is missing",Formula( Is Missing( :pet ) )); New Column( "is empty", Formula( Is Empty( :pet ) )); New Column( "is nu...
hogi

Discussions |
Mar 31, 2024 8:45 AM

874 views | 3 replies
Can I add error values to a response variable in Custom DOE?

Hi there, I'm working with Custom DOE, and I've collected data for my response variable that I want to input to generate a model. I've also collected data on the error associated with the measurement of that response variable (for each data point) and I was wondering if there is a way to take this error into account. I haven't been able to find any details on this so I figured I'd ask here -- I'm ...
audrey1

Discussions |
Mar 31, 2024 4:33 AM

720 views | 2 replies

Previous
Next

Latest Discussions

Multiple imputation of ordinal data

HiWe're doing a study regarding whole number ordinal data, answers being 0 to 4. It probably being MAR and not knowing the probability of each response, made us wonder how to do multiple imputation of this data. A post showed:go to analyze > consumer research > categorical But we're stuck...Thank you in advance!
CovariateFilter

Discussions |
Mar 28, 2024 10:00 AM

472 views | 0 replies
How to categorize the same ID in row with other columns?

Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...
doraemengs

Discussions |
Mar 25, 2024 9:12 PM

651 views | 0 replies
LCA appears to treat ordinal variables as nominal

When I run cluster analysis --> LCA with ordinal variables (numeric, ordinal), the probability formula appears to be treating the variables as nominal, rather than ordinal. For each variable, there are 5 levels (i.e., 1-5). If being treated as ordinal, wouldn't the probability formulas reflect an order for each level where 1 may have the smallest probability and 5 the largest? As you can see below...
AutoMethodsBee1

Discussions |
Mar 25, 2024 12:41 PM

406 views | 0 replies
RSS, TSS, precent of residual sum of squares

Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?
gholamhasantey

Discussions |
Mar 25, 2024 3:29 AM

656 views | 0 replies
Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...
sm3001

Discussions |
Mar 21, 2024 12:49 AM

571 views | 0 replies