This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Lu
Lu
Level IV

predcition formula into excel

Created: Aug 22, 2021 09:54 AM  |  Last Modified: Jun 10, 2023 07:35 PM (483 views)

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

0 Kudos
2 REPLIES 2
txnelson
Super User txnelson
Super User

Re: predcition formula into excel

Aug 22, 2021 11:38 AM (472 views)  |  Posted in reply to message from Lu 08-22-2021

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
0 Kudos
P_Bartell
P_Bartell
Level VIII

Re: predcition formula into excel

Aug 23, 2021 06:57 AM (448 views)  |  Posted in reply to message from Lu 08-22-2021

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 

0 Kudos