cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Lu
Lu
Level IV

predcition formula into excel

Hello,

 

I want to use a predcition formula form a least square prediction model generated in JMPpro to be saved in and excel database so that non-JMP users would able to use the prediction formula. It seems that I can save the formula in several formats but not in excel format. Any suggestion?

 

regards

 

Lu

2 REPLIES 2
txnelson
Super User

Re: predcition formula into excel

You are correct.  JMPPro does not have a built in JMP to Excel prediction formula translator.  However, many of the generated least square prediction formulas can easily be translated into Excel.  Not knowing the complexity of the formula you are generating, it is tough to be able to make any real definitive statement on how or if the formula can be converted.

Jim
P_Bartell
Level VIII

Re: predcition formula into excel

In addition to everything @txnelson has shared, since you are using JMP Pro, depending on the specific scoring code language used in the 'database', you may be able to write the prediction formula in that language as scoring code using the JMP Pro Formula Depot scoring code export utility? Here's a link to the online JMP Pro documentation with details...

Scoring Code in JMP Pro Formula Depot