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? ...
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 i...
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. Eac...
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 prot...
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. Eac...
...he second case, I have the feeling I am cheating, as it is not true that I am replicating the model. I am just analyzing the same subject/run, multiple time across different days. W...
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 vari...
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 ),F...
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 piec...
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 pro...
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, passiona...
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...
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 expos...
4 Day Course Monday, July 22| 9:00 a.m. - 12:30 p.m. ET Tuesday, July 23 | 9:00 a.m. - 12:30 p.m....
Learn the basics of using JMP without leaving your desk. Sign up for complimentary Web training, liv...
This webinar is in English, 2:00 p.m. US Eastern Time. See how to interactively automate anal...
Register here: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-python-30jul2024.html &nb...