JMP User Community

Latest Discussions

Copy and Paste multiple column headers?

Hi Everyone! I'm new to JMP (v14 here), so I apologize if this has been asked before. I'm attempting to concatenate some data files (csv) and multiple import is working fairly well... I will have duplicates to take care of as well as some column differences... I may end up with a powershell concatenate without worrying about this import in jmp, but I thought I'd try jmp first. In a few of the fil...
AllenJH

Discussions |
Oct 28, 2024 7:58 AM

17547 views | 7 replies
How to calculate moving averages for selected rows

Hello everyone! I am trying to write a script that will calculate moving averages using selected rows in a table. To set the stage: I have a data table (example attached) with multiple executions (Unique ID) of a 3 stage process (A, B, C). There is a reported value for each stage and these values are summed to give a Total value for each occasion. I would like to have a column that reports a mo...
ClusterFerret68

Discussions |
Oct 24, 2024 8:21 AM

2688 views | 6 replies
Why Scripts Group is lost when doing Table Subset?

Dear all, I frequently use table subset, often when having complex tasks with big data, I try the things I plan with a subset of 1/100 of rows etc. to be much faster for tests. During that I observed on my system (JMP 16.0, Windows10), that columns groups are kept, but script groups are lost. This makes no sense to my eyes, or is there any reason for this behaviour? If not, I would like to issue ...
Georg

Discussions |
Oct 23, 2024 9:38 PM

2362 views | 5 replies
Mean differences Student's t Table as Dunnett's differences table.

HI! :) At the Fit Model output window we can take the mean differences of an effect. We can choose among various methods such as Student and Dunnett. The following is the output of the dunnett methodwhere the format of the diffs is : Batch - Control but the confidence limits are not the same as in the students case:So what I would like is to take the second table. The results of the student's di...
Georgios_Tsim

Discussions |
Oct 23, 2024 1:20 AM

1645 views | 4 replies
Not sure how to use "Weight" in "Analyze"

I want to do something really simple. For simplicity's sake, assume I have two groups, let's say with N=2,000 in group 1 and N=3,000 in group 2. I'd like to compute an overall mean of a variable Y that is collected for each group. Y's mean in group 1 is 4 and in group 2 is 8. The overall mean here would be the unweighted mean and not the weighted mean–it should be 6. I might have thought that I sh...
profjmb

Discussions |
Oct 12, 2024 12:39 AM

7938 views | 10 replies

Previous
Next

Latest Discussions

Mean differences Student's t Table as Dunnett's differences table.

HI! :) At the Fit Model output window we can take the mean differences of an effect. We can choose among various methods such as Student and Dunnett. The following is the output of the dunnett methodwhere the format of the diffs is : Batch - Control but the confidence limits are not the same as in the students case:So what I would like is to take the second table. The results of the student's di...
Georgios_Tsim

Discussions |
Oct 23, 2024 1:20 AM

1645 views | 4 replies
Not sure how to use "Weight" in "Analyze"

I want to do something really simple. For simplicity's sake, assume I have two groups, let's say with N=2,000 in group 1 and N=3,000 in group 2. I'd like to compute an overall mean of a variable Y that is collected for each group. Y's mean in group 1 is 4 and in group 2 is 8. The overall mean here would be the unweighted mean and not the weighted mean–it should be 6. I might have thought that I sh...
profjmb

Discussions |
Oct 12, 2024 12:39 AM

7938 views | 10 replies
Counting Formulas

Looking to create 3 cols by col variable to could down with change, count up and count up/down from mid point.
DELANDJ1985

Discussions |
Oct 10, 2024 10:29 AM

1409 views | 3 replies
Work flow builder

Hi All, I recorded a seqeunce of data clean up steps on a file using workflow builder. I would like to be able to just change the name of the file and carry out the same set of steps however, some of my setps have name of the data table I orignially used to built the work flow builder. Is there a way I can update the names of the table to the latest table?

e.g
I have one of the steps as follow
Da...
Ahmed1

Discussions |
Oct 10, 2024 6:52 AM

5435 views | 11 replies
Creating a GUI with Checkboxes to Trigger File Selection and Data Formatting Functions

am developing a graphical user interface (GUI) that allows users to select one or more options via checkboxes. For each selected option, the GUI should perform the following actions sequentially:Pick File: Open a file picker dialog to allow the user to select a specific file related to the chosen option.Format and Save: Process the selected file using a predefined function that formats the data an...
DecileIbex201

Discussions |
Oct 10, 2024 6:29 AM

1071 views | 2 replies

Previous
Next

Latest Discussions

Machine data source list remove in "Database Operations"

I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean
Sean_ShCn0

Discussions |
Aug 22, 2024 7:24 AM

911 views | 0 replies
Is there a way to tell LCA that the rows are ordered by class?

Typical dataset: 120-200 rows, 15 classes. Rows are known to be ordered by class. What is unknown is where the 'fences' between classes are. As-is -- i.e., without taking row order into account -- LCA correctly classifies about 94% of rows. My intuition is that if I knew how to tell the algorithm that the rows are grouped by class on input, we'd be at 100%. Visual, in case my use of 'grouped by' i...
mtowle419

Discussions |
Aug 15, 2024 5:03 PM

661 views | 0 replies
I would like to find another political scientist or other social scientist who has worked with mapping congressional districts and counties

There are great bodies of data presented by counties (disease incidence, education, income). There are other bodies of data presented by congressional districts (incumbents, vote percentages, etc.) I want to find someone who has mapped the counties and the congressional districts into the same space. I know this can be done with ESRI products, but I wanted to avoid jumping off the JMP platform....
LNitz

Discussions |
Aug 8, 2024 8:15 PM

711 views | 0 replies
Overlying map files and merging content

I have two map files--one of economic and health conditions by US county. The other of congressional districts. I wish to overlay the county map on the congressional district map and attrribute the county measures to the ( larger opr smaller) congressional districts. For example, what is the average rate of coronary heart disease in districts represented by women versus those represented by m...
LNitz

Discussions |
Aug 1, 2024 2:04 AM

662 views | 0 replies
change tick labels

There are several ways to change tick labels in Graph Builder.

New in JMP17: via Configure Levels. Before JMP17, one could use Value Labels: ... and there is a nice shortcut to apply them very quickly:
- click on a tick label and hold the mouse button for some while.- the axis will change to edit mode- edit the label- press ESC

thanks @laura_archer for this trick & explanation :)

(view in My Videos)
hogi

Discussions |
Jun 20, 2024 2:01 PM

882 views | 0 replies