JMP User Community

Latest Discussions

Fit Model - Effect Summary - no PValues?

Question: Why are there no LogWorth and PValues showing up in my Effect Summary section after I Fit Model an output with several inputs & second degree inputs (Factorial to Degree 2)? Context: Everything is continuous except 1 nominal dataset. I first did 6 singular outputs. it gave me some results so I could use that to eliminate the 2 at the end. But then I tried adding 2nd order inputs and: Am...
Lcheng

Discussions |
Jun 12, 2021 6:13 AM

1543 views | 1 replies
How can calculate the geometric mean of some rows?

The geometric mean can be easily obtained in Summary.
But how to calculate the mean by the formula column, right?
I searched the help documentation and the community and still couldn't find a way.
I want to calculate it this way:dt=Current Data Table(); dt<<New Column("text",formula(Geometric Mean(:height[Index(Row()-10,Row())]))); dt<<run formulas; Thanks!
lwx228

Discussions |
Jun 11, 2021 5:22 PM

6852 views | 7 replies
How to match and fill column/rows based on results

Hi, I was wondering if this is possible do to write a script for an analysis similar to the one below? In one column ("Month"), I have all 12 months of the year (January to December), with each month having multiple rows in the same column. In the next column ("Condition"), there is a condition for that month, either "A" or "B". In a 3rd column ("Result"), I want to write a formula that analyzes t...
cheeseistasty

Discussions |
Jun 11, 2021 1:22 PM

2546 views | 3 replies
JMP Script filter multiple parameters from multiple columns

See for example, I have data table below, with column name A, B, C, and I want to:Filter Column "A" by exclude "a" and "c" & Filter Column "B" by exclude "e" and "f" & Filter Column "C" by exclude "g" and "h"In the end, I want to delete rows that being excluded above based on the 3 criteria from each column. How can I script to make this happen? ABCadgbehcfiaeibfhcdgaeibdgcfh
aaronjiang

Discussions |
Jun 11, 2021 12:23 PM

1342 views | 1 replies
Setting Spec Limits using Column Data

Hi,I have a query that produces a data table with parameter test results and spec limits listed in different columns (example below). Is there a script that can set the spec limits to each parameter? Would I need to rearrange my data table for this to work? Sample IDParameterLSLUSLResultSample 1Parameter 15106Sample 2Parameter 15107Sample 3Parameter 2143Sample 4Parameter 2142Sample 5Parameter 3102...
Austin

Discussions |
Jun 11, 2021 8:41 AM

2553 views | 3 replies

Previous
Next

Latest Discussions

Fit Model - Effect Summary - no PValues?

Question: Why are there no LogWorth and PValues showing up in my Effect Summary section after I Fit Model an output with several inputs & second degree inputs (Factorial to Degree 2)? Context: Everything is continuous except 1 nominal dataset. I first did 6 singular outputs. it gave me some results so I could use that to eliminate the 2 at the end. But then I tried adding 2nd order inputs and: Am...
Lcheng

Discussions |
Jun 12, 2021 6:13 AM

1543 views | 1 replies
How to match and fill column/rows based on results

Hi, I was wondering if this is possible do to write a script for an analysis similar to the one below? In one column ("Month"), I have all 12 months of the year (January to December), with each month having multiple rows in the same column. In the next column ("Condition"), there is a condition for that month, either "A" or "B". In a 3rd column ("Result"), I want to write a formula that analyzes t...
cheeseistasty

Discussions |
Jun 11, 2021 1:22 PM

2546 views | 3 replies
JMP Script filter multiple parameters from multiple columns

See for example, I have data table below, with column name A, B, C, and I want to:Filter Column "A" by exclude "a" and "c" & Filter Column "B" by exclude "e" and "f" & Filter Column "C" by exclude "g" and "h"In the end, I want to delete rows that being excluded above based on the 3 criteria from each column. How can I script to make this happen? ABCadgbehcfiaeibfhcdgaeibdgcfh
aaronjiang

Discussions |
Jun 11, 2021 12:23 PM

1342 views | 1 replies
Conditional value labels for missing values

I wonder if there's a way to set up conditional value labels based on values from two columns. If I refer to the snapshot table below, I have "column 1" which could either be filled or empty and I also have "column 2" which either be filled or empty. What I'm trying to do is for "column 2" to be formatted like "Column 3". Which is: (i) values formatted to a date format if there's a value AND the "...
Djtjhin

Discussions |
Jun 11, 2021 8:38 AM

2602 views | 5 replies
Simple method to copy multiple column properties to a new data table?

I need to copy the column properties for 82 columns to a new data table which has the same number of columns and same column names. I seem to remember in the past that there was a quick and simple method, using a few mouse clicks and GUI interface (non-scripting method) to do this. I don't see these options anymore in any of the menus or sub-menus. Am I making this up, did this capability never...
notoriousapp

Discussions |
Jun 11, 2021 8:29 AM

17640 views | 10 replies

Previous
Next

Latest Discussions

Using a List to Filter in Custom Query Builder - Question

Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...
Benjamin_S

Discussions |
Jun 3, 2021 7:59 AM

1381 views | 0 replies
Can I control text size in a word cloud inside a dashboard container?

Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...
caseylott

Discussions |
Apr 28, 2021 12:03 PM

1397 views | 0 replies
多重比較での生存曲線の書き方　Bonferroniなど

4群での生存曲線をJMPproでの書き方を教えて下さい。また、JMPで「環境設定グループ」から「レポート」を選択し、「ローカルデータフィルター」を出せればできる方法も紹介されていたのですが、「ローカルデータフィルター」を出せません。どの方法でもよいので、JMPProで、多重比較法を用いた生存曲線の書き方をどなたか教えてください！宜しくお願い致します。
27070

Discussions |
Apr 20, 2021 1:41 AM

2432 views | 0 replies
Fantasy Baseball League

I am in a 16 team fantasy baseball league. Each week we tabulate totals for home runs, batting average, stolen bases, wins, saves, era, etc. If my team has the most home runs, I win that category for the week. We track 10 statistics so after each week I may have a final score of 6-3-1. My question is how can I use JMP to check what my score would have been if I had played each of the other 14 team...
atlas100

Discussions |
Apr 19, 2021 1:29 PM

1053 views | 0 replies
Generation of overdispersed poisson count data (vs gamma poisson)

Hello, I would like to reconcile the parametrization used in the Random Gamma Poisson(lambda, sigma)with the over-dispersion parameter as estimated in generalized linear model platform. Take for instance the attached table. Here the generating function is Random Gamma Poisson(exp(1+3*:X1),10)Running glm with poisson/log + overdispersion I obtain: Overdispersion = 6.09. Is there any way to link...
matteo_patelmo

Discussions |
Apr 12, 2021 9:53 AM

1304 views | 0 replies