Nonlinear regression using vba automation

rinosaur — Tue, 16 Jan 2018 16:32:54 GMT

Hello,

I currently have a working JMP script which automatically fits my raw data using a predictor formula

fit1 = Nonlinear(
Y( :Name( "-60" ) ),
X( :Formula ),
Iteration Limit( 100 ),
Newton,
Finish
);
fit1 << Prediction Formula;
fit1 << Close Window;

I am now trying to automate this side of things from Excel using VBA. Is it possible to automatically run this non linear regression using vba and paste the resulting fitted data back into excel?

Thank you very much,

Re: Nonlinear regression using vba automation

Byron_JMP — Mon, 22 Jan 2018 21:08:26 GMT

maybe have your VBA script run a JSL script like this?


Names Default To Here( 1 );
dt = Open(
	"$SAMPLE_DATA/Nonlinear Examples/US Population.jmp"
);
//dt<<set name("Some Data");
obj = Nonlinear( Y( :pop ), X( :Name( "X-formula" ) ) );
obj << Newton;
obj << Finish;
obj << Prediction Formula;
obj << Close Window;
Create Excel Workbook(
	"/User/Examples/DATA FROM JMP.xlsx",
	{"Some Data"},
	{"Data From JMP Non-Linear Fit"}
);

This saves a JMP table as an Excel Workbook and gives you the flexibility to write a tab name as well as the file name.

topic Re: Nonlinear regression using vba automation in Discussions

Nonlinear regression using vba automation

Re: Nonlinear regression using vba automation