JMP User Community

Latest Discussions

JMP equivalent of Excel's SUMPRODUCT function

Is there a JMP equivalent of Excel's SUMPRODUCT function? E.g., suppose I have a table like this: RowSetRunProbabilityValueWeighted Value1A10.27.5 2A20.814.2 3B10.3518.1 4B20.6525.9 ... I would like to add a function to the "Weighted Value" column that would populate Rows 1 and 2 with (0.2*7.5+0.8*14.2), and Rows 3 and 4 with (0.35*18.1+0.65*25.9). I imagine it would look something like: SUMPROD...
BHarris

Discussions |
Mar 6, 2024 8:20 AM

1572 views | 2 replies
Mortality Data Analysis

I may be overthinking this but I am looking for a way to analyze feeding assay response data. I had two groups, Control and Treated. I had 50 samples in each control and treated groups. I took mortality responses at 48 hours and categorized by either alive (A) or dead (D). I am trying to show the correct statistical significance of how many were alive in the treated group after 48 hours thereby no...
KIrishGH

Discussions |
Mar 6, 2024 3:07 AM

806 views | 1 replies
How do I perform a 2-sample Hotelling's T-square test in JMP?

I'm trying to compare multiple different product specs or variables (k = between 2 different groups. I can't find a way to compare those multiple factors between the 2 groups easily in JMP right now using the 2-sample Hotelling's T-square test. I'd also like to know if JMP can then create the CIs if we reject the Hotelling's T2 test statistic and also review the profile plots?
mjz5448

Discussions |
Mar 5, 2024 5:09 PM

3483 views | 7 replies
XGBoost add-in doesn't save profiler

Hi All, Running JMP Pro 17 on a Windows 11 machine. I just noticed a strange behavior with the XGBoost add-in: when saving the script to the data table, if you have added the Profiler option to your analysis, the XGBoost platform doesn't save that you've activated this option. All the other modeling platforms will remember that you've added Profiler to your analysis. Is this intentional or i...
SDF1

Discussions |
Mar 5, 2024 11:22 AM

766 views | 1 replies
Outline Box with title and image and other details

Hello guys,I am trying to create a journal which is exported into ppt later (adding just the snippet of code)obpic = OutlineBox("Page "|| char(pageno), OutlineBox("Title of Presenation",(PictureBox(tmpic))) );
obpic << journal;jjrn <<Save Presentation("$TEMP/saveppt.pptx", Outline Titles("BottomRight"), "PNG"); when i perform this i get title at top and page number at bottom which is perfect. But a...
ComplexNerd

Discussions |
Mar 5, 2024 5:44 AM

1322 views | 2 replies

Previous
Next

Latest Discussions

Mortality Data Analysis

I may be overthinking this but I am looking for a way to analyze feeding assay response data. I had two groups, Control and Treated. I had 50 samples in each control and treated groups. I took mortality responses at 48 hours and categorized by either alive (A) or dead (D). I am trying to show the correct statistical significance of how many were alive in the treated group after 48 hours thereby no...
KIrishGH

Discussions |
Mar 6, 2024 3:07 AM

806 views | 1 replies
How do I perform a 2-sample Hotelling's T-square test in JMP?

I'm trying to compare multiple different product specs or variables (k = between 2 different groups. I can't find a way to compare those multiple factors between the 2 groups easily in JMP right now using the 2-sample Hotelling's T-square test. I'd also like to know if JMP can then create the CIs if we reject the Hotelling's T2 test statistic and also review the profile plots?
mjz5448

Discussions |
Mar 5, 2024 5:09 PM

3483 views | 7 replies
XGBoost add-in doesn't save profiler

Hi All, Running JMP Pro 17 on a Windows 11 machine. I just noticed a strange behavior with the XGBoost add-in: when saving the script to the data table, if you have added the Profiler option to your analysis, the XGBoost platform doesn't save that you've activated this option. All the other modeling platforms will remember that you've added Profiler to your analysis. Is this intentional or i...
SDF1

Discussions |
Mar 5, 2024 11:22 AM

766 views | 1 replies
How to save JMP drawings to a variable by reading them as binary files in JSL?

It do not need to save the local image file first.
Instead, the graph is written directly into a variable as a binary file in PNG formatThanks!dt=Open("$SAMPLE_DATA/Big Class.jmp"); p1 = dt << Graph Builder( Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ) ), Elements( Bar( X, Y, Legend( 5 ), Response Axis( "X" ) ) ) );
lala

Discussions |
Mar 5, 2024 12:36 AM

882 views | 2 replies
Do 3rd order effects help define curvature?

If you have are making a design with a factor you are certain will have a quadratic relationship against a response but you have a wide range, can it be helpful to define a 3rd order model effect for that factor to better identify and model curvature. I work in purification and we often deal with a recovery vs. purity balance. This relationship is usually quadratic around the optimal, where at a l...
MetaLizard62080

Discussions |
Mar 4, 2024 8:21 PM

887 views | 0 replies

Previous
Next

Latest Discussions

Do 3rd order effects help define curvature?

If you have are making a design with a factor you are certain will have a quadratic relationship against a response but you have a wide range, can it be helpful to define a 3rd order model effect for that factor to better identify and model curvature. I work in purification and we often deal with a recovery vs. purity balance. This relationship is usually quadratic around the optimal, where at a l...
MetaLizard62080

Discussions |
Mar 4, 2024 8:21 PM

887 views | 0 replies
"If" returns error response

I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl...
LT

Discussions |
Mar 4, 2024 8:08 PM

671 views | 0 replies
Neural networks that learn and predict in real time (incremental learning)

Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco
Marco2024

Discussions |
Mar 4, 2024 9:37 AM

715 views | 0 replies
ann armax model

how can make ann armax hybrid model such Matlab
Raaed

Discussions |
Mar 1, 2024 7:50 AM

712 views | 0 replies
Is there a way to change the defaults for the Summary platform?

Hi All, Does any know if it's possible to change the defaults of the Summary platform (Tables > Summary)? By default, Summary sets the new column names to be stat(column) and checks that the new data table is linked to the original data table. For much of the work I do, I don't like these features and wish I didn't have to change them every time I run a Summary. I know it can be useful at tim...
SDF1

Discussions |
Feb 29, 2024 8:08 AM

621 views | 0 replies