JMP User Community

Latest Discussions

Data Filter - Selecting all when there is no alternative value to where does not equal statement (=!)

Looking for some help to understand the behavior or a better way to script this.

Writing a script to catch exceptions in the data. When version is GP but active is not X.Names Default To Here( 1 ); dt = Current Data Table(); df = dt << Data Filter( Location( {138, 181} ), Add Filter( columns( :Active, :Version ), Where( :Active != "X" ), Where( :Version == "GP" ) ) );Then the rest of the s...
BSwid

Discussions |
Apr 17, 2019 10:00 AM

7100 views | 6 replies
loop and concatenate

I need to create a new column which is a concatenate of a set of column I just hard code the column name as below ... new column("Code","character",
formula(:deliver || :func_groupa || :func_groupb_h || :func_groupb_l || :micro firmware load
|| :micro module build || :micro setup)
); however, I want to create a script that can get the number of column from that input file and start concatenate the va...
yanee

Discussions |
Apr 17, 2019 9:59 AM

6049 views | 2 replies
new column with all value set to zero

Hi
how can I create a new numeric column with all values are zero and not empty?

thanks!
AdamChoen

Discussions |
Apr 17, 2019 9:23 AM

10847 views | 5 replies
How to get path and save as .jmp

Hi. I am still new with JMP. I am greatly appreciate if anyone could help me with this problem. I want to open .csv file. Then get the path of that .csv file and then save that .csv file as .jmpI use:files = Open(); // from here i can open my .csv filefiles << get path; // tried to get the path using this code but this doesnt give me the path Anyone can please help me? Thank you so much
AY

Discussions |
Apr 17, 2019 2:08 AM

6610 views | 2 replies
RE: Importing a CSV File Into JMP & Turning it Into a Data Table

Hi, This must be a very simple question but there is a lack of documentation so I was struggling with how to import CSV files into JMP and save them as data tables? Any help would be appreciated.
Jaz

Discussions |
Apr 17, 2019 12:29 AM

24032 views | 5 replies

Previous
Next

Latest Discussions

Chi square or Cochran's Q test

Okay, so i have to decide whether i should use chi-square or Cochran's Q test for one of my study.If i assume meat as experimental unit (EU) and impose 6 different wood smoke (like apple smoke, cedar smoke, hickory smoke etc.) on EU and consumers (people) act as observational unit (OU). I have 10 consumers and each one will taste each treatment (6 treatments) and respond liking (9 point scale), an...
sharmachetan

Discussions |
Apr 16, 2019 3:54 PM

3031 views | 0 replies
using loop to display a tab box inside a tab box

Hi guys , I am trying to display a tab box inside a tab box using loop Below is my code , however it does not allowa me to use array , only variablee allowed . New Window( "Result", display = Tab Box() ); For( j = 1, j <= N Items( stepname ), j++, step = Substitute( Char( stepname[j] ), "DataTable(\!"Specname=", "" ); display << Add( step, main[j] = Tab Box( ) );
kuannygoh

Discussions |
Apr 16, 2019 1:23 AM

3477 views | 1 replies
Graph Builder composite graphs

In Graph Builder, I would like to create a composite graph consisting of four panes in a 2x2 arrangment. I'd like each of the panes to have a different y-axis, whereas both have the same x-scale. I can get to 2 rows x 1 column with overlays.But when I double up the x axis, I'd like the overlay to go away, so I just have a single parameter in each pane. Instead I get this:
Is there a way to get 2 x...
john_madden

Discussions |
Apr 15, 2019 2:54 PM

5278 views | 2 replies
Script to ask for and save user input which is used in another table

I want to create a script that asks the user for character and numerical input, which is then saved in a skeleton table and referenced by another table which uses that values for calculations - Please. I can do all the seperate tasks like create a window/table/text box/calculations but I can't make them work together.
Idk

Discussions |
Apr 15, 2019 4:55 AM

5326 views | 5 replies
Variance Components & Spec Setting

Hello all, I am trying to set a bias specification for samples run on an ELISA test involving calibrations. I know I get calibration to calibration and run to run (within calibration) variation in the observed bias when I run, say, 20 samples. I want to explore both cal to cal and run to run variation and use the info to set an appropriate spec. I am having trouble finding a resource to read up ...
BigJasonB

Discussions |
Apr 12, 2019 9:46 AM

3857 views | 2 replies

Previous
Next

Latest Discussions

Chi square or Cochran's Q test

Okay, so i have to decide whether i should use chi-square or Cochran's Q test for one of my study.If i assume meat as experimental unit (EU) and impose 6 different wood smoke (like apple smoke, cedar smoke, hickory smoke etc.) on EU and consumers (people) act as observational unit (OU). I have 10 consumers and each one will taste each treatment (6 treatments) and respond liking (9 point scale), an...
sharmachetan

Discussions |
Apr 16, 2019 3:54 PM

3031 views | 0 replies
Selecting Number of Clusters in Hierarchical Clustering

One way to select possible number of clusters in hierarchical methods is to identify the relatively large changes in distance as number of clusters change (see table below). When I look at the actual distance measure from the table (clustering history below dendogram), there is a bigger jump from 3 clusters to 4 than from 4 to 5 (smaller), suggesting 4 may be the right decision. However, when you ...
pratyushdash

Discussions |
Feb 23, 2019 5:51 PM

3090 views | 0 replies
Beta Generalized Regression and adjusted chi-square values

I have a data set from a two-choice rodent feeding trial. We were testing the effectiveness of 10 deterrents by coating them on seeds and offering them to rodents alongside control seeds that were uncoated. The explanatory variable is which of the 10 deterrents the treatment seed was coated with, and the response variable is the proportion of control seed and treatment seed consumed. The question...
Mananahi

Discussions |
Feb 13, 2019 9:58 AM

2376 views | 0 replies
DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

4096 views | 0 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3412 views | 0 replies