Formula application
IF(MONTH(A151)=MONTH(A150),NA(),COUNTIF(W151:W181,1)*100/(COUNTIF(W151:W181,1)+COUNTIF(W151:W181,0))) . This is a formula applied in excel to create a...
ChitranshuFind courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesIF(MONTH(A151)=MONTH(A150),NA(),COUNTIF(W151:W181,1)*100/(COUNTIF(W151:W181,1)+COUNTIF(W151:W181,0))) . This is a formula applied in excel to create a...
ChitranshuHelloI would like to connect to the database through an SQL query.I have written the JSL script dt = Open Database (
"DRIVER ...
Hello, I am using JMP 16.2.0 to calculate Reliability Growth and am trying to understand the math behind the profiler confidence intervals on the Crow...
Reliability_JPLHello All, I'm writing a script where I start with a 'multiple file import' of a folder of .csv files. I will periodically be getting new .csv files t...
gregpearceHi, When performing a DSD, you are given the option for applying rules of "obeys strong heredity" for quadratics, and for interactions. I believe that...
MetaLizard62080IF(MONTH(A151)=MONTH(A150),NA(),COUNTIF(W151:W181,1)*100/(COUNTIF(W151:W181,1)+COUNTIF(W151:W181,0))) . This is a formula applied in excel to create a...
ChitranshuHi, When performing a DSD, you are given the option for applying rules of "obeys strong heredity" for quadratics, and for interactions. I believe that...
MetaLizard62080For my study, the primary endpoint is to determine the proportion of patients who experience a beneficial effect after receiving the treatment. We hav...
thiennguyenWhat is the correct way to check if an image in a data table is missing?... and why is there a difference between the column formula and the JSL quest...
hogiHi there, I'm working with Custom DOE, and I've collected data for my response variable that I want to input to generate a model. I've also collected ...
audrey1HiWe're doing a study regarding whole number ordinal data, answers being 0 to 4. It probably being MAR and not knowing the probability of each respons...
CovariateFilterHi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack ...
doraemengsWhen I run cluster analysis --> LCA with ordinal variables (numeric, ordinal), the probability formula appears to be treating the variables as nominal...
AutoMethodsBee1Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?
gholamhasanteyHello, in the multivariate analysis I have tried obtaining partial correlation, but I noticed some values are missing from the partial correlation mat...
gcheliniREGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-doe-04dec2024.html &...
This 45-minute webinar is given in English at 1PM (Singapore, Malaysia), 10:30AM (India),...
詳細、お申込み https://www.jmp.com/ja_jp/events/live-webinars/mastering-jmp/mastering-fit-model-2024-12.htm...
https://community.jmp.com/t5/Central-Ohio-JMP-Users-Group/Fall-COJUG-meeting-December-5th-2024/m-p/8...