Welcome to the JMP User Community!
Ask questions, get answers, meet other JMP usersLearning Resources
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesLatest 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
533 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
5120 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
752 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
6587 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
362 views | 2 replies
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...
752 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
768 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
5935 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
6184 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
1922 views | 18 replies
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
356 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
303 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
301 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
288 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
232 views | 0 replies
JMP Events
-
ChinaShanghai May 29
-
12:00PM - 1:00PM EDTMar 20JMP for Teaching Data Analytics Courses
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-for-data-analytics-course...
-
1:00PM - 2:00PM EDTMar 21Getting Started with JMP
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
-
1:00PM - 2:30PM EDTMar 26Jump into Gauge Studies: Hands-On Workshop
Jump into Gauge Studies Wednesday, March 26 | Live Web Workshop1:00 p.m. – 2:30 p.m. ET Hoste...
-
1:00PM - 3:30PM MDTMar 27In-Person Colorado JMP Users Group Meeting
Seats are limited to 30 attendees, so register now to save your spot. Date: M...
