JMP User Community

Latest Discussions

Import Multiple Files in JMP15 with Preview?

In earlier versions of JMP, I could import multiple files and use the preview to change the data format of the columns. It looks like that feature in JMP15 is no longer available. I have a number of CSV files that need to be imported, but in order to get the data in correctly, I need to make sure one column is imported as text instead of number. The data that is being imported has a column with n...
DawnW

Discussions |
Aug 11, 2020 7:49 AM

3570 views | 8 replies
Work algorithm for Normal data & Non normal. Non Normal Data (Abnormal Distribution). PP/PPK. Levey Jennings Control Chart.

Hi everyone! I analyze the statistics that arise during the production and packaging of tablets (pills).Data analysis is performed in several steps.Detecting outliers (Grubb's test)Determining, if the distribution is normal (Shapiro-Wilk test)Tolerant intervalsPlotting the Levey Jennings graph, PP/PPK Turn on the test for the first 3 special reasonsSometimes there are errors in entering data, some...
Leonard

Discussions |
Aug 11, 2020 7:38 AM

6225 views | 7 replies
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

6714 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

4172 views | 4 replies
Extracting many linear regression fits (including confidence intervals) without using scripting

Hi, I am looking for a way to easily obtain the slope of a regression fit and its 90 or 95% confidence intervals, without using JSL/scripting. My current experimental design looks a bit like this:
outcome measure (4 different measures, on the same y-axis/scale, let's call them concentration 1-4)x-axis measure: time in daysgrouped by:production type (2 factors)temperature (2 factors)production site ...
PedeGe

Discussions |
Aug 10, 2020 7:14 AM

2813 views | 2 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

4172 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

3258 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

1349 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

2106 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

1875 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

976 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

1271 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

1123 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

984 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

945 views | 0 replies