Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Re: How to get equation from fit model

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 14, 2017 5:37 PM
(23566 views)

When fitting a model in JMP, it must create an equation to predict the behavior of the response variable from the parameters. Where can that equation be found?

Thanks,

Matt

2 ACCEPTED SOLUTIONS

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Which platform are you using? If you are using Fit Model, under the red triangle you will find options to display the formula, or to save the prediction formula to the data table. This is for the standard least squres. Different personalities will have options for doing similar things.

Under Fit Y by X there is an option under the red triangles to save predicteds.

The Partitioning platform allows for the "Save Predicteds".

If you can provide which modeling platform you are using, and you can not find the red triangle option for the predicted formula, repost to the discussion group with the specifics and I am sure the answers will be provided.

Jim

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Ah, excellent, thanks again. Using the formula from the new column works well.

10 REPLIES 10

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Which platform are you using? If you are using Fit Model, under the red triangle you will find options to display the formula, or to save the prediction formula to the data table. This is for the standard least squres. Different personalities will have options for doing similar things.

Under Fit Y by X there is an option under the red triangles to save predicteds.

The Partitioning platform allows for the "Save Predicteds".

If you can provide which modeling platform you are using, and you can not find the red triangle option for the predicted formula, repost to the discussion group with the specifics and I am sure the answers will be provided.

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to get equation from fit model

Thanks very much, Jim. I'm using Fit Model and Show Prediction Expression appears to be what I'm looking for. Is it possible to copy this out as text? I have a number of expressions I need to implement in Python and they're all fairly complex, but none of the options seem to allow copy/paste.

Matt

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to get equation from fit model

Matt,

The "Show Prediction Expression" displays an image(Picture Box()), not a text field. However, it is a simple step, to generate the Prediction Formula and to capture it. See the script below

```
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
fm = dt << Fit Model(
Y( :height ),
Effects( :weight ),
Personality( "Standard Least Squares" ),
Emphasis( "Effect Leverage" ),
Run(
:height << {Summary of Fit( 1 ), Analysis of Variance( 1 ), Parameter Estimates( 1 ),
Plot Actual by Predicted( 1 ), Plot Residual by Predicted( 1 ),
Plot Effect Leverage( 1 )}
)
);
fm << prediction formula;
equation = Char( Column( dt, N Cols( dt ) ) << get formula );
Show( equation );
```

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to get equation from fit model

Hi Jim,

Unfortunately, my experience with JMP is entirely interactive (not programmatic), and I couldn't make this work. I tried replacing "$SAMPLE_DATA\Big Class.jmp" with my file, and everything inside Fit Model () with the script for my model, but that wasn't enough. There really isn't any way to get the expression(s) as text within the JMP GUI without writing a separate script?

Thanks,

Matt

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to get equation from fit model

You can easily do this interactively.

After you have run your Fit Model, go to the Red Triangle and select

Save Columns==?Prediction Formula

It will create a new column in your data table.

Go to the new data column

Go to the column header for the new column, and right click on it

Select

Formula

The formula editor will popup.

Double click on the blank space within the blue outline around the formula

It will popup a window you can copy from

Jim

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Ah, excellent, thanks again. Using the formula from the new column works well.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to get equation from fit model

I'm working on something similar. I needed to get the published python code so I could save it as a .py and use it later.

```
dt = Open( "/Users/bywing/irisr.csv",End Of Field( Tab, CSV( 1 ) ) );//make sure preferences open CSV as standard CSV
model = dt << Fit Model(
Y( :Name ),
Effects( :Sepal length, :Sepal width, :Petal length, :Petal width ),
Personality( Nominal Logistic ),
Run
);
fd = model << Publish Probability Formulas;
fd << Generate Python Code;
Wait( 0 );
cw = Window( "Python Code Output" );
ed = cw[Script Box( 1 )];
code = ed << get text;
Save Text File( "irismodel.py", code ); // saves generated python code as python script);
Window( "Report: Formula Depot" ) << close window;
```

Note, this script is working with a CSV version of the Iris data, not a JMP table. not something operational, just a short POC

JMP Systems Engineer, Pharm and BioPharm Sciences

Highlighted
##

m100psi: If you are running JMP Pro, you can publish your prediction equation to the Formula Depot and then from the Formula Depot hot spot, choose the "Generate Python Code" option to write the scoring code needed for Python.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to get equation from fit model

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to get equation from fit model

Thanks, Peter, I will try this next. I'm running JMP Pro 11.1.1.

Matt

Article Labels

There are no labels assigned to this post.