is there a script I can use to automate validation testing of my multiple regression model in JMP? (not JMP Pro)

Question

Hi - Is it possible to use a script or other approach to automate validation testing of my multiple regression model?  Currently, I am manually removing a subset of rows from my original model, using the balance of rows for regression, and then using the subset to evaluate how well the model performed.  I then repeat this numerous times.  It is very time consuming, especially given the fact that I now need to change my original model slightly.  I realize that JMP Pro will do this but currently do not have access to JMP Pro.  Thanks in advance!

learning_JSL · Answer

Thank you Pauldeen.  I'll have a look.  Since I don't often use scripting, hopefully the learning curve will be time well spent!  (I am with a State Agency and do not have access to hire your skills - thank you though for the heads up on your availability.)

learning_JSL · Answer

Thank you for your reply DS.  I'll give it a try and will watch for the "Make Validation Columns" command as well.

SDF1 · Answer

Hi @learning_JSL ,

Learning JSL will help you with your work and help to speed things up. Scripting is pretty straightforward and rather intuitive. One thing you'll definitely want to do is use the Help > Scripting Index to help you. In fact, there is a command called Make Validation Columns() which will make your training, validation, and test data sets in your data table. Under any of JMP's modeling platforms, all you need to do is cast the validation column in its role and JMP knows how to utilize that data in the modeling process. Once you get the right fit that you're after you can save the prediction formula to the data table.

Hope this helps!,

DS