JMP User Community

Latest Discussions

Row level normalization using a column level median value

Hello All,

Was wondering what is the approach to make a script that would do the following in JMP.

Let's say I have a column of values representing a population. I want to find the median of that population and then create a new column which takes each individual row value in the original column and divides it by the same median value for every row and saves it to the new column. In effect it is a n...
Ekarshalev

Discussions |
Feb 3, 2023 9:14 AM

1355 views | 2 replies
How to show mean +/- 3SD range in graph builder?

I want to show and compare the values by showing its mean+/-3SD range in graph builder.The graph builder only provide the bar range of mean+/-SD.
jmpneeeewbie

Discussions |
Feb 3, 2023 9:06 AM

2609 views | 2 replies
How to exclude rows based on a formula like in excel

Hello All, I have not run anything in JSL, as so far everything I've needed has been available as a series of buttons in the existing UI. I am hoping that what I want is still in that realm, but if it isn't, I could use instructions that a child could follow. I want to be able to write a formula in the data filter that would exclude anything that either satisfies (or doesn't satisfy) that formula....
Blueseashell3

Discussions |
Feb 3, 2023 7:41 AM

3049 views | 2 replies
Overwrite data in a table

Hi, I am trying to clean up my data table. I have a table with some value which are "x", "X", "X-Direction", "X-direction", but they are all the same, which is "X". How can I change the values (in the script) so it overwrite everything with the same format ("X")? Because then, I want to split my data table and it gives me 4 columns where I should have only 1... Thanks!
LGaspard

Discussions |
Feb 3, 2023 7:01 AM

1512 views | 2 replies
Custom design - Help to split-plot/blocking

Hi JMP community, I am currently working on a custom DOE design. Overall I have 3 factors with varying levels. Stabilizer solution (I have 7 different stabilizer solution I would like to screen) + potentially adding a reference sample (no stabilizer added). Dosage of stabilizer - 2 levels (high and low) => (0,01% and 0,02%) Process (2 different heat treatments/autoclavations). The pilot plant ...
Bertelsen92

Discussions |
Feb 3, 2023 7:00 AM

7653 views | 9 replies

Previous
Next

Latest Discussions

Row level normalization using a column level median value

Hello All,

Was wondering what is the approach to make a script that would do the following in JMP.

Let's say I have a column of values representing a population. I want to find the median of that population and then create a new column which takes each individual row value in the original column and divides it by the same median value for every row and saves it to the new column. In effect it is a n...
Ekarshalev

Discussions |
Feb 3, 2023 9:14 AM

1355 views | 2 replies
How to show mean +/- 3SD range in graph builder?

I want to show and compare the values by showing its mean+/-3SD range in graph builder.The graph builder only provide the bar range of mean+/-SD.
jmpneeeewbie

Discussions |
Feb 3, 2023 9:06 AM

2609 views | 2 replies
How to exclude rows based on a formula like in excel

Hello All, I have not run anything in JSL, as so far everything I've needed has been available as a series of buttons in the existing UI. I am hoping that what I want is still in that realm, but if it isn't, I could use instructions that a child could follow. I want to be able to write a formula in the data filter that would exclude anything that either satisfies (or doesn't satisfy) that formula....
Blueseashell3

Discussions |
Feb 3, 2023 7:41 AM

3049 views | 2 replies
Custom design - Help to split-plot/blocking

Hi JMP community, I am currently working on a custom DOE design. Overall I have 3 factors with varying levels. Stabilizer solution (I have 7 different stabilizer solution I would like to screen) + potentially adding a reference sample (no stabilizer added). Dosage of stabilizer - 2 levels (high and low) => (0,01% and 0,02%) Process (2 different heat treatments/autoclavations). The pilot plant ...
Bertelsen92

Discussions |
Feb 3, 2023 7:00 AM

7653 views | 9 replies
Dimension Reduction on large data sets

I am often dealing with data that has thousands of terms, and many thousands, sometime hundreds of thousands, observations. Many of the terms are usually correlated, so I would like to reduce the dimensionality. But if I try to use Principal Components to do this the computation time is excessive or downright impractical. Is there another method that would work better to reduce the dimensions o...
pcarroll1

Discussions |
Feb 3, 2023 6:59 AM

1124 views | 1 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

802 views | 0 replies
Choice experiment: probability profiler baseline assumptions

Dear community, For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data. Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...
Declan_JMP

Discussions |
Jan 23, 2023 3:54 AM

1617 views | 0 replies
Can we find some tutorials videos in YouTube?

Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!
Matheus_Plana

Discussions |
Jan 15, 2023 10:27 AM

1659 views | 0 replies
Data puzzles via Hanukkah of Data is underway

If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
XanGregg

Discussions |
Dec 19, 2022 11:21 AM

828 views | 0 replies
Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
Lavik17

Discussions |
Dec 19, 2022 10:20 AM

965 views | 0 replies