49720_en-US

liliconcom

Nonlinear regression using vba automation

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

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=""></SET>

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.