Help with Percentile in JMP- numbers are not matching up with Excel
I have this formula in Excel: =IF(COUNT($E:$E)=0,"",FIXED(PERCENTILE($E:$E,0.9),I15,TRUE())) My JMP formula is only giving me numbers >10 however my excel is giving >100. I...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI have this formula in Excel: =IF(COUNT($E:$E)=0,"",FIXED(PERCENTILE($E:$E,0.9),I15,TRUE())) My JMP formula is only giving me numbers >10 however my excel is giving >100. I...
Whenever I try and launch the JSL Debugger (from JMP 10 - not Pro) I get a note saying: Time out encountered attempting to connect to the JSL Debugger GUI Do I need to connect to an external serv...
Hi all, I have a function where I needed it running when and only the column is not blank. How can I properly check if the column is not blank and run the function, I tried isMissing() but i...
Hello everyone! A Query: What is the difference between noise factor and Simulation experiment? Regards!! Marco
Is there an option (checkbox or setting) in Jmp to tell a data filter to exclude excluded rows from the lists? Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt <...
I have this formula in Excel: =IF(COUNT($E:$E)=0,"",FIXED(PERCENTILE($E:$E,0.9),I15,TRUE())) My JMP formula is only giving me numbers >10 however my excel is giving >100. I...
Hi all, I have a function where I needed it running when and only the column is not blank. How can I properly check if the column is not blank and run the function, I tried isMissing() but i...
Hello everyone! A Query: What is the difference between noise factor and Simulation experiment? Regards!! Marco
A while ago I created a script to extract data from a sql database (through ODBC) directly into a JMP table to automatically generating a control chart from the selected data. Working in JMP 16, this...
Hi all, I have this data table (attached) that I am trying to analyze with a jsl script. I havn't gone very far... I am aware of the `Col Moving Average` function but couldn't get it to fit my ...
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...
Hello, I'm trying to invoke some commands in R using the R Submit function in JSL and am getting the error below. Is this an issue with JMP17 and R integration? It only happens when I invoke...
I'm playing around with different scenarios on an Operating Characteristic curve in which the fraction defective is very small (screen shot below). Every time I run a scenario, the x-axis autom...
Related to the previous post How to get "Effect size" column with Response Screening functionality , I am also wondering how effect size in the response screening platform is calculate...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn to fit models using variable sel...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn how to publish data, dashboards...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-univar-11sep2024.htm...