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 ex...
UpliftElk866Find 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 ex...
UpliftElk866Whenever 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 ...
AnonymousHi 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...
UserID16644Hello 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(
...
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 ex...
UpliftElk866Hi 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...
UserID16644Hello 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 char...
ArjanHHi 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 Averag...
Lavik17If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. The...
XanGreggHI 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 t...
Lavik17Hello, 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 in...
vigslayerI'm playing around with different scenarios on an Operating Characteristic curve in which the fraction defective is very small (screen shot below). E...
The_AnnieRelated to the previous post How to get "Effect size" column with Response Screening functionality , I am also wondering how effect size in the respon...
wgardnerQSThis US session is held in English, 1:00 pm US Eastern Time. New JMP users will&n...
4 Day Course Monday, November 18 | 8:30 a.m. - 12:00 p.m. ET Tuesday, November 19 | 8:30 a.m. - 1...
This Club is is a participant-driven meeting designed to encourage attendee involvement and kno...
Topic: Tips and Tricks in JSL Registration link: https://www.jmp.com/en_gb/ev...