JMP User Community

Latest Discussions

Script: Remove prefix of string and output modified column to Excel file

Hi everyone. I have been following the advice at String parsing formula and some other references for writing data to files, mostly applicable to chunk text files but I found the Save Excel File() function in the Scripting Index. I don't know what the last parameter means/does? It isn't explained. That is to say, Separate Rows for Each Cell Statistic( 1 ) Is this important? It doesn't write an...
mostarr

Discussions |
Jul 17, 2021 12:31 PM

2526 views | 7 replies
Export data table to Excel using scripting

Hi, I'm trying to learn how to export my data table to excel using scripting and some automation.I am using save("") to open a "Save JMP File As" window prompting me to save the file. I'd like to have the "Save as type" set to *.xls instead of *.jmp so I don't have to change it every time. I'd also like to set the default folder that it chooses for saving the file to. Can any of this be done in th...
ShannonK

Discussions |
Jul 16, 2021 1:53 PM

20650 views | 8 replies
How Do you Use Repeated Measurement in Capability Analysis and distribution

I need suggestion for the analysis of a data point in multiple measurements. Say, I have potency measurement of a cream drug product from a tube. I have samples from the top, middle, bottom of the tube and hence the measurement for potency. The tube represents the batch and potency is representative of the batch but three measurements are representative of the same batch in reality. In the analysi...
AAzad

Discussions |
Jul 16, 2021 12:50 PM

1813 views | 3 replies
Counting values in each row

I have a script with col 1-6 in a listI am trying to write a JSL script that will count how many times the word POR appear, and how many times the word test appearsexample below (did it manually the last 2 columns)reading the forum I understand I need to convert DT into a matrix, but I am not able to make it work. thanks!
itzikd

Discussions |
Jul 16, 2021 12:20 PM

5334 views | 12 replies
How to use text to column methods but without manually renaming all the splited columns afterwards?

How do I use the "text to column" method but without manually renaming all the splitted columns afterwards?
shazaaliah

Discussions |
Jul 16, 2021 7:15 AM

1148 views | 2 replies

Previous
Next

Latest Discussions

Script: Remove prefix of string and output modified column to Excel file

Hi everyone. I have been following the advice at String parsing formula and some other references for writing data to files, mostly applicable to chunk text files but I found the Save Excel File() function in the Scripting Index. I don't know what the last parameter means/does? It isn't explained. That is to say, Separate Rows for Each Cell Statistic( 1 ) Is this important? It doesn't write an...
mostarr

Discussions |
Jul 17, 2021 12:31 PM

2526 views | 7 replies
How Do you Use Repeated Measurement in Capability Analysis and distribution

I need suggestion for the analysis of a data point in multiple measurements. Say, I have potency measurement of a cream drug product from a tube. I have samples from the top, middle, bottom of the tube and hence the measurement for potency. The tube represents the batch and potency is representative of the batch but three measurements are representative of the same batch in reality. In the analysi...
AAzad

Discussions |
Jul 16, 2021 12:50 PM

1813 views | 3 replies
Counting values in each row

I have a script with col 1-6 in a listI am trying to write a JSL script that will count how many times the word POR appear, and how many times the word test appearsexample below (did it manually the last 2 columns)reading the forum I understand I need to convert DT into a matrix, but I am not able to make it work. thanks!
itzikd

Discussions |
Jul 16, 2021 12:20 PM

5334 views | 12 replies
How to use text to column methods but without manually renaming all the splited columns afterwards?

How do I use the "text to column" method but without manually renaming all the splitted columns afterwards?
shazaaliah

Discussions |
Jul 16, 2021 7:15 AM

1148 views | 2 replies
How to create my model based on sensory data

Dear JMP-Community, for my master thesis I want to optimize the process for a hot beverage. I have 5 factors (X1 –X5), whereof one is a hard-to-change factor (X1) and 10 response variables (Y1-Y10). Responses are measured with a trained sensory panel (8 – 11 assessors). I created a custom RSM design with 243 runs (basically the design has 27 runs (minimum number), but each assessor (let´s assume 9...
kPvDoE

Discussions |
Jul 16, 2021 7:11 AM

2199 views | 3 replies

Previous
Next

Latest Discussions

Graphlet disappearing after filtering through a null set

Have a tool I built that has a series of graphlets in them. Noticed some odd behavior. The top-level graph has a local data filter. Some combinations of that data filter will result in no data. When I filter to a no-data set, then expand back to a set with data, the graphlet no longer exists. Any ideas on how to retain the graphlets after filtering?
Evan_Morris

Discussions |
Jul 12, 2021 10:28 AM

673 views | 0 replies
Obtaining a p-value for an odds ratio of a continuous variable

Hi all,When performing an odds ration analysis on a nominal variable I get a p-value which is identical to the p-value of the parameter estimate (see pic below). When performing the same on a continues variable there is no p-value (see pic below). Could I use the p-value of the parameter estimate as the p-value of the odds ratio?If not how could I obtain the p-value in JMP?TIA
eliyahu100

Discussions |
Jul 7, 2021 10:27 AM

1262 views | 0 replies
How do I get Odds Ratios after fitting a GLM with binomial distribution and logit function?

Hi everyone,I need to get OR after fitting a GLM with binomial distribution and logit function - that is a logistic model. I cannot fit a "nominal logistic" where there's the option for OR because I need to use the Firth adjustment for small-sample bias (I can only do that for that GLM). Is there an option to get the Odds Ratios? Thank you in advance. Antony
Antony

Discussions |
Jul 7, 2021 10:04 AM

693 views | 0 replies
Solving for new FPCs using a training set

Had a question on the Functional Data Explorer system. Feels like a dumb question but can't figure it out. So I set up a training set and developed FPCs I like. The next step is then to use that spline structure to solve the FPCs for new items as they come in. What steps would I take to do that?
Evan_Morris

Discussions |
Jul 6, 2021 11:08 AM

551 views | 0 replies
Section 508 compliance

Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful? Maybe this is a wish list item?
GGfGA

Discussions |
Jun 30, 2021 10:03 AM

686 views | 0 replies