Countif equivalent?
I am trying to find a JMP formula function equivalent to Excel’s Countif function, that points to a column and returns the number of rows that are the same as the value in the current row, as you wou...
DispersionSparkFind courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am trying to find a JMP formula function equivalent to Excel’s Countif function, that points to a column and returns the number of rows that are the same as the value in the current row, as you wou...
DispersionSparkHello, Noob question... I have a column with a unique identifier (UID) for certain types objects, for instance {'cats', 'dogs', 'birds'}. Each UID has multiple rows associated with ...
StarfruitBob...olumns but gives me "Formula evaluation errors" dt2 = Current Data Table(); // Create the split data table dt2 = dt << Split( Split By( :S ), Split( :Name( "Median(data)" ) ), Group...
FrequencyBison9Hello, I have been able to work on a script to edit the legend, based on a Flag column. When I recreate the same plot in GraphBuilder, I get a darker shade of colors, but when I run my scrip...
KenobiHello! It seems that there have no built-in options to directly calculate the sample size and power for linear mixed models in JMP. Then, how could I do such kind of power analysis? Thank you.
AdeleI was trying to save datapoints that lay above 99.9% CI from Bivariate linear regression results. Selected alpha 0.001 and saved Indiv CIs formula. JM surely enough saves 2 columns named Lower.. and&...
l_yampolskydt = Current Data Table(); //declaring variables alpha_min = 14; alpha_max = 18; inc_val = 0.1; this is the script, but i want to create bivariate plots of each of them without it showin...
ParametricStudyHello! I have a Numeric Column which has up to 21 characters (i.e. 123145678915487615423) and I have the Column Properties set as: Numeric Continuous Best Width: 21 Use thousands separat...
MaerawlingsJMP appears to use the exclusive method as the default for calculating quantiles, irrespective of the sample size (that is, odd versus even). Excel offers one the option (QUANTILE.INC versus QUANTIL...
34SouthHi everyone, I'm trying to build a workflow that will allow be to quickly look at numerous csv files that all have the same format, number of variables, column names etc. I didn't think it would be ...
GregMcMahonRedo Analysis from the the red triangle/Redo menu is great. It generates an exact copy of the current report. Is there also a possibility to get an exact copy of a report (e.g. Graph ui...
hogiHi, Is there a way for me and a collegue to work on the same JMP file in real time? We have JMP 17. Thanks!
nbhagrooHello! For example, using large class data: Compare the height column and the weight column to see which column fits the sinusoidal distribution better. The parameters of the sine curve are random...
UersKWhen designing dsd with 49 factors and 4 additional runs. Why do I get 109 runs and not 105 runs?
ConditionalRam9In JMP 16 (Windows) , I removed the F1 hotkey from Help and set up as a new function using Custom Menus and Toolbars. I did the same in JMP 17 standard, and yet when I hit F1, I still get the Help b...
jwildeTopic: Building Robust and Fail-Safe Scripts Registration page: https://www.jmp.com/en_gb/...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn to fit models using variable sel...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn how to publish data, dashboards...