How to subset top 10 highest values by year and location?
I have a dataset of daily ozone concentrations from multiple sites over several years. Is there a quick way to subset the top ten highest concentrations at each site and year?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI have a dataset of daily ozone concentrations from multiple sites over several years. Is there a quick way to subset the top ten highest concentrations at each site and year?
I wonder how to keep the Rows>Data Filter menu always visible in JMP. Instead of having Local Data Filters in each graph or window, how to keep the general one visible?
Using the design evaluation tool in JMP, I compared a Box-Behnken design with a Custom design (with 28 runs) to evaluate 5 factors with 3 levels each (see below):Given the comparison, the custom design was chosen for the experimental runs. In the evaluation, I found the quadratic terms to be statistically significant (p<0.05) for one or more responses, despite the power for these terms being low a...
I like to create a design with 4 factors, in which one factor is constant and this should be taken into account for the 100% calculation. I get a result where the three variable factors are calculated to 100% and the constant factor is then over 100%. Can that be changed somewhere?
Hi, I would like to rename a column with column name "Error(%)" to "Error_Percentage. May i know how to write a JMP script for this? thanks
Using the design evaluation tool in JMP, I compared a Box-Behnken design with a Custom design (with 28 runs) to evaluate 5 factors with 3 levels each (see below):Given the comparison, the custom design was chosen for the experimental runs. In the evaluation, I found the quadratic terms to be statistically significant (p<0.05) for one or more responses, despite the power for these terms being low a...
I like to create a design with 4 factors, in which one factor is constant and this should be taken into account for the 100% calculation. I get a result where the three variable factors are calculated to 100% and the constant factor is then over 100%. Can that be changed somewhere?
Hi, I would like to rename a column with column name "Error(%)" to "Error_Percentage. May i know how to write a JMP script for this? thanks
Hello,I would like to import a number of TXT files into one data table.An individual TXT file looks like this and I would like to only import the highlighted data and if possible create a new column to capture the batch number.I’ve written the following script (below) which gets me partially there but I still have to delete some of the data as highlighted below. This is ok when I only have a few f...
Hi,
I have scripted an addin to query a sql table and then group/move some of the columns with an action below. It does group the columns but it also leaves them outside of the group post query. How do I not have them displayed outside of the group?
Open Database(
"DSN=BB Analytics Data Warehouse;Description=BB Analytics Data Warehouse;UID=;Trusted_Connection=Yes;APP=JMP;WSID=SFX-5GCN2M1;DATA
...
I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
Dear community, For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data. Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...
Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!
If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Do you face challenges with restrictive data formats from EDS, XRD, or Raman instruments? Are the ex...
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...