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...
wgardnerQSNew JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
This Club is is a participant-driven meeting designed to encourage attendee involvement and kno...
DOE Club This Club is is a participant-driven meeting designed to encourage attendee invo...