cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
%3CLINGO-SUB%20id%3D%22lingo-sub-783398%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EHow%20do%20I%20get%20the%20value%20of%20the%20R-Sq%2C%20L1%2C%20L2%20and%20lambda%20out%20of%20Elastic%20Net%20Regression%20platform%20so%20I%20can%20compare%20models%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783398%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EI%20am%20comparing%20different%20parameter%20settings%20for%20some%20elastic%20net%20regression%20models%20on%20a%20smallish%20data%20set%20to%20demonstrate%20at%20what%20point%20datasets%20are%20too%20small%20for%20regression%20methods%20and%20want%20to%20compare%20between%20JMP%2C%20SAS%2C%20R%20and%20Python.%20Although%20I%20can%20set%20the%20alpha%2C%20I%20can't%20see%20how%20to%20directly%20output%20the%20lambda%2C%20L1%20and%20L2%20values%20that%20are%20used%20in%20the%20chosen%20models%20and%20the%20resulting%20R-Sq%20for%20the%20model.%20Is%20there%20a%20secret%20right%20click%20somewhere%20I'm%20missing%20as%20I%20would've%20thought%20these%20are%20pretty%20straightforward%20things%20that%20people%20want%20to%20see%3F%20And%20the%20other%20software%20seem%20to%20give%20these%20in%20varying%20ways.%3C%2FP%3E%3CP%3EI%20am%20using%20JMP%20Po%2018%20and%20using%20the%20Leave%20one%20out%20cross%20validation%20method%20-%20which%20also%20seems%20to%20mean%20no%20model%20comparison%20summary%20statistics%20are%20generated%20(they%20are%20if%20I%20choose%20AICc%20or%20BIC%20as%20the%20CV%20method)...is%20that%20right%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-783398%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EAdvanced%20Statistical%20Modeling%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783411%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20How%20do%20I%20get%20the%20value%20of%20the%20R-Sq%2C%20L1%2C%20L2%20and%20lambda%20out%20of%20Elastic%20Net%20Regression%20platform%20so%20I%20can%20compare%20models%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783411%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EYou%20can%20interactively%20extract%20these%20values%20by%20right-clicking%20on%20the%20column%20of%20numbers%20and%20selecting%20Make%20Into%20Data%20Table.%20You%20can%20script%20this%20action%20or%20a%20more%20specific%20extraction.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783602%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20How%20do%20I%20get%20the%20value%20of%20the%20R-Sq%2C%20L1%2C%20L2%20and%20lambda%20out%20of%20Elastic%20Net%20Regression%20platform%20so%20I%20can%20compare%20models%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783602%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EThanks%20for%20this%20Mark%2C%20but%20I%20can't%20even%20find%20the%20values%20in%20the%20output%20to%20be%20able%20to%20do%20that.%20A%20reply%20from%20a%20JMP%20technician%20said%20%22they%20don't%20surface%20these%20values%22%2C%20which%20I%20find%20a%20bit%20hard%20to%20understand%20as%20surely%20one%20wants%20to%20be%20able%20to%20see%20the%20lambda%2C%20L1%20and%20L2%20at%20the%20very%20least.%20Unless%20they%20are%20called%20by%20a%20different%20name%20in%20the%20JMP%20output%3F%3C%2FP%3E%3CP%3EThey%20also%20said%20you%20don't%20get%20an%20R-Sq%20if%20you%20use%20K-Fold%20or%20LOO%20as%20validation%20-%20but%20no%20explanation%20as%20to%20why%20not%20-%20any%20ideas%3F%20I'm%20pretty%20sure%20SAS%20gives%20these%20directly%20so%20I'm%20not%20sure%20why%20JMP%20is%20not%20doing%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
gemmahodgson
Level III

How do I get the value of the R-Sq, L1, L2 and lambda out of Elastic Net Regression platform so I can compare models?

I am comparing different parameter settings for some elastic net regression models on a smallish data set to demonstrate at what point datasets are too small for regression methods and want to compare between JMP, SAS, R and Python. Although I can set the alpha, I can't see how to directly output the lambda, L1 and L2 values that are used in the chosen models and the resulting R-Sq for the model. Is there a secret right click somewhere I'm missing as I would've thought these are pretty straightforward things that people want to see? And the other software seem to give these in varying ways.

I am using JMP Po 18 and using the Leave one out cross validation method - which also seems to mean no model comparison summary statistics are generated (they are if I choose AICc or BIC as the CV method)...is that right?

Thanks in advance.

2 REPLIES 2

Re: How do I get the value of the R-Sq, L1, L2 and lambda out of Elastic Net Regression platform so I can compare models?

You can interactively extract these values by right-clicking on the column of numbers and selecting Make Into Data Table. You can script this action or a more specific extraction.

gemmahodgson
Level III

Re: How do I get the value of the R-Sq, L1, L2 and lambda out of Elastic Net Regression platform so I can compare models?

Thanks for this Mark, but I can't even find the values in the output to be able to do that. A reply from a JMP technician said "they don't surface these values", which I find a bit hard to understand as surely one wants to be able to see the lambda, L1 and L2 at the very least. Unless they are called by a different name in the JMP output?

They also said you don't get an R-Sq if you use K-Fold or LOO as validation - but no explanation as to why not - any ideas? I'm pretty sure SAS gives these directly so I'm not sure why JMP is not doing it?