JMP User Community

Latest Discussions

JSL - Replacing Column Values with Vector

I'm attempting to script a function that replaces a range of column values with a vector of equal dimension. My code below either rejects the argument entirely or just changes the entire cell value to the vector, rather than spanning the range. I can imagine creating a "for loop" that would iterate through each row and and index the vector accordingly, but writing one value at a time seems ineffic...
EDW

Discussions |
Jun 27, 2019 12:08 PM

2896 views | 1 replies
JSL - Adding a Table to a Journal

Another JSL question, I'm trying to put a table in Journal using JSL. Here is what I am trying to do: current_data_table << New Data View; // Creating the Journal nw = New Window("Journal Right Here", <<Journal, ob = Outline Box("Section 1", Text Box("Some description that we need here.", << Markup), Current Journal()[TableBox(current_data_table)] ) );Everything seems to be...
drblove

Discussions |
Jun 27, 2019 7:10 AM

24511 views | 14 replies
How to look up data and create new column based on nearest match?

I have sample data in table sample1 and the look up table efficiency( please find attached both the tables). I want to find the closest match of data column in table sample1 with resplect to IOUT column in look up table efficiency. Based on the nearest match I want to populate efficiency column in table sample1 in accordance with look up table:Below is the code I am trying
/* Open a sample data tab...
jojmp

Discussions |
Jun 27, 2019 6:05 AM

2696 views | 2 replies
Appending element to a list value inside an associative array

Hi, I am trying to add an element into an associative array where the value is a list and the element needs to be added into the list inside associative array.Eg:cary = ["high schools" => {"Cary", "Green Hope", "Panther Creek"}, "population" => 116244, "state" => "NC", "weather" => "sunny"]; In this,1. How can I add a new entry to "high schools" list?2. How do I convert the "weather" value to list...
dileepkr

Discussions |
Jun 27, 2019 2:27 AM

7719 views | 2 replies
Not a JMP question, but hoping someone can help - Estimating StdDev from Min, Max, Avg

Firstly, this is not a JMP question but a gereral statistics question, so I apologize if it's inappropriate to post it here. But I'm hoping someone in the JMP community can help with it. I have a series of data samples, where each sample has Min, Avg (Mean), and Max recorded. The data is sampled every second, but only recorded every 15 minutes. So each of my 15-minute data points has the Min of...
wsande

Discussions |
Jun 26, 2019 2:02 PM

8577 views | 7 replies

Previous
Next

Latest Discussions

How to look up data and create new column based on nearest match?

I have sample data in table sample1 and the look up table efficiency( please find attached both the tables). I want to find the closest match of data column in table sample1 with resplect to IOUT column in look up table efficiency. Based on the nearest match I want to populate efficiency column in table sample1 in accordance with look up table:Below is the code I am trying
/* Open a sample data tab...
jojmp

Discussions |
Jun 27, 2019 6:05 AM

2696 views | 2 replies
Not a JMP question, but hoping someone can help - Estimating StdDev from Min, Max, Avg

Firstly, this is not a JMP question but a gereral statistics question, so I apologize if it's inappropriate to post it here. But I'm hoping someone in the JMP community can help with it. I have a series of data samples, where each sample has Min, Avg (Mean), and Max recorded. The data is sampled every second, but only recorded every 15 minutes. So each of my 15-minute data points has the Min of...
wsande

Discussions |
Jun 26, 2019 2:02 PM

8577 views | 7 replies
Overlay graph changes scaling when I change Local Data Filter - How to stop this?

I make an Overlay plot and then manually change the y-axis scaling. Then I change my Local Data Filter, and plot scaling changes - my manual settings are lost, and the plot re-autoscales. How can I sto pit fro mdoing that? I'd like th escaling to stay where I set it, even when I adjust the Local Data Filter.
wsande

Discussions |
Jun 25, 2019 5:46 PM

6026 views | 6 replies
Number of points in a Variability chart

I have a standard Variabilty chart, and I woiuld like to somehow see the number of points in each group. Is there a way to do this?
wsande

Discussions |
Jun 25, 2019 1:26 PM

6809 views | 6 replies
plot secondary y-axis with conversion scale

JMP Pros,I have variable y1 consisting of integer scores from 1 to 9. I created a second conditional variable y2 as: If(:y1 == 3, "4", :y1 == 5, "3", :y1 == 7, "2") which converts the integer score values in y1 to corresponding values on a measured scale (millimeters).When I plot both variables in Graph Builder, the y2 axis is scaled independently of y1 whereas, what I want is ...
Kip1

Discussions |
Jun 25, 2019 10:09 AM

4031 views | 4 replies

Previous
Next

Latest Discussions

How to analyze crossover design data in JMP

I had crossover design data from one of my experiment, and I want to analyze it according to the rules of crossover design. Can someone please help me with this?
sharmachetan

Discussions |
Jun 14, 2019 2:34 PM

1480 views | 0 replies
Help understanding how Lift curves are calculated

Dear JMPers, (computer details: I have JMP Pro 14 on a W7 Enterprise, 64-bit computer.) I am trying to better understand how JMP actually calculates a Lift curve. I understand conceptually the ROC and Lift curves, but I'm having a hard time calculating a Lift curve myself. The JMP help/support page (https://www.jmp.com/support/help/14-2/lift-curve.shtml#1276958) isn't all that helpful in under...
SDF1

Discussions |
May 29, 2019 11:10 AM

2113 views | 0 replies
How to analyze PSM data(Propensity Score Matching) in JMP？

How to analyze PSM data(Propensity Score Matching) in JMP？If it is yes, please tell me what detail steps in JMP manu,If there is any available examples in JMP sample data?
mujahida

Discussions |
May 7, 2019 9:30 PM

2397 views | 0 replies
Chi square or Cochran's Q test

Okay, so i have to decide whether i should use chi-square or Cochran's Q test for one of my study.If i assume meat as experimental unit (EU) and impose 6 different wood smoke (like apple smoke, cedar smoke, hickory smoke etc.) on EU and consumers (people) act as observational unit (OU). I have 10 consumers and each one will taste each treatment (6 treatments) and respond liking (9 point scale), an...
sharmachetan

Discussions |
Apr 16, 2019 3:54 PM

3113 views | 0 replies
Selecting Number of Clusters in Hierarchical Clustering

One way to select possible number of clusters in hierarchical methods is to identify the relatively large changes in distance as number of clusters change (see table below). When I look at the actual distance measure from the table (clustering history below dendogram), there is a bigger jump from 3 clusters to 4 than from 4 to 5 (smaller), suggesting 4 may be the right decision. However, when you ...
pratyushdash

Discussions |
Feb 23, 2019 5:51 PM

3151 views | 0 replies