JMP User Community

Latest Discussions

Evaluating Col Mean with Iterations

Hi everyone, I'm having trouble evaluating a col mean function. As you can see below, the col mean(:age, :list_col_names[i]] doesnt insert the item in the list on the data table. With this current configuration, when I open the formula on the data table I get "Col Mean( :age, list_col_names[i] )" which doesnt correspond to anything on the list_col_names list.list_col_names = fdt << getColumnNames...
Ksrzg01

Discussions |
Apr 20, 2018 7:38 AM

5622 views | 2 replies
Decimal Format Problem

I have columns where I want to limit the decimal places to 2. Example, 0.335256 should be 0.34. I am using dt:ColumnName << Format( "Fixed Dec", 12, 2 ); and it works perfectly. However, some cells in the columns have values like: <0.00234 for which this Format outputs 0.00, whereas I want <0.00. How can I achieve this? Thank you.
Aam_jmp

Discussions |
Apr 20, 2018 7:27 AM

7793 views | 2 replies
plot two variables in one axes using fit Y by X

Dear experts, bellow is an example table for what I aim for:I have the three variables A, B, and C. A and B are numeric continous and C is numeric ordinal. I would like to fit A and B in Y axes and C in x axes. How can I do it in ftx Y by X? Thanks for any help!
Johnanderson

Discussions |
Apr 19, 2018 5:29 PM

7031 views | 2 replies
Modify summary table

I am trying to modify a summary table. -The table has been ordered by Sub_name, Substrate_ID and Date in that order. -I want to search the table and if a Sub_name is a duplicate, a Substrate ID is a duplicate and the dates are within 1 day, then combine those rows. -these values are ones that ran through midnight, so their dates are different, which causes them to be on seperate lines. I ...
KST-CPT

Discussions |
Apr 19, 2018 5:02 AM

4903 views | 1 replies
Run self-written JSL script with a shortcut

Hi everybody! When looking at some data in the Graph Builder I can mark one or more points in the plot. After marking something I would like to run a self-written JSL script (which plots the marked rows in the data table in some other way in a new window) by hitting some keyboard shortcut. I have to do that many times and I would like to avoid opening the script or switching to the scripting windo...
Rob

Discussions |
Apr 18, 2018 11:44 PM

9348 views | 4 replies

Previous
Next

Latest Discussions

Best way to work with .jmp files saved on SharePoint

Hello,Our company uses SharePoint quite extensively for project files, and an increasing number of projects include user's .jmp analysis files. However, when viewing the files in SharePoint the .jmp entries have the "other file type" icon. Of greater concern is when a user loads their file. They are expecting it to behave in a similar way to other Office documents, i.e. when they hit Save in the a...
drc_lewis

Discussions |
Apr 16, 2018 1:38 PM

13239 views | 3 replies
Not getting same results in neural network run from menu vs run from script.

I am trying to run a script that automates screening the eight different penalty modes in Neural Network and outputting the results into the current table. I have been troubleshooting why I am not getting different results from the different Fits in the script. This led me to look at the results for each individual penalty mode when the model was set up from the Neural Menu vs the script. The scri...
jwalk

Discussions |
Apr 16, 2018 6:05 AM

14152 views | 8 replies
Control Chart Builder with source data from multiple columns

I like the visualization provided by the Control Chart Builder. In particular I like the stacked Xbar-R plots in one figure, the built-in distribution with normal distribution fit overlay, and automatic control limits calculated overlaid on the charts. Unfortunately, many different data sources I'm working with aren't entered in full to our JMP tables. Mean, range and standard devivation are ca...
sbiedrzycki

Discussions |
Apr 13, 2018 5:32 AM

9426 views | 4 replies
Comparing means of two categorical factors including interactions

Hello, I am analyzing some data collected over the past year. For privacy reasons, I don't want to dive into it too much, but I think I've developed a simplified version of the experiment that I can use to ask questions. I have a randomized design with a 3x4 factorial arrangement. We'll say that I have a "Day" factor (Day 1, Day 10, Day 30) and a "Treatment" factor (Approach A, Approach B, Approac...
acbart

Discussions |
Apr 13, 2018 12:12 AM

5042 views | 2 replies
Line graph

Hello, I am trying to make a line graph to resemble this:My goalHowever, in my result (please see below), if you look vertically, the points do not line up with the x-axis like what is shown in the previous figure. I am currently using JMP13, the goal figure was created using JMP12. Could anyone help with this issue? Thanks!
alihong812

Discussions |
Apr 12, 2018 10:38 AM

9852 views | 4 replies

Previous
Next

Latest Discussions

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

4058 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2861 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2456 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3825 views | 0 replies
.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

2530 views | 0 replies