cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
vharibal
Level II

How to retrieve misclassification rate value from report

Hello,

 

I am looking to save misclassification rate value after running Generalized Regression Lasso into a data table. Could someone please assist?

Its shown in red in the image below.

 

vharibal_0-1713769985903.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to retrieve misclassification rate value from report

One option is to open Properties menu (toolbar) and then check the report path under Box Path

jthi_0-1713771136734.png

You can then use that in a script

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Penicillin.jmp");
fm = dt << Fit Model(
	Freq(:Count),
	Y(:Response),
	Effects(:"ln(dose)"n),
	Personality("Generalized Regression"),
	Generalized Distribution("Binomial"),
	Run(
		Fit(
			Estimation Method(Logistic Regression),
			Validation Method(None),
			Confusion Matrix(0.5)
		)
	)
);
fm << Confusion Matrix(1);
ncb = Report(fm)["Logistic Regression","Confusion Matrix","Training",NumberColBox("Misclassification Rate")];
rate = (ncb << get)[1];
-Jarmo

View solution in original post

4 REPLIES 4
jthi
Super User

Re: How to retrieve misclassification rate value from report

One option is to open Properties menu (toolbar) and then check the report path under Box Path

jthi_0-1713771136734.png

You can then use that in a script

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Penicillin.jmp");
fm = dt << Fit Model(
	Freq(:Count),
	Y(:Response),
	Effects(:"ln(dose)"n),
	Personality("Generalized Regression"),
	Generalized Distribution("Binomial"),
	Run(
		Fit(
			Estimation Method(Logistic Regression),
			Validation Method(None),
			Confusion Matrix(0.5)
		)
	)
);
fm << Confusion Matrix(1);
ncb = Report(fm)["Logistic Regression","Confusion Matrix","Training",NumberColBox("Misclassification Rate")];
rate = (ncb << get)[1];
-Jarmo
vharibal
Level II

Re: How to retrieve misclassification rate value from report

Great!!  this works

Thank you very much

Victor_G
Super User

Re: How to retrieve misclassification rate value from report

Hi @vharibal,

 

If you right-click on the value of interest and then choose "Make into Data Table" or "Make Combined Data Table" (if you have several models for several responses and you want the missclassification rates for all responses saved in the same table), you can extract the values you're interested in in a new JMP table file. Reformat Tables in JMP Reports

 

EDIT: Curiously, this option is not available for the missclassification rates and confusion matrices.

 

Hope this answer will help you,

 

Victor GUILLER
L'Oréal Data & Analytics

"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)
txnelson
Super User

Re: How to retrieve misclassification rate value from report

One of the great standard features of JMP is that one can right click on any display table and select "Make into a Data Table"

txnelson_0-1713784886805.png

txnelson_1-1713784956749.png

 

 

 

Jim