JMP User Community

Latest Discussions

retrieve number of rows for data table and a subset

Hi, I need to know the amount of rows that are present in the parent data table as well as the amount of rows in a filtered subset of this parent table. But when I try to retrieve both in 1 script, it only gives me the amount of rows in the parent... Can you please help? //parent data table dt = Open("C:\JMP\yield_analysis_script\used_data\edit1.jmp","visible"); //save value f=Col Number(:height)...
PhiIippe

Discussions |
Aug 11, 2020 6:31 AM

7856 views | 1 replies
Degree-heating weeks-help with formulas

Hello, To understand how much heat stress corals are exposed to, we calculate what is known as a "degree-heating week:" this is the amount of time a temperature is above a known threshold (typically the mean monthly maximum or the bleaching threshold). Basically, I need to integrate the amount of time that the temperature has surpassed 31C in my dataset (attached). Temperature was measured four...
abmayfield

Discussions |
Aug 10, 2020 4:30 PM

6070 views | 4 replies
What are the pairs in the “each pair student’s t-test”?

I have analyzed 14 samples (named sample 1-sample 14) with 2 different methods (named method 1 and method 2).I want to see whether there is a difference between method 1 and method 2.The result of the measurement is concentration in ppm. The different samples have contents between 65 and 1200 ppm.I analyzed each sample 2-3 times with method 1 and 3 times with method 2.The leverage plot shows that ...
depa

Discussions |
Aug 9, 2020 11:37 PM

4107 views | 2 replies
Sample size, confounding, bias

I have doubts. I use data on electricity consumption per capita (per year) from 1960-2014. The sample size in this case is N = 55 for the whole world, as well as for individual regions and countries. However, the annual per capita consumption of electricity for the world covers approximately 7,000,000,000 people, and for Norway, for example, about 5 million, but in both cases for the period from 1...
lekovic

Discussions |
Aug 9, 2020 5:41 PM

1980 views | 2 replies
Models with weight

Hi I'm trying to find a correlation between some X predictors and a continuous response variable strongly skewed on the right. The database contains 140 instances only. First of all I transformed the response variable by using the function lnx+1. Then I normalized all the x in the range 0 and 1, reduced the dimensionality with the screening option and then removed the correlated predictors X. At t...
FR60

Discussions |
Aug 9, 2020 2:10 PM

2747 views | 3 replies

Previous
Next

Latest Discussions

Degree-heating weeks-help with formulas

Hello, To understand how much heat stress corals are exposed to, we calculate what is known as a "degree-heating week:" this is the amount of time a temperature is above a known threshold (typically the mean monthly maximum or the bleaching threshold). Basically, I need to integrate the amount of time that the temperature has surpassed 31C in my dataset (attached). Temperature was measured four...
abmayfield

Discussions |
Aug 10, 2020 4:30 PM

6070 views | 4 replies
What are the pairs in the “each pair student’s t-test”?

I have analyzed 14 samples (named sample 1-sample 14) with 2 different methods (named method 1 and method 2).I want to see whether there is a difference between method 1 and method 2.The result of the measurement is concentration in ppm. The different samples have contents between 65 and 1200 ppm.I analyzed each sample 2-3 times with method 1 and 3 times with method 2.The leverage plot shows that ...
depa

Discussions |
Aug 9, 2020 11:37 PM

4107 views | 2 replies
Sample size, confounding, bias

I have doubts. I use data on electricity consumption per capita (per year) from 1960-2014. The sample size in this case is N = 55 for the whole world, as well as for individual regions and countries. However, the annual per capita consumption of electricity for the world covers approximately 7,000,000,000 people, and for Norway, for example, about 5 million, but in both cases for the period from 1...
lekovic

Discussions |
Aug 9, 2020 5:41 PM

1980 views | 2 replies
Models with weight

Hi I'm trying to find a correlation between some X predictors and a continuous response variable strongly skewed on the right. The database contains 140 instances only. First of all I transformed the response variable by using the function lnx+1. Then I normalized all the x in the range 0 and 1, reduced the dimensionality with the screening option and then removed the correlated predictors X. At t...
FR60

Discussions |
Aug 9, 2020 2:10 PM

2747 views | 3 replies
How to do 2-stage least squares (2SLS) / Instrumental Variable regression / Heckman self-selection model

Hi there, Is it possible to do a two-stage least squares model or IV regression or Heckman self-selection model in JMP? Is it also possible to get the inverse Mills ratio? Thanks in advance!
Heckman123

Discussions |
Aug 7, 2020 6:59 AM

2603 views | 1 replies

Previous
Next

Latest Discussions

XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

1494 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1696 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1428 views | 0 replies
[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1296 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1322 views | 0 replies