topic Re: How to retrieve misclassification rate value from report in Discussions

How to retrieve misclassification rate value from report

vharibal — Mon, 22 Apr 2024 07:13:45 GMT

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.

Re: How to retrieve misclassification rate value from report

jthi — Mon, 22 Apr 2024 07:34:05 GMT

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

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];

Re: How to retrieve misclassification rate value from report

Victor_G — Mon, 22 Apr 2024 09:58:39 GMT

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,

Re: How to retrieve misclassification rate value from report

vharibal — Mon, 22 Apr 2024 09:35:16 GMT

Great!! this works

Thank you very much

Re: How to retrieve misclassification rate value from report

txnelson — Mon, 22 Apr 2024 11:22:45 GMT

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"