JMP User Community

Latest Discussions

Tabulate specific values from column

Hi all, I have this Air Traffic.jmp file as my example, so what I wanted to do is to tabulate the data with only the specified values needed but it need to retain its original Column % value.I tried selecting the needed values then subset into another table but ends up having 100 Column % value. I also tried hiding and excluding but also got 100 Column % value. In my attached file, my needed valu...
29755

Discussions |
Sep 30, 2021 6:52 PM

2400 views | 3 replies
is there a JSL command to group all of my excluded rows at the top of my data table?

Hi - I have not been able to find a JSL command to group all excluded rows at the top of my data table. Is this possible?
learning_JSL

Discussions |
Sep 30, 2021 3:37 PM

2747 views | 8 replies
how to obtain scatter plot of age- and gender-adjusted biomarker X vs motor severity score Y using JMP

We would like to clarify whether there is a linear relationship between biomarker X and motor severity score Y in patients with a neurological disorder. Since age and biological sex influence the biomarker X, we considered them as covariates. We estimated the association between variables using partial Pearson correlations, and linearly adjusted for the effects of age and gender. We would apprecia...
KF2

Discussions |
Sep 30, 2021 2:18 PM

2099 views | 4 replies
How to do DOE with dependent variables

Hello, I am not sure my DOE is good. I want to compare two different cell culture platforms.I have two different culture platforms and each plat form has different ranges of rpm and working volume.For examples, platforms A & B (categorical)For A, 100 rpm - 200 rpm / 100mLFor B, 300 rpm - 400 rpm / 25mLInitially, I had two factors like rpm1 (100 - 200 rpm) and rpm2 (300 - 400 rpm). Then, in 'model'...
joepark

Discussions |
Sep 30, 2021 12:50 PM

4844 views | 8 replies
One way ANOVA comparing means.

I've had a look through the forums and can't find an answer to this, what I assume is a fairly easy question ( if someone has already answered it please just point me in the right direction..)

Is there a way to get JMP to give a t value for each level in a student t test and also q value in a comparison of all pairs using Tukey-Kramer HSD?.

hopefully that isn't to silly of a question.

thanks!

Discussions |
Sep 30, 2021 10:51 AM

23321 views | 6 replies

Previous
Next

Latest Discussions

Tabulate specific values from column

Hi all, I have this Air Traffic.jmp file as my example, so what I wanted to do is to tabulate the data with only the specified values needed but it need to retain its original Column % value.I tried selecting the needed values then subset into another table but ends up having 100 Column % value. I also tried hiding and excluding but also got 100 Column % value. In my attached file, my needed valu...
29755

Discussions |
Sep 30, 2021 6:52 PM

2400 views | 3 replies
how to obtain scatter plot of age- and gender-adjusted biomarker X vs motor severity score Y using JMP

We would like to clarify whether there is a linear relationship between biomarker X and motor severity score Y in patients with a neurological disorder. Since age and biological sex influence the biomarker X, we considered them as covariates. We estimated the association between variables using partial Pearson correlations, and linearly adjusted for the effects of age and gender. We would apprecia...
KF2

Discussions |
Sep 30, 2021 2:18 PM

2099 views | 4 replies
Name Unresolved Error

Hello, I am having trouble with working on a lab assignment. But I had come across an error and was unable to proceed any further. Can anyone help resolve this? Please see the picture file. Using JMP Pro 16 and using the Add-in for Alternate Cut-off Confusion Matrix. Name Unresolved: tcol in access or evaluation of 'tcol', tcol/*###*/ Thank you! Sincerely,bad85
bad85

Discussions |
Sep 30, 2021 7:27 AM

3140 views | 3 replies
Sample size to meet specificity and sensitivity requirements

Hi, I'm trying to calculate the sample size required for my test to meet the sensitivity and specificity requirements.I have a binary test that detects the presence of bacteria in water, if it's positive bacteria is present, if it's negative it is not present.I would like my test to have92% sensitivity (with 95% CI of 90-94%)and 90% specificity (with 95% CI of 88-92%)and I want the power to be 0.8...
Agustin

Discussions |
Sep 30, 2021 6:16 AM

1503 views | 2 replies
Dunnett's for Multiple Ys

I am trying to get a script that will run Dunnett's on multiple Ys automatically in fit model, my issues: If I change the multiple comparisons part where the factor and level is not a variable it works but only for the first Y, it will not repeat the Dunnett's part for the remaining Ys. So my questions: 1. Why doesn't this work like the fit model with a variable being used for the factor an...
lisamaley

Discussions |
Sep 29, 2021 1:35 PM

3913 views | 12 replies

Previous
Next

Latest Discussions

Skip Lot Sampling Plan

Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam
AT

Discussions |
Sep 10, 2021 10:38 AM

943 views | 0 replies
Time values in xls or xlsx, csv, and JMP

Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...
fliew0410

Discussions |
Sep 7, 2021 7:25 AM

943 views | 0 replies
Error while using Azure MFA to connect with JMP

I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.
hariharan249

Discussions |
Sep 3, 2021 7:14 AM

655 views | 0 replies
Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1213 views | 0 replies
Projects Window List in JMP 15 for Mac -- Reorder?

I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses. There is a flow to the findings which I'd like to order in that Window List. Is this possible? I can't click and drag an entry for a window up or d...
datanaut

Discussions |
Aug 16, 2021 6:38 AM

610 views | 0 replies