excel import - data ends on row??
is it possible on JMP 16 to only import certain rows from Excel using the wizard. I cannot find the 'data ends on row ... 'option. Thanks
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesis it possible on JMP 16 to only import certain rows from Excel using the wizard. I cannot find the 'data ends on row ... 'option. Thanks
Hi,I created variables that are list. I want to create new column that under if statement will fill up the cell with those variables. So I can get table as below. How can I add list into a cell? A={"96", "104", "112", "120"};
B={"1", "100", "111", "121"};
C={"6", "14", "112", "129"};
D={"9", "124", "132", "160"};
dt << New column("Value", Expression, formula(
if (
:Mode=="A" , A,
:Mode=="B
...
Hello Experts, I'm trying to automate updating my "GetLimitTable" with new data (I'm using Levey Jennings).How to replace value of specific row in Table B with value from specific column in Table A?For example, I want to;- replace row _Std Dev Value from 18.769 (Table B) with 10.312 (Robust Standard Deviation Table A)- replace row _Mean Value from 166.526 (Table B) with 166.1056 (Robust Mean Tab...
Hello community, I am testing several models as part of JSL loop in JMP 16, using different validation columns to determine how the R2 values change depending on what data is used. Each validation column contains a subset of the data, with some missing data at the beginning and/or the end of the column. Other models, such as the Bootstrap, run well simply ignoring missing values but the Neural N...
Dear all, I have a question, for which I cannot find an answer online an I doubt what's the right approach would be. Hopefully you can help me In short, I am making a protein dough by mixing various ingredients together. After being prepared, the dough rests for 5 days and than it's processed into a protein bar. During this 5 days the texture of the dough changes. My research question is how th...
is it possible on JMP 16 to only import certain rows from Excel using the wizard. I cannot find the 'data ends on row ... 'option. Thanks
Hello community, I am testing several models as part of JSL loop in JMP 16, using different validation columns to determine how the R2 values change depending on what data is used. Each validation column contains a subset of the data, with some missing data at the beginning and/or the end of the column. Other models, such as the Bootstrap, run well simply ignoring missing values but the Neural N...
Dear all, I have a question, for which I cannot find an answer online an I doubt what's the right approach would be. Hopefully you can help me In short, I am making a protein dough by mixing various ingredients together. After being prepared, the dough rests for 5 days and than it's processed into a protein bar. During this 5 days the texture of the dough changes. My research question is how th...
In a regression model with dummy variables: For example, I would like to test the relationships between occupation types and salary. In this condition, occupation is a categorical variable with 4 types (i.e., occ1; occ2; occ3 and occ4); salary is a continuous variable. In the regression model to test the relationships between occupation types and salary, I regard occ4 as the reference group, val...
Hi all, I'm running a script that takes a column from a data table and summarises it like so:names default to here(1);
dt = Current Data Table();
fails = dt << Summary(Group( :Test_Name ),Freq( "None" ),Weight( "None" ),Output Table( "Tests that have Failed" ));
The general method in our process is to select a row in the table created:There can be any number of rows in this first summary table sho...
I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
Dear community, For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data. Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...
Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!
If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...
Jump into Graphing Date: Wednesday, September 24Time: 1:00 – 2:30 p.m. ETDura...