JMP User Community

Latest Discussions

Formula for Number of Unique Categories in Column

I am looking for the column formula to provide me with the count of unique categories in a column (maybe based on another columns categories). For instance, if a column has A A B B B C then I would like to get back the value 3. Thanks
Martin

Discussions |
Apr 21, 2018 7:13 AM

17206 views | 9 replies
V list box and H list box

dear all i want to run JSL to put data table and oneway into one report, but it does not work the jsl which i wrote as below: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); rep=dt<<report win=New Window( "Example", V List Box(rep="$SAMPLE_DATA/Big Class.jmp", A=Oneway( Y( :height ), X( :sex ), Means( 1 ), Mean Diamonds( 1 ) ); )); where is my wrong?
TONYMA

Discussions |
Apr 21, 2018 6:41 AM

8214 views | 1 replies
Slope and Intercept calculations in JSL

@Jeff_Perkinson , @Milo ,
This is in reference to a discussion - Slope and intercept functions
I have found this discussion to be helpful. I am currently using JMP 13, so if there are developments made in JMP 14, I dont necessarily have access to it. But, here are my questions: Clear Log() ; Clear Globals(); Close All(DataTables,"No Save"); Slope = function({x,y},{defau...
uday_guntupalli

Discussions |
Apr 20, 2018 12:00 PM

6575 views | 4 replies
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

5263 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

7445 views | 2 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

12726 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

13390 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

8660 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

4673 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

9106 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

3815 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

2634 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

2262 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

3502 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

2277 views | 0 replies