- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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...