how do you update a jmp with excel file & not loose the formulas
Hello, do I update a JMP data table with data from excel without loosing the formulas? thanks
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHello, do I update a JMP data table with data from excel without loosing the formulas? thanks
Using JMP 18 (now switched to JMP 19)
Dear JMP, I found a discrepancy between a JMP result and the result in the textbook you cite as a reference. Is this a bug or does JMP use a different calculation than the textbook? JMP Pro 17.2.0 > Reliability and Survival > Life Distribution platform, fit to a Weibull, Wald confidence intervals > in the Parametric Estimate – Weibull section, all the numbers agree except the scale and Weibull ß ...
Dear all, I gathered several sets of historical data containing formulation composition. This includes multiple formulation phases and represents 150 runs with 35 components. Formulation steps were carried out "step by step". From one run to the next, the % of raw materials changes and also the raw materials themselves. In total, this represents 150 runs with 35 different components. FI, each for...
Hello, do I update a JMP data table with data from excel without loosing the formulas? thanks
Dear all, I gathered several sets of historical data containing formulation composition. This includes multiple formulation phases and represents 150 runs with 35 components. Formulation steps were carried out "step by step". From one run to the next, the % of raw materials changes and also the raw materials themselves. In total, this represents 150 runs with 35 different components. FI, each for...
I was wondering if anybody has used the new Snowflake REST Data connector in JMP 19 to connect to a Snowflake database successfully. The documentation on how to use it (JMP 19 Help ) is a bit sparse and generic and now I am left wondering on how to best configure the data connector for my Snowflake data base and if there is anything I have to change on the Snowflake side since I am mostly getting ...
Hello everyone. I've searched through many posts but still haven't found a solution. I hope someone can help with it... Use the Big Class sample dataset as an example. I set the weight as Y, the name as X, and the label by the value. I want to write a JSL to rotate the labels in the plot by 90 degrees as shown in the figure below. I find an option to set the label format in graph builder, but stil...
In a code, the coding for the expression handling was wrong and produced a surprising result.
I reduced it to an interaction between "x()" [inside Variables (x(:column))] and a variable x.
an example:
x= "hello";
type(x); // -> string
X(5) // -> "hello"
After defining a variable x, I can use it as a function x(...) - with an arbitrary argument
... and JMP will return the content of x.
someho...
Never mind, I figured it out - one of the functions had Eval() which was evaluating right when script starts.
I am writing a simple GUI prototype:
List of tables in a combo box, button to add\open table and Filter Col Box with column names of the currently selected table.
Everything works on the first run - tables are switched, columns are displayed, combobox reacts to tables being added, closed...
I created a mixture of mixtures test plan. Now that the data are collected, I'm not sure how to interpret the results. Can I get help to verify that I designed the experiment correctly, and also walk me through how to interpret the results? I am studying the friction of asphalt surfaces, and specifically the effects of aggregate type, aggregate blend ratios on coarse and fine fractions, and asphal...
Calculating the missing values in AHP matrix I have an incomplete AHP matrix, and I want to define the missing data using JMP, which method of screening values do you advice me to use, normal imputation, SVD imputation, or RPCA imputation. My second question as one part of the AHP matrix is equal to 1 divided on the second part. How can I tell JMP that to screen only the half of missed value whic...
Sample size is a major consideration when designing experiments or other research studies, and JMP S...
Graph Builder makes it easy to interactively add map images and boundaries to graphs to give visual...
Date: Thursday, May 14Time: 1:00–2:00 p.m. ETRegistration: FREE Whether you've just d...
Duration: 90 minutesRegistration: FREEHosted via Zoom This online workshop is for beginnin...