JMP User Community

Latest Discussions

変数に格納されたリストを、Control Chart BuilderのYの列に読み込む複数のカラム名として定義したい。

表題を実現するJSLスクリプトの書き方を考えています。使用するJMPのバージョンは18を利用しています。 dt02=current data table(); //列名を変数に columnNames = dt02 << Get Column Names; //３列目以降の列はすべてトレンドを確認するために必要 columnNames2={}; For( j = 3, j <= N Items( columnNames ), j++, Insert Into( columnNames2, Column( columnNames[j] ) ); ); //X-bar_and_S_chart作成 grp01=dt02<<Control Chart Builder( Variables( Subgroup( :lotno), Y(...
rice_ball

Discussions |
Dec 25, 2024 2:00 PM

1213 views | 4 replies
How Do I create a Column formula for N Categories?

I would like to create a column formula that provides a count of the number of distinct values in a column. I can use the Column viewer, Show summary function in JMP 15 but I want to have that value in a column for use in other calculations. For example in the Big Class Table - N Items in column "Sex" should show 2 as 2 distinct values.
trish_roth

Discussions |
Dec 25, 2024 9:56 AM

7079 views | 14 replies
How to evaluate Alias structures in D-optimal DOE?

My understanding is that D-optimal designs can be good for screening experiments, but you'd better hope there aren't any large interaction effects, otherwise they will bias your main effects, or that you should add some suspected 2-way interactions to your optimal design as a way to avoid aliasing effects. I've been told to avoid Res III fractional factorials, & Plackett-Burman designs for screen...
mjz5448

Discussions |
Dec 25, 2024 7:56 AM

1580 views | 5 replies
Bypass Excel Import Wizard in script

I am trying to open a .xslx file from within an JMP application when the "OK" button of an application window is pressed. My problem is I'm finding it hard to bypass with Excel wizard window and just open directly. I want the file to open in JMP using the Excel options I specify in an Open() statement. To get my Open() statement options correct, I opened the file manually and copied the Open() sta...
john_madden

Discussions |
Dec 24, 2024 6:13 PM

7868 views | 10 replies
Unable to do rare events T-Chart; restricted by number of rows

Data set with 300 rows. A column with time between events. Control chart builder doesn't let choose rare events, e.g. T Chart. Only when deleting rows (not just hide & exclude) leaving about 25 rows can rare event be selected.Many thanks,
RonB

Discussions |
Dec 24, 2024 4:00 AM

670 views | 2 replies

Previous
Next

Latest Discussions

How to evaluate Alias structures in D-optimal DOE?

My understanding is that D-optimal designs can be good for screening experiments, but you'd better hope there aren't any large interaction effects, otherwise they will bias your main effects, or that you should add some suspected 2-way interactions to your optimal design as a way to avoid aliasing effects. I've been told to avoid Res III fractional factorials, & Plackett-Burman designs for screen...
mjz5448

Discussions |
Dec 25, 2024 7:56 AM

1580 views | 5 replies
How to receive messages from windows using JSL of JMP software?

My operating system is 64-bit Windows 10. Thanks Experts!
GeneratingKappa

Discussions |
Dec 23, 2024 11:13 PM

1532 views | 6 replies
How Can I get a list of sheets in an Excel workbook ?

I have a situation where I am opening Excel sheets using Open Database().This has been a good way to do it since I want specific columns from specific sheets, so using an SQL SELECT statement is ideal.I am now discovering there is no standardization on the sheet names. So what I want to do is query the Excel workbook and get a list of sheets in it. I can then use some logic in my code to decide wh...
tsl

Discussions |
Dec 23, 2024 7:07 PM

7156 views | 7 replies
Automate opening an hdf5 file

Hello, I am trying to create a .jsl script that will import the hdf5 files from Tensorflow, identify how many files are there (kernels + bias) and save them as datatables to then translate it to a form readable and usable as a surrogate by JMP. The way I am opening the datatables so far is very manual; I use Open( "filename.h5", {"list_of", "dataset_names"}); to import all the dataset names. Ho...
ekallou3

Discussions |
Dec 22, 2024 12:37 PM

8002 views | 12 replies
How to identify mins of maxes across data groups

Suppose I took all the students in Big Class and put them in groups by gender and age, e.g. 12yo boys in one group, 12yo girls in another, etc. With that setup, I'd like to create a formula column that has a 1 if that group has the shortest maximum height for their age across both genders, and a 0 otherwise. For example, in this data: GroupNameHeightNEW COLUMN12yo GirlsKATIE590 JANE550 JACLYN660 L...
BHarris

Discussions |
Dec 20, 2024 8:18 AM

3929 views | 18 replies

Previous
Next

Latest Discussions

ods output "DIFFS" in proc mixed

Hi everyone,for my proc mixed I already got a table with Least-Squares Means, ods output "lsmeans".Additionally, I would like to have a table for the differences, ods output “DIFFS”.Can anyone tell me how to get to this output in the current jmp version (18.1.0)?Thanks in advance for your support.
lvierbaum

Discussions |
Dec 12, 2024 5:32 AM

586 views | 0 replies
Sample size for Reliability Life Test

I have used the interval explorer for parametric reliability life test planning for sample size calculation of accelerated life test. Please can someone confirm if the sample size returned is the total sample size or sample size per stress levels? Assuming I have 3 temperature levels, do I use 75 samples per temperature level or 25?
EngrAkin

Discussions |
Dec 11, 2024 7:11 AM

543 views | 0 replies
Optimizing Enterprise Server Connections in JMP Live

Hello JMP Community,I’ve recently started using JMP Live to share and collaborate on statistical analyses with my team, and I’m encountering some challenges managing connections to our enterprise server. Our organization uses a centralized server to store and process data, and while the integration with JMP Live is robust, we’ve experienced occasional delays when syncing large datasets or during s...
Harry_Cmary

Discussions |
Dec 9, 2024 10:03 PM

475 views | 0 replies
Pressure Test Method Results have a significant effect on my sample size and capability, how to avoid?

Hello dear JMP community I will first explain the test method (no need to comment on whether it is right or wrong because this is what I got). The purpose is to detect a leakage.

Measurement processPart is mounted to a pressure stationPressure station rotate a vacuum pump x times to create a vacuum (atmospheric pressure is approx. 1000mbar)Pressure p1 is sampled at time t1After 15 seconds p2 is sam...
qLienceStats

Discussions |
Dec 5, 2024 11:58 PM

411 views | 0 replies
help to get R squared predicted

Hello!I installed a script from a community response regarding the calculation of R²pred, as shown in the image below (I'm using JMP 18 pro): (link da resposta do @erich_gundlach https://community.jmp.com/t5/JMP-Add-Ins/Predicted-R-square-calculator/ta-p/39927) In PRESS, R²pred didn't appear. (Press is low because I haven't reduced the model yet, don't worry =)) I really need to show these R²pre...
ivanpicchi

Discussions |
Dec 4, 2024 10:21 AM

481 views | 0 replies