JMP User Community

Latest Discussions

Date Conversion issue

I have a set of data from a database that represents a date in an 8-number string "CreatedDateDimID" in the screen capture. I need it to be formatted like the date in "SterlingDimDate.Date" I tried converting to m/d/y in the column info, but it doesn't convert it correctly (see screen capture). What am I missing? Gives me this result when I would expect 01/03/2022 for the first one and 04/13/2...
Phil_Nash

Discussions |
Jul 11, 2022 11:13 AM

1956 views | 4 replies
July/August classes from JMP Education

JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for Non-Repairable Systems August 9-12: JMP Pro: Analyzing Curves and Profiles Using the Functional Data Explorer August 16-19: JMP: Statistical Decisions Using ANOVA and Regression August 29-September 1: J...
Di_Michelson

Discussions |
Jul 11, 2022 8:50 AM

661 views | 0 replies
How do you make a graph select the max and min for your Y axis instead of defaulting to limits?
Andyon98

Discussions |
Jul 11, 2022 6:36 AM

2145 views | 3 replies
Usability of Projects via JSL

Hi all,
I have several jsl scripts dealing with data fetching from databases, "manipulation" and analysis of these with regards to different tasks.
For organization purpose I like to use "Projects" as all data tables and graphs and journals etc. can be stored in "one" file.
However, I struggle with the automation of the save procedure of the respective contents.
All files are stored under "Workspace"....
RobertB

Discussions |
Jul 11, 2022 4:52 AM

2278 views | 4 replies
95% confidence interval, or is it?

Hello, I have been asked to provide some statistical advice on process related values. So we are making a product and we are monitoring the amount of solvent left at the end of synthesis.

I have been given 12 values. From this admitedly very small statistical sample, we want to make a prediction to say: in the future 95% of the values will be under this value. I tried giving my colleagues the uppe...
bobmorrane

Discussions |
Jul 11, 2022 3:51 AM

2065 views | 3 replies

Previous
Next

Latest Discussions

July/August classes from JMP Education

JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for Non-Repairable Systems August 9-12: JMP Pro: Analyzing Curves and Profiles Using the Functional Data Explorer August 16-19: JMP: Statistical Decisions Using ANOVA and Regression August 29-September 1: J...
Di_Michelson

Discussions |
Jul 11, 2022 8:50 AM

661 views | 0 replies
How do you make a graph select the max and min for your Y axis instead of defaulting to limits?
Andyon98

Discussions |
Jul 11, 2022 6:36 AM

2145 views | 3 replies
How to use JSL how to modify decimal numbers to binary data in this format?

Hello!How to use JSL how to modify decimal numbers to binary data in this format?Thanks!000903 999999
lala

Discussions |
Jul 10, 2022 7:12 AM

2838 views | 9 replies
Fill Data Table Columns with Sequential Data

Hello,a newbie question:Is there an option to use the "Fill" option with the sequential character ordinal data?Currently the sequence of Character data is only repeated, and is not continued.For example, I write "User 1", "User 2", "User 3", and want to continue the sequence till the end of the table (100 rows)
if I highlight the data I've entered and choose the "Fill to end of table", i get the re...
LambdaCapybara4

Discussions |
Jul 10, 2022 4:33 AM

1868 views | 3 replies
How to add new column to all data tables

I have a series of experiments which produce a text file of results, titled with the name of the sample.I have a script that takes the data table title and populates a new "sample name" column with the title.dt = current data table(); name = dt << get name; new column("Sample Name"); column(dt,"Sample Name")[1]=name; nr = N Rows( dt ); For( ii = 2, ii <= nr, ii++, If( is missing(Column( dt, "...
HarriBradbeer

Discussions |
Jul 9, 2022 8:15 AM

1605 views | 4 replies

Previous
Next

Latest Discussions

July/August classes from JMP Education

JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for Non-Repairable Systems August 9-12: JMP Pro: Analyzing Curves and Profiles Using the Functional Data Explorer August 16-19: JMP: Statistical Decisions Using ANOVA and Regression August 29-September 1: J...
Di_Michelson

Discussions |
Jul 11, 2022 8:50 AM

661 views | 0 replies
Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

782 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

628 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

773 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

995 views | 0 replies