JMP Scripts

Latest Posts

• Column Formulas to CSV

  JSL to find the formulas in a JMP data table and write a CSV (comma separated value) file.  There is an open issue for exporting formulas to Excel; maybe this script can serve as a starting point to determine what is really needed. The code also demonstrates a simple use of Regex, user functions, and saving a file to the $TEMP directory.This code has only been tested on the included data table. wh...

  Craige_Hales

  JMP Scripts |

  Oct 18, 2016 3:19 PM

  4614 views | 2 replies

• Word Counts to Columns

  This script counts the number of occurrences of each provided word, then creates individual columns with the number of occurrences for each word.UsageFirst download wordCountsv005.jsl from the bottom of this page1. With your data table open, run the attached script2. Select your column of text in the list of columns, then click "Text Column" to enter it in that role3. Enter the words you wish to c...

  julian

  JMP Scripts |

  Oct 18, 2016 3:17 PM

  11813 views | 1 replies

• Quick Reference lines with text comments system

  Hi everyone,Here is  a fun script to simplify tedious work like attaching references lines with comments on overlay graphs.  Hope you will find it useful. It definitely cut down on the time it took to prepare management reports ...etc. Its very simple to use 1. Just run the system and a pop up will appear. Select your data table and click ok.2.Select the appropriate columns (make sure both parame...

  estherloo2008

  JMP Scripts |

  Oct 18, 2016 3:04 PM

  3454 views | 0 replies

• Demonstrate the Univariate Box-Cox Transform

  (Please note that the second version of the script offers a significant enhancement over the first version. Please download and update your copy if you got it before October 3, 2014.)This script can be used with any numeric data column to demonstrate the beneficial effect of the Box-Cox transformation. A new column is created with the transformed variable. The new column name is the original colum...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:45 PM

  15246 views | 5 replies

• iTunes library xml parser

  This script parses the iTunes XML library file to create an analysis ready JMP table.  This is useful if you want to visualize your iTunes library with play counts.  Or, use this as an example of parsing XML into a JMP table for more general use.Please note that you may have to edit the second line of the JSL to set an appropriate path to the iTunes library file on your machine.iTunespath = "~/Mus...

  Jon_Weisz

  JMP Scripts |

  Oct 18, 2016 2:36 PM

  3906 views | 0 replies

• Custom JMP application example

  This is an example application created with the JMP Application Builder.  The file will open to the Application Builder editor.  Choose Run Application from the red-triangle menu to run the application.  This example demonstrates several features of applications:Data Tables can be embedded in the windows with reportsMultiple live reports with full brushing and interactivity are combined in a singl...

  danschikore

  JMP Scripts |

  Oct 18, 2016 2:32 PM

  6859 views | 0 replies

• Column Filling

  This script will fill missing values within a column based on other occurrences of data:In this illustrative data table, we might choose to forward-fill the Jan Ozone column or back-fill the Dec Ozone column.For example, forward-filling the Jan Ozone column would set the value of 2.63 for the whole of 1955; back-filling the Dec Ozone column would set the value to 3.83 for the whole of 1955.This ty...

  David_Burnham

  JMP Scripts |

  Oct 18, 2016 2:26 PM

  4422 views | 0 replies

• Confidence Intervals of mean, stdev, & CV - by Groups

  This script calculates the mean, Stdev, CV, and their associated confidence intervals of a numeric analysis column, based on a selected Alpha, tabulated by selected groups.

  dbartholomeusz

  JMP Scripts |

  Oct 18, 2016 2:25 PM

  4209 views | 0 replies

• Simple Script for Random Draw from 1 to n

  This script prompts the user to enter a value for a random draw from 1 to n. The resulting number is displayed in a second window. For instructional purposes this script utilizes two different methods for drawing a window, Dialog() and New Window(). Instructions: Run the script and enter a value. Click "OK" to draw a random number from 1 to the value entered.

  julian

  JMP Scripts |

  Oct 18, 2016 2:16 PM

  2850 views | 0 replies

• Graphical N-way ANOVA

  This script demonstrates a new graphical ANOVA procedure developed by Box and Hunter. This script is for the general case of a N-way ANOVA . It is especially effective with data from a designed experiment. (A separate script is available for the one-way ANOVA case with optional blocking.)Simply open a data table, then open and run the script. I will use a simulated experiment from Custom Design. T...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:06 PM

  3605 views | 0 replies

• Graphical One-way ANOVA with Blocking

  This script demonstrates a new graphical ANOVA procedure developed by Box and Hunter. This script is for the particular case of a one-way ANOVA with optional blocking. It is especially effective with data from a designed experiment. (A separate script is available for the n-way ANOVA case.)Simply open a data table, then open and run the script. I will use a simulated experiment from Custom Design....

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:06 PM

  5797 views | 0 replies

• Demonstrate Regression Diagnostics

  This script creates an extensive report of information about a multiple regression. Much of the information is presented graphically but much of it is also numeric.Simply open the data table with the regression sample, then open and run this script. This example uses the Fitness data table from the Sample Data folder.The default options will include an intercept term and neither center nor scale t...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:05 PM

  4040 views | 0 replies

• Demonstrate the Distribution of P-Values

  The p-value is important in deciding to reject or not to reject the null hypothesis in a significance test. Unfortunately, p-values are also often misunderstood. This script is based on the one-sample Student's t-test of the population mean. It simulates the test statistic and its associated p-value for many samples. Any case may be simulated. That is, you can enter any population mean and standar...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:05 PM

  5969 views | 0 replies

• Grubbs' Outlier Test (Version 2)

  (This script is a new version that provides By group processing. Finally! Note that the p-value reported in the first version is no longer available.)This script adds the two-tailed outlier test by Grubbs to the Distribution platform. The normal quantile plot and Goodness of Fit test are opened to help assess the assumption that the sample was drawn from a normal population.Simply open the data ta...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:04 PM

  22525 views | 5 replies

• Demonstrate the Box-Cox Power Transformation

  This script supports an interactive demonstration of the Box-Cox Power Transformation in the context of a simple linear regression. You can transform the dependent variable, the independent variable, or both. Simply open a data table with an example. (This description uses the Cars 1993 data table from the Sample Data folder.) Then open and run the script. Select the dependent variable and click Y...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:04 PM

  6514 views | 0 replies

• Demonstrate Simple Linear Regression

  This script creates an interactive demonstration of simple linear regression. You can select data columns for the Y and X roles or you can use a randomly generated data sample. Simply open and run the script:Select a data column for the dependent variable and click the Y, Response button. Select another data column for the independent variable and click the X, Predictor button. Click OK.(Note that...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:04 PM

  5387 views | 0 replies

• Confidence Interval for the Coefficient of Variation (CV)

  (Please note that this script is a new version that provides an optional By role as of 10Jul2014.)This script opens a Distribution platform and adds the confidence interval for the coefficient of variation to the report. Simply open the data table with the columns to be analyzed and then open and run the script. Select the columns for analysis and click Y, Response. Select the grouping column and ...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:03 PM

  11083 views | 3 replies

• ANOVA from Data Summary

  JMP performs the one-way ANOVA in the Oneway and the Fit Least Squares platforms. These platforms start with a data table:Here is the result from the Oneway platform:If the data is not available but a summary of the data is available. This script will perform the ANOVA from the summary. The script allows you to manually enter the summary or accepts the summary from a JMP data table. Let me show yo...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:03 PM

  12458 views | 3 replies

• Protected LSD

  This script implements a method that evaluates the one-way ANOVA for significance. Only if the F-ratio is significant at the specified alpha level will the multiple comparisons of choice be permitted.Simply open the data table for the one-way ANOVA, then open and run this script. Select the data columns for the Y, Response and X, Treatment roles, select the multiple comparison method, specify the ...

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:02 PM

  3481 views | 0 replies

• Inference from Data Summary

  This script opens an interactive calculator that performs a one-sample z-test, one-sample t-test, two-sample t-test, and a paired t-test using sample average, standard deviation, and sample size with the hypothesized parameter. The results are reported as either a confidence interval or a hypothesis test. The numerical estimate of the statistic and its standard error and a plot of the results.

  Mark_Bailey

  JMP Scripts |

  Oct 18, 2016 2:02 PM

  2842 views | 0 replies

• How to write self-updating JMP add-ins

  Setting up an ‘Add-in Depot’ makes it easy to administer a collection of self-updating JMP add-ins. In this example, the Depot is nothing more than a folder containing:The JMP add-in file “com.jmp.brady.addin1.jmpaddin”.A metadata file, “File Metadata.jmp”.In a typical case, the add-in depot will reside on a server folder where add-in users have read access.The metadata file is a JMP table that st...

  Jeff_Perkinson

  JMP Scripts |

  Oct 18, 2016 2:01 PM

  11819 views | 3 replies

• Confidence Interval for Population Mean

  This script illustrates the variability and capture rate of the confidence interval for the population mean. Includes controls for population shape, mean, and standard deviation, sample size, confidence level and number of samples.
  Watch video.
  Suggestions? Comments? Please reach out to JMP Academic'smia.stephens. Thanks!
  

  gail_massari

  JMP Scripts |

  Oct 18, 2016 1:58 PM

  9316 views | 0 replies

• Star Plot Script

  This script creates star plots for a given data table. A star is drawn for each observation in the data set. Each spoke on the star represents a variable. The length of each spoke is proportional to the magnitude of the variable for that  observation relative to the maximum magnitude of the variable across all observations. Star plots are useful for determining which observations are similar. Afte...

  clay_barker

  JMP Scripts |

  Oct 18, 2016 1:49 PM

  11561 views | 1 replies

• OpenGL 3D: DNA Double Helix

  This script uses JSL Scene3D commands (JMP's interface to OpenGL programming) to create a spinning 3-dimensional DNA double helix object.  Authors:   Laurie Cuffney, NCSU  Russ Wolfinger, SAS Institute Inc  Kelci Miclaus, SAS Institute IncSee this SAS Global Forum paper for more details.

  kelci_miclaus

  JMP Scripts |

  Oct 18, 2016 1:49 PM

  3895 views | 0 replies

• Export Data Table to MediaWiki format

  This script converts the current data table to text that can be displayed in Wikipedia and other sites based on the MediaWiki engine.

  XanGregg

  JMP Scripts |

  Oct 18, 2016 1:47 PM

  6204 views | 0 replies