JMP User Community

Latest Discussions

JSL Query Table: Strange result

dirLoc=Pick Directory("Select a directory", "my directory"); fileList = Files In Directory(dirLoc); dt1 = open(dirLoc || fileList[1]); dt1 << Select Where( :Amount>=1000 ); x=dt1<<Subset(Output Table Name("T1")); Close(dt1, NoSave); show(N Row(x)); x << Save("my directory\t1.jmp");Greetings!I am trying a simple query with a sample data file. The query returns right set of resu...
monir

Discussions |
Feb 6, 2024 8:54 AM

1107 views | 2 replies
Model Validation in JMP Statistical Software as compared to MODDE

Hi there, I am reaching out to seek some clarification on a feature in the JMP statistical software. In MODDE, we find a valuable capability for model validation, allowing us to scrutinize and validate the model used to run and analyze a Design of Experiments (DoE). This functionality is presented in an intuitive graphical user interface (GUI) manner, facilitating a seamless user experience Please...
PieAnteater793

Discussions |
Feb 6, 2024 7:16 AM

2949 views | 3 replies
Proper labels without stacking

Hello,how can I get proper labels for data without stacking. I cannot stack as I need to see rows dependencies, but on the other hand side need to have for each category only relevant data. I attached also the file.
MichaH

Discussions |
Feb 6, 2024 6:25 AM

4121 views | 7 replies
Where start to learn JMP 101 for data cleanup and visualization.

I see a lot of learning resources and various topics to the point that it is overwhelming, so maybe someone will be able to help me out. I have a large dataset from REDCap of about 10k people with 300-400 variables per line. I was wondering what would be the most effective way to start analyzing it. At this moment I'm not really interested in any statistical analysis, mostly just to clean it up an...
MathProductPuma

Discussions |
Feb 6, 2024 5:40 AM

3055 views | 7 replies
Model screening vs Model Comparison

I aggregated data from various DoEs into a single data matrix table. Now, I'm trying to select the best predictive model to fit my data.Which jmp platform is the best? Should I use model comparison or model screening? I'm not sure which platform suits my purpose and my data. Is there literature or a webinar I can use to understand the main differences between the two platforms? Thank you so much.
sofiasousa24

Discussions |
Feb 5, 2024 7:34 PM

2254 views | 4 replies

Previous
Next

Latest Discussions

JSL Query Table: Strange result

dirLoc=Pick Directory("Select a directory", "my directory"); fileList = Files In Directory(dirLoc); dt1 = open(dirLoc || fileList[1]); dt1 << Select Where( :Amount>=1000 ); x=dt1<<Subset(Output Table Name("T1")); Close(dt1, NoSave); show(N Row(x)); x << Save("my directory\t1.jmp");Greetings!I am trying a simple query with a sample data file. The query returns right set of resu...
monir

Discussions |
Feb 6, 2024 8:54 AM

1107 views | 2 replies
JMP import csv, shows as empty

Hi team, The table shows as empty when i choose to import through csv file. I saw couple posts before showing there is a issue with uploading with csv, just wondered if there is a workaround for this issue? Or do I have to upload through xlsx file? ThanksJason
OutputCivet4254

Discussions |
Feb 5, 2024 2:14 PM

838 views | 1 replies
Getting work week (WW) from "m/d/y h:m:s AM|PM" format

Hi,

I have a trouble to getting the work week from rows. Let's say I have a date and time format like this I tried following things by following the JSL manual @ page 150 and so forth but could not resolve this,
first I thought that I need to get rid of time values dt << New Column( "Date_new", Numeric, Continuous, Formula(Format(:Name("Date"), "m/d/y")), );Then now I have the dates like this

Next I...
joshua

Discussions |
Feb 5, 2024 12:31 PM

5550 views | 6 replies
Exporting full LCA dataset to CSV/Excel

I conducted an LCA analysis on survey questions. In the "parameter estimates" section of the generated report, there is a table. When I export it, it doesn't export the merged cells on top. For example:

Cluster 1: [Top Column: State] [AZ] [VA], [DC], [TX] It only exports the cluster, and the parameter estimates for [AZ] [VA], [DC], [TX]. I want to export every visible thing, incl...
WeightedColt463

Discussions |
Feb 5, 2024 12:18 PM

1381 views | 2 replies
Permutation test only producing one outcome

I am trying to do a permutation test to see if a group of parameters are different based on exposure. For my columns I have "Tx", "Intercept" and "Intercept Shuffled". I then do a Y by X with y = "Intercept" and x = "Tx". Based on the jump permutation test guidelines (Example of a Permutation Test (jmp.com)), after running a one way ANOVA I am able to right click the F-statistic and select simulat...
spiny11

Discussions |
Feb 5, 2024 11:51 AM

871 views | 1 replies

Previous
Next

Latest Discussions

How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...
mann

Discussions |
Jan 31, 2024 6:25 AM

936 views | 0 replies
Optimal decision tree and Adam's consensus?

Hello - First of all, I'm speaking very much as a non-statistician here. I have a paper I'm trying to replicate that is doing hierarchical clustering with multiple similarity functions and grouping methodologies, and then using an Adam's consensus to find a sort of "optimal" dendrogram, if you will. I looked at their software they were using, and its been out of comission for a good 15 years. JMP ...
ehchandlerjr

Discussions |
Jan 26, 2024 11:06 AM

744 views | 0 replies
Use Limits Table In Distributions Platform

Hi, is it possible to use a limits table to load specifications grouped by some factor in platforms other than Process Screening? Ideally I'd like to use the limits table in the distributions platform. Thanks in advance, Alicia
Alicia

Discussions |
Jan 25, 2024 8:24 AM

696 views | 0 replies
Which predictive analysis method/column organisation for RSM output with duplicate samples

Hi all. So I'm working on a project where I have 2 x component classes, each of which has 4 items within the class, which are mixed together at varying concentrations over 48 combinations. Figured the best Factor way to do this was to use 2 x Continuous for the max/min concentrations for each class, then 2 x 4-level Categoricals for each of the items. Each of the combinations was made twice, so af...
ProbitLeopard63

Discussions |
Jan 25, 2024 3:06 AM

726 views | 0 replies
how to show "nonparametric overlay" in the output of "Fit life by x"?

I tried to do “Fit life by X” (fit TTF by voltage), but in the output, somehow “nonparametric overlay” did not show up. I was hoping to see the probability of failure vs time at 80V, 50V, and 15V (use condition), but that plot was not included in the output. I attached the report here. If anyone can take a look and point out went wrong, that would be great. Thank you!
RenZ

Discussions |
Jan 22, 2024 10:02 AM

580 views | 0 replies