Sum only selected rows of a column
Is there an easy way to sum only the selected rows of a column and save the value to a global variable?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesIs there an easy way to sum only the selected rows of a column and save the value to a global variable?
Hi all! I want to plot a bar chart using a specific row in the data table. The format of the table is as following: I am not sure what is the best way to do it.My thought is to select the row, save it to a new data table, transpose the new table and then use the two columns in the new data table to plot the bar. The script for this method is a little bit long so I would like to know whether there ...
What is the best way to create new columns, containing substrings from an existing column? In case the order of the sub strings is always the same, the Word function would be the way to go.What would be the solution in case the sub strings sequence is not always the same? The attached file shows examples.
I am trying to make a stacked bar chart using graph builder in JMP 13 Pro. The output looks great except that it won't display the error bars. Seems to be working fine if I make a side by side clustered bar chart, but I don't think stacked bar charts support the error bars. Does anyone have a clever way of getting the standard error bars to appear? Thanks.
Hi,
I'm trying to do a REST request to pull some JSON data with the following code but am getting an error. The owner of the site says I need to put the key in the request header as opposed to appending it. How does one do this in JSL with HTTP Request?
Site documentation here: https://jsonodds.com/documentation
Thanks in advance,
-Mike
key = "cb8abaa5-9b10-11e8-9bbb-0b704e36c1ea"; // su...
I am trying to make a stacked bar chart using graph builder in JMP 13 Pro. The output looks great except that it won't display the error bars. Seems to be working fine if I make a side by side clustered bar chart, but I don't think stacked bar charts support the error bars. Does anyone have a clever way of getting the standard error bars to appear? Thanks.
Hi, I was working with a variability chart today and I wanted to compare the means of two groups of data, each group being a subset of the data that I selected using in the chart by selecting those points and excluding/hiding the rest of the points in the data table. Does anyone know of an interactive way to do this without making a new data table? The reason for this is I wanted to select data t...
A JSL (TestJSL) script creates two table variables. Within the script they are being used to calculate a new column :D1 from the existing column :D0 by applying IF states etc..Is there a better way to do this, than with the rather complex formula for :D1?
Hi, Is there a way for us to have multiple spec limits (1 reference line) per group category ? Thanks AR
Is there a effective way to color of or example five box plots (normal style) with fill color in graph builder by using a add-in or JSL? The five different colors should be defined via RGB values.I don't want to use box plots with style solid, because of faded colors and missing fences. Attach a file with one colored box plot.
Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...