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%3EWie%20erhalte%20ich%20die%20Werte%20von%20R-Sq%2C%20L1%2C%20L2%20und%20Lambda%20aus%20der%20Elastic%20Net%20Regression-Plattform%2C%20damit%20ich%20Modelle%20vergleichen%20kann%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783398%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIch%20vergleiche%20verschiedene%20Parametereinstellungen%20f%C3%BCr%20einige%20Elastic-Net-Regressionsmodelle%20anhand%20eines%20eher%20kleinen%20Datensatzes%2C%20um%20zu%20zeigen%2C%20ab%20welchem%20%E2%80%8B%E2%80%8BPunkt%20Datens%C3%A4tze%20f%C3%BCr%20Regressionsmethoden%20zu%20klein%20sind%2C%20und%20m%C3%B6chte%20zwischen%20JMP%2C%20SAS%2C%20R%20und%20Python%20vergleichen.%20Obwohl%20ich%20das%20Alpha%20einstellen%20kann%2C%20sehe%20ich%20nicht%2C%20wie%20ich%20die%20Lambda-%2C%20L1-%20und%20L2-Werte%2C%20die%20in%20den%20ausgew%C3%A4hlten%20Modellen%20verwendet%20werden%2C%20und%20das%20resultierende%20R-Sq%20f%C3%BCr%20das%20Modell%20direkt%20ausgeben%20kann.%20Gibt%20es%20irgendwo%20einen%20geheimen%20Rechtsklick%2C%20den%20ich%20%C3%BCbersehen%20habe%2C%20da%20ich%20gedacht%20h%C3%A4tte%2C%20dass%20dies%20ziemlich%20unkomplizierte%20Dinge%20sind%2C%20die%20die%20Leute%20sehen%20m%C3%B6chten%3F%20Und%20die%20andere%20Software%20scheint%20diese%20auf%20unterschiedliche%20Weise%20bereitzustellen.%3C%2FP%3E%3CP%3EIch%20verwende%20JMP%20Po%2018%20und%20die%20Kreuzvalidierungsmethode%20%E2%80%9ELeave%20One%20Out%E2%80%9C.%20Dies%20scheint%20auch%20zu%20bedeuten%2C%20dass%20keine%20zusammenfassenden%20Statistiken%20zum%20Modellvergleich%20erstellt%20werden%20(dies%20geschieht%2C%20wenn%20ich%20AICc%20oder%20BIC%20als%20CV-Methode%20w%C3%A4hle)%20%E2%80%A6%20ist%20das%20richtig%3F%3C%2FP%3E%3CP%3EDank%20im%20Voraus.%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%3EErweiterte%20statistische%20Modellierung%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%3EBetreff%3A%20Wie%20erhalte%20ich%20die%20Werte%20von%20R-Sq%2C%20L1%2C%20L2%20und%20Lambda%20aus%20der%20Elastic%20Net%20Regression-Plattform%2C%20damit%20ich%20Modelle%20vergleichen%20kann%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783411%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ESie%20k%C3%B6nnen%20diese%20Werte%20interaktiv%20extrahieren%2C%20indem%20Sie%20mit%20der%20rechten%20Maustaste%20auf%20die%20Zahlenspalte%20klicken%20und%20%E2%80%9EIn%20Datentabelle%20umwandeln%E2%80%9C%20ausw%C3%A4hlen.%20Sie%20k%C3%B6nnen%20diese%20Aktion%20oder%20eine%20spezifischere%20Extraktion%20skripten.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783602%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20Wie%20erhalte%20ich%20die%20Werte%20von%20R-Sq%2C%20L1%2C%20L2%20und%20Lambda%20aus%20der%20Elastic%20Net%20Regression-Plattform%2C%20damit%20ich%20Modelle%20vergleichen%20kann%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783602%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EDanke%20daf%C3%BCr%2C%20Mark%2C%20aber%20ich%20kann%20die%20Werte%20in%20der%20Ausgabe%20nicht%20einmal%20finden%2C%20um%20das%20tun%20zu%20k%C3%B6nnen.%20Eine%20Antwort%20eines%20JMP-Technikers%20lautete%3A%20%E2%80%9ESie%20zeigen%20diese%20Werte%20nicht%20an%E2%80%9C%2C%20was%20ich%20etwas%20schwer%20verst%C3%A4ndlich%20finde%2C%20da%20man%20doch%20zumindest%20Lambda%2C%20L1%20und%20L2%20sehen%20m%C3%B6chte.%20Es%20sei%20denn%2C%20sie%20werden%20in%20der%20JMP-Ausgabe%20anders%20genannt%3F%3C%2FP%3E%3CP%3ESie%20sagten%20auch%2C%20dass%20Sie%20kein%20R-Sq%20erhalten%2C%20wenn%20Sie%20K-Fold%20oder%20LOO%20als%20Validierung%20verwenden%20%E2%80%93%20aber%20keine%20Erkl%C3%A4rung%2C%20warum%20nicht%20%E2%80%93%20irgendwelche%20Ideen%3F%20Ich%20bin%20ziemlich%20sicher%2C%20dass%20SAS%20diese%20direkt%20bereitstellt%2C%20also%20bin%20ich%20mir%20nicht%20sicher%2C%20warum%20JMP%20dies%20nicht%20tut%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?