JMP User Community

Latest Discussions

Function in script to get log of a column

Hello,I was wondering how I would go about taking the log10 of a few of my columns and then having the data posted.E.g. For Column X, take the values (Y) and perform log10(Y) and save values under Column X Log
SI-2000

Discussions |
Feb 25, 2021 3:20 PM

3197 views | 4 replies
Turning a filterable dashboard into a "by" report/list

I have a fairly ugly request from a user that I am hoping has a simpler answer than what I am thinking. I have an exploratory analysis dashboard that generates around a few dozen graphs based on some choices in a filter. Mostly graph builder objects but also runs a process screening as well. What they would like is for the window of graphs to be repeated over and over again for each possible o...
Evan_Morris

Discussions |
Feb 25, 2021 1:55 PM

1023 views | 1 replies
convert columns to rows

data and desired results i would really appreciate your help
steo45

Discussions |
Feb 25, 2021 10:28 AM

11019 views | 22 replies
Reduce sorted list by averaging every n rows

This must be a common way to 'sample' long column of data. For example, after sorting a column of 10,000 rows from min to max, generate a column with 100 averages (or sums) of every 100 rows.In Excel, this can be done with a formula using the OFFSET function. How can this be done in JMP? Thank you,Tom
tomSorger

Discussions |
Feb 25, 2021 8:04 AM

2419 views | 2 replies
Determining delay time between variables using JMP

Hello,I have different variables (Y1, Y2,) spaced evenly with time (X). I suspect that there is a delay time between the two responses Y1 and Y2 based on the process involved and would like to estimate by how much I must timeshift the data (i.e. what is the delay time) so as to compare Y1 and Y2 at the same row number?I tried to use the auto-correlation function to determine the periodicity in eac...
anoopchengara

Discussions |
Feb 25, 2021 7:53 AM

9178 views | 5 replies

Previous
Next

Latest Discussions

Function in script to get log of a column

Hello,I was wondering how I would go about taking the log10 of a few of my columns and then having the data posted.E.g. For Column X, take the values (Y) and perform log10(Y) and save values under Column X Log
SI-2000

Discussions |
Feb 25, 2021 3:20 PM

3197 views | 4 replies
Turning a filterable dashboard into a "by" report/list

I have a fairly ugly request from a user that I am hoping has a simpler answer than what I am thinking. I have an exploratory analysis dashboard that generates around a few dozen graphs based on some choices in a filter. Mostly graph builder objects but also runs a process screening as well. What they would like is for the window of graphs to be repeated over and over again for each possible o...
Evan_Morris

Discussions |
Feb 25, 2021 1:55 PM

1023 views | 1 replies
Reduce sorted list by averaging every n rows

This must be a common way to 'sample' long column of data. For example, after sorting a column of 10,000 rows from min to max, generate a column with 100 averages (or sums) of every 100 rows.In Excel, this can be done with a formula using the OFFSET function. How can this be done in JMP? Thank you,Tom
tomSorger

Discussions |
Feb 25, 2021 8:04 AM

2419 views | 2 replies
How to change Font size in the significance circles

Font size of the significance circles. I am able to change it one circle at at time. Is there a way to do this simultaneously for all the circles? Thanks for input!
Sethu

Discussions |
Feb 24, 2021 5:46 PM

1735 views | 2 replies
Parameter Identification Technique Bi-variate Signatures

Hi, It would be great to get inputs on an approach to automate identification of parameters that can distinguish a bivariate response as shown in the example plot below. The data set has ~20k numerical continuous columns and one character response column. The response column has entries of the letter A or B. Objective is to identify parameters that can identify as many of category B without identi...
Cklud

Discussions |
Feb 24, 2021 1:41 PM

2867 views | 7 replies

Previous
Next

Latest Discussions

What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1486 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1328 views | 0 replies
generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1126 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1439 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

4028 views | 0 replies