JMP User Community

Latest Discussions

Change the text color of a single cell

Hi, I have a script that looks at the data table DLD and then populates the data table CK with several rows of Pass/Fail. What I'd like it to do is for pass have the cell background color be green with black font and for fail have red cell background with white font. The color cells command is working fine, but I've been unable to find a syntax for changing font color that works after trying sever...
david707

Discussions |
Aug 11, 2018 6:57 PM

5345 views | 2 replies
How do I move labels to bottom of bar in graph builder

Currently the value labels are on the top of the bar and I need them to be on the bottom of the bar. Anyway to move them?
chadyoder

Discussions |
Aug 11, 2018 11:57 AM

5363 views | 1 replies
Workaround to "update" function in script

Hello JMP community, I have a data table that is dependent on another data table. I've tried updating it with the update function, but it seems to not do anything. Instead, what this script is doing is opening a new data table window with the selected subset instead of updating the current table. How can I get it to update the currently open datatable "dt" with the subset of "dtU"? Thanks! // Open...
jmpandvba

Discussions |
Aug 10, 2018 7:21 PM

6636 views | 10 replies
simple random samples of columns

Hello, I know how to use JMP to create a SRS using rows but not with columns. I have 118,000 columns as part of a transcriptome, and I want to calculate the standard deviation across all genes (i.e., across rows). Doing so will cause JMP to crash on a Macbook Air with 8 GB of RAM. Therefore, I am wondering if I can just pick groups of 5,000 or 10,000 genes and calculate a standard deviation ac...
abmayfield

Discussions |
Aug 10, 2018 2:08 PM

7482 views | 6 replies
script for deleting all columns and rows in a data table

How can I select all data in a data table (all rows and columns) and delete it through a script?
jmpandvba

Discussions |
Aug 10, 2018 11:15 AM

4497 views | 1 replies

Previous
Next

Latest Discussions

Workaround to "update" function in script

Hello JMP community, I have a data table that is dependent on another data table. I've tried updating it with the update function, but it seems to not do anything. Instead, what this script is doing is opening a new data table window with the selected subset instead of updating the current table. How can I get it to update the currently open datatable "dt" with the subset of "dtU"? Thanks! // Open...
jmpandvba

Discussions |
Aug 10, 2018 7:21 PM

6636 views | 10 replies
Error Bars on a Stacked Bar Chart

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.
Mananahi

Discussions |
Aug 9, 2018 12:24 AM

3998 views | 2 replies
Is There a Way to Determine the Mean for Selected Rows While Viewing in a Chart or Graph

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...
jbenzetti

Discussions |
Aug 7, 2018 12:34 PM

5205 views | 3 replies
What is the best way to calculate with table variables and columns?

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?
Thomas1

Discussions |
Aug 7, 2018 5:47 AM

2670 views | 4 replies
Multiple Spec Limits in 1 View

Hi, Is there a way for us to have multiple spec limits (1 reference line) per group category ? Thanks AR
araghava

Discussions |
Aug 7, 2018 2:21 AM

3590 views | 3 replies

Previous
Next

Latest Discussions

repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

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;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

2941 views | 0 replies
Time Series - Prewhiten

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, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2056 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

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...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

2547 views | 0 replies
Why does Profiler not stop

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.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1556 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

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...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3543 views | 0 replies