JMP User Community

Latest Discussions

Fill rows in main table depending on conditions in second table

I have a main table with timestamp for 2021 in one minute resolution ("Timestamp-1min"). Need to fill the main table with data from second table with one-day resolution ("Start-End-TS1") depending on a pair of conditions for each day in a year(Sunrise, Sunset: Twilight Start and End) while matching the day, month and [time(Hr:min) in the conditions].I have done it for Date 6/14/2021- which is in ...
SymS

Discussions |
Jan 26, 2022 9:27 AM

1886 views | 3 replies
Eliminate Negative values in multiple columns

I have a table with 200 columns, and each column has negative values randomly populated. In some columns-like temperature- negative value is meaningful while performing summary statistics, but in others it is a filler for either "data not recorded- communication error" or "data not available- Equipment shut off". When I want to plot, the negative values are useful. So my Q is how do I keep the ne...
SymS

Discussions |
Jan 26, 2022 8:51 AM

3490 views | 5 replies
MSA results JMP vs Minitab

@Martin DemelDear JMP community, maybe some of you can help me out.I am routinely using Minitab. Now I am supporting a friend who is using JMP in his company and has asked me to explain to his team how to do the procedures in JMP which I explained in Minitab.First subject I am struggling with is MSA (in JMP Variability Study).I have an example with strong appraiser*parts interaction, since somehow...
hhuelsing

Discussions |
Jan 26, 2022 8:34 AM

6487 views | 7 replies
need script that computes the statistical parameters shown below in my post

Hi - I am still new at jsl scripting and am trying to write a script that creates and saves four new columns based on my linear regression fit:- lower 95% mean confidence interval- upper 95% mean confidence interval- lower 95% individual confidence interval- upper 95% individual confidence intervalFinally, each of the above are computed in terms of log 10 and I would instead like them converted to...
learning_JSL

Discussions |
Jan 26, 2022 6:41 AM

2197 views | 6 replies
Population bioequivalence approach of FDA

Dear all, FDA has a guidance for in vitro bioequivalence of products between test and reference. The name of this statistical test is Population bioequivalence. Please find test details below link; https://www.accessdata.fda.gov/drugsatfda_docs/psg/Budesonide_Inhalation_Sus_20929_RC_09-12.pdf Is there anyone help for calculation of this test by using jmp? BR,
nac

Discussions |
Jan 25, 2022 1:33 PM

1942 views | 1 replies

Previous
Next

Latest Discussions

Eliminate Negative values in multiple columns

I have a table with 200 columns, and each column has negative values randomly populated. In some columns-like temperature- negative value is meaningful while performing summary statistics, but in others it is a filler for either "data not recorded- communication error" or "data not available- Equipment shut off". When I want to plot, the negative values are useful. So my Q is how do I keep the ne...
SymS

Discussions |
Jan 26, 2022 8:51 AM

3490 views | 5 replies
Population bioequivalence approach of FDA

Dear all, FDA has a guidance for in vitro bioequivalence of products between test and reference. The name of this statistical test is Population bioequivalence. Please find test details below link; https://www.accessdata.fda.gov/drugsatfda_docs/psg/Budesonide_Inhalation_Sus_20929_RC_09-12.pdf Is there anyone help for calculation of this test by using jmp? BR,
nac

Discussions |
Jan 25, 2022 1:33 PM

1942 views | 1 replies
Formula for scoring defect counts

I need a little help with a formula In this scenario I have a column of counts, the number of things included in a lot. In a second column I have the count of defects. In another table I have the number of allowed defects for a range of parts in the lot. for example: parts, allowed defects 1-10, 1 11-20, 2 21-30, 3 31-40, 4 Using JSL, this is pretty easy. I can just make the max parts colu...
Byron_JMP

Discussions |
Jan 25, 2022 11:37 AM

834 views | 1 replies
Question about Kaplan Meier survival curves.

Hello, I'm very new to JMP software. I'm trying to generate Kaplan Meier survival curve for my research. So far, I made my data set like this (If I made a mistake about the below table for Kaplan Meier, let me know):Time (day)DiedCencor00012.67022031040.3305005241 After that, I used the Survival platform (Y=months, Censor=censor, and Freq=died). The result started with day 1. But I want to get thi...
JunepyoOh

Discussions |
Jan 25, 2022 11:19 AM

1505 views | 1 replies
Can't get just ONE axis to reverse

I'm trying to get just the Y axis inverted, using JSLThis is a graph-builder that contains shapes from a NAME.jsl file with an XY.JSL file as well. Whenever I reverse one axis the other reverses as well, how can I get my Y axis ALONE to invert and the X axis to stay the same? When I do this on other graphs it works fine, but this one that contains Custom shapes has me stumped. Is there anything I ...
xxvvcczz

Discussions |
Jan 25, 2022 9:30 AM

1604 views | 2 replies

Previous
Next

Latest Discussions

Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1390 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

788 views | 0 replies
How do I apply time fixed effects with multiple regression

I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function only available in SAS? Thanks
RiDe

Discussions |
Jan 10, 2022 11:18 PM

699 views | 0 replies
separating labelled values from graph points

I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...
Cdougz

Discussions |
Dec 31, 2021 7:38 AM

911 views | 0 replies
Expand Contours

Hi,

I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks!
MikeDereviankin

Discussions |
Dec 15, 2021 12:49 PM

709 views | 0 replies