This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
Create Time Series Validation Column
mia_stephens
Staff mia_stephens
Staff
Created: Jan 25, 2016 02:50 PM  |  Last Modified: May 2, 2023 03:36 PM
TimeSeriesValidationColumn.jmpaddin

An add-in to dynamically create a validation column for time series data.  Developed by Ian Cox (Ian@JMP​) and Julian Parris (julian​).

 

10820_pastedImage_0.png

 

** Note:  Model validation is not built into the time series platforms in JMP or JMP Pro. However, this can be done manually:

  1. Partition a time series using this add-in, and then hide and exclude the holdout partition (select the rows, and then select Rows > Hide and Exclude).
  2. Fit the time series model(s) using the Time Series platform (from the Analyze > Modeling menu).
  3. For the chosen model, save the prediction formula using the red triangle for the model. This produces a new data table with predicted values and residuals for the training data.
  4. To calculate residuals for the validation data, copy and paste the holdout values from the original table into the appropriate cells in this new table. Then, create a new column, and use the Formula Editor to calculate the residuals (actual - predicted). Note that forecasts for the validation data are automatically computed when the prediction formula is saved to the data table.
  5. Summarize the residuals for the training and validation data using the Distribution platform (to produce validation statistics), and graph the actual and forecasted time series and the residuals using the Graph Builder.
  6. To forecast future values using both the training and validation data, return to the original data, unhide and unexclude the holdout partition, and refit the model using the Time Series platform. Specify the number of forecast periods (from the red triangle), and save the prediction formula for this model to the data table. Repeat steps 4 and 5 above.

These steps apply to models built using the JMP Time Series platform. Regression-based forecasting models can be built using the Analyze > Fit Model platform. Built-in model validation can be used for these models. Here, we do not hide and exclude the validation data - we create a validation column, and use this column in the validation

field in the Fit Model Dialog.

 

** Adapted from Data Mining for Business Analytics with JMP Pro, Shmueli, Bruce, and Stephens, Wiley, released May 2016.

Comments
tajrida
‎04-10-2016 02:46 PM

A Youtube video explaining the use of this add in will be highly appreciated!