JMP User Community

Latest Discussions

Problem to paste continuuos numbers from JMP to Excel

Dear JMP-Experts, I have measured continuous datasets and when I export them from excel to JMP (either by the JMP macro or by copy paste) they appear only as ordinal or nominal but not as continuous. How do I fix this problem. I uploaded the excel sheet as well as the JMP sheet below. Thanks a lot for your help!!!
SimonFuchs

Discussions |
Oct 24, 2022 9:06 AM

1512 views | 1 replies
How to create categorization from data with with known categories for comparison and categorization of a new data run of unknown category

Scenario: I have 8 compounds A-H, for each compound I have 5 runs* of time-temperature data with a known category. I need to be able to compare a single data run of an unknown category to those existing runs and assign a category to that run. A few things going on which may also need accounted for:1) My start times (when heating began vs the data run started) do not all align.2) Not all runs end a...
atoomey

Discussions |
Oct 24, 2022 8:13 AM

6458 views | 10 replies
Why the in-process output considered as potential cause?

Hello,Please see below image.1.Can someone help me to understand why In-process outputs are considered as potential Causes (X's).2. In the below case how can we find that there is a problem with machine or parameters of the machine?
dheerules

Discussions |
Oct 24, 2022 8:01 AM

2362 views | 5 replies
Journaling issues (Tab pages)

Today is the day I have finally forced myself into preparing a full presentation in a JMP Journal, rather than a PowerPoint presentation. Alas, I ran into at least one issue which I couldn't resolve by searching the forum. (I have also crossposted a similar question here earlier today. Same linke as below, btw.) Whenever I drop tab pages from the journal toolbar into the journal, my tab pages look...
Ressel

Discussions |
Oct 24, 2022 1:43 AM

2141 views | 3 replies
Can't extract the column name properly from "get Column Names"

Hey everyone, I'm trying to get the columns names into the process capability platform and have it set the 2 normal mixture distribution as the default. So first I get the column names (e.g. ) collist={};
collist=dt3 << Get Column Names("numeric"); then I loop through the columns in the capability platform: nw=new window("capability analysis", for(i=1, i<=n items(collist),i++,...
shampton82

Discussions |
Oct 23, 2022 1:53 PM

1237 views | 2 replies

Previous
Next

Latest Discussions

How to create categorization from data with with known categories for comparison and categorization of a new data run of unknown category

Scenario: I have 8 compounds A-H, for each compound I have 5 runs* of time-temperature data with a known category. I need to be able to compare a single data run of an unknown category to those existing runs and assign a category to that run. A few things going on which may also need accounted for:1) My start times (when heating began vs the data run started) do not all align.2) Not all runs end a...
atoomey

Discussions |
Oct 24, 2022 8:13 AM

6458 views | 10 replies
Change column names at once

Hello, I have a data table with several continuous columns, each column with a different name. I wish to: 1) duplicate continuous columns all at once; 2) rename these new columns with their original names (i.e., lady beetle) plus add "/100" to their names (i.e., column name would be: lady beetle/100) all at once; then 3) I want to multiply these new columns by 4 all at once (only the continuous co...
bordini

Discussions |
Oct 23, 2022 8:54 AM

2908 views | 3 replies
know number of data-missing row when making a summary table

Hi all JMP experts, I'm making a summary table from a raw data table - taking median by group names defined in column "purpose," e.g. a group is named "BSL."The summary table shows that there are totally 744 rows of group "BSL" that are used for summary-extraction, but is there a way to know within the 744 data rows, how many rows contain/doesn't contain(i.e. missing) numbers?
stevend1219

Discussions |
Oct 22, 2022 5:22 AM

881 views | 1 replies
Is having 6 terms in a linear regression with n = 8 acceptable?

I am currently analyzing a full factorial experiment with 2 levels and 3 factors, unreplicated, n = 8. According to JMP guides, the proper methodology here would be to fit the model using factorial to degree 2, assuming higher order interactions are insignificant, before using backwards selection to reduce the model down to its significant factors. JMP guide for 2x2x2 full factorial analysis: http...
QW

Discussions |
Oct 22, 2022 1:01 AM

3392 views | 6 replies
why is my "select where" causing JMP to hang?

Using JMP16 standard, and I'm working on a largeish data table (90col, 2.4M rows). I'm creating a summary table, using "Update" to get the new summary column back into the main table, and then doing a "select where" on the newly added column, and JMP hangs every time. I thought it was due to my script, but I get the same issue if I do this manually. However, it seems to work fine if I use "Join" a...
klipson

Discussions |
Oct 21, 2022 2:03 PM

1215 views | 3 replies

Previous
Next

Latest Discussions

How to Analyze and Graph Responses with Supercategories

I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories. I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification? PS: I don't know how to do JSL scripting.
TCM

Discussions |
Oct 21, 2022 5:59 AM

759 views | 0 replies
標準化列名稱如何用變數取代求解

//新增周標準化
weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
weekEMC_HF_C_12 = {};
//少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
);
Try(
Local( {old dt = Current Data Table()},
Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
For Each( ...
Ken697

Discussions |
Oct 20, 2022 9:22 PM

677 views | 0 replies
Methods for compressing a CSV or TSV file with jmp compression to save as .jmp table without having to open the csv in JSL first?

I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this: MyDataFile = open(filename,Private); MyDataFile << Compress File When Saved; MyDataFile << save(filetosa...
CurbStegosaurus

Discussions |
Oct 14, 2022 9:06 AM

1824 views | 0 replies
Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

574 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

622 views | 0 replies