JMP User Community

Latest Discussions

For loop question

Hi everyone, First time I'm writing here, though I have read in this forum a lot. I do have some experience in JSL scripting, but I still haven't dealt with for loops. I have this data table which has 5 columns: entity, date1, date2, value1, value2 (value2 column initially contains missing values only). The table is sorted by Entity (ascending) and date1 (descending). I want to loop through all ro...
Yotam

Discussions |
Oct 7, 2019 6:51 AM

8111 views | 7 replies
Merge row in header titles

Hi,Using jsl I have imported an Excel file consisting of several sheets into jmp. In one of the sheets there is a header and a subheader and in jmp I would like to be able to join the subheader (1st row) in the header so that all information is contained in the header.Can that be done?Or can that be defined in the import somehow?Br Julie
JulieSAppel

Discussions |
Oct 7, 2019 5:11 AM

3503 views | 3 replies
Using log of variables in linear regression?

I am a new student using JMP and have a question.I have a dataset with several variables that are heavily skewed as evidenced by their distributions. One is my dependent variable and the others are all independent variables.I create new columns using the Log_variable for the dependent variable and one of the primary independent variables. Both of their distributions improved significantly towards...
jk577648

Discussions |
Oct 6, 2019 5:50 AM

6538 views | 4 replies
How to Create New Column Based on Values from Two Other Columns?

Hello:
I'm a long time JMP user, and have just started delving into scripting and use of the formula editor. I have a large table (approx 10K rows). I have several columns of interest: Patient_ID: unique identifier for each patientTime: timepoint at which lab sample was collectedLAB_VALUE: value for the lab parameter with 3 discrete possibilities (NORMAL, MILD, SEVERE)SEX: Sex of the patient I'd li...
SrihariGopal

Discussions |
Oct 5, 2019 3:24 PM

6986 views | 2 replies
Importing messy Excel files & testing if null

Dear JMP Community, I have the task of writing a script that is intended to automate the importing of data from "messy" Excel files. I say "messy" because the actual data that I want to pull out of the Excel files is not organized in neat columns and rows -- it's all over the place -- but it's always in the same place in each Excel file. The files basically contain lot information on our product...
SDF1

Discussions |
Oct 3, 2019 11:48 AM

2741 views | 2 replies

Previous
Next

Latest Discussions

For loop question

Hi everyone, First time I'm writing here, though I have read in this forum a lot. I do have some experience in JSL scripting, but I still haven't dealt with for loops. I have this data table which has 5 columns: entity, date1, date2, value1, value2 (value2 column initially contains missing values only). The table is sorted by Entity (ascending) and date1 (descending). I want to loop through all ro...
Yotam

Discussions |
Oct 7, 2019 6:51 AM

8111 views | 7 replies
Using log of variables in linear regression?

I am a new student using JMP and have a question.I have a dataset with several variables that are heavily skewed as evidenced by their distributions. One is my dependent variable and the others are all independent variables.I create new columns using the Log_variable for the dependent variable and one of the primary independent variables. Both of their distributions improved significantly towards...
jk577648

Discussions |
Oct 6, 2019 5:50 AM

6538 views | 4 replies
How to make one way anova with mean, std, n as input

Hi, I am completely new to JMP. I have googled several guides to one way anova, but they all seem to be based on data sets with all the data points for each category. Whereas I have already reduced my data sheet to the mean, standard deviation and number og points in each sample I am analyzing. Can these be used as input to anova?
CPHAst

Discussions |
Oct 3, 2019 6:49 AM

1892 views | 1 replies
Questions regarding box plot graphics

Hi
Im doing some box plots and got some trouble regarding the spacing between boxed etc.
To get points separated I moved Gender from overlay to the X-axis (see pictures). However, the spacing changed so thereäs more empty space between boxes. Makes sense so the points can be seen and jittered. However I would like to try with less space between and use transparent points. But can't find any soluti...
Jonkandonkan

Discussions |
Oct 3, 2019 3:20 AM

2930 views | 2 replies
Fit Model- Repeated, Fixed and Random Effects

Hi, I am hoping for some guidance with a test I would like to run. We have a trial were birds were fed 2 diets (Control and Treatment). Every week (Day 7, 14, 21, 28) subjects were weighed to analyse performance data (weight gain, feed efficiency, mortality etc.). The exact same trial was repeated in the same facility two months later, using the exact same diets and trial protocol. I want to comb...
Abbiegraham

Discussions |
Oct 2, 2019 4:27 PM

11287 views | 4 replies

Previous
Next

Latest Discussions

Extract Report Data and Export it to Excel

I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
jemairsmartes

Discussions |
Sep 11, 2019 10:27 AM

2157 views | 0 replies
How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1401 views | 0 replies
Capability Animation - How to see the LSL/USL Value?

I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?
Antonio80

Discussions |
Jul 9, 2019 1:31 AM

1361 views | 0 replies
Unable to allocate enough memory in access or evaluation

Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a 73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...
ns

Discussions |
Jul 8, 2019 9:04 AM

1452 views | 0 replies
How to Post JSON data to a site via API functionality: "Unsupported Media Type"

Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...
liqinglei419

Discussions |
Jul 2, 2019 6:33 AM

1708 views | 0 replies